Migration of ProjectServer2003 to ProjectServer2007 in single mach

K

Kannan

my VPC has the following

1. Project server 2003 with Service pack sp2a
2. SQL server 2000
3. SQL server 2005
4. Project Server 2007

I have created a PWA and was able to provision the same successfully. My
project server 2003 contains only one project and i am trying to migrate the
same to project server 2007. When i run the migration tool, i get the log as
shown below


08/12/2009 17:55:35.115 Log file Initialized
08/12/2009 17:55:35.115 Migration tool version is 12,0,4518,1014
08/12/2009 17:55:35.115 Configuration file is C:\Documents and
Settings\Kannan\My Documents\P12MIGRATION.INI
08/12/2009 17:55:38.931 Connecting to Project Server 2007 Draft db...
08/12/2009 17:55:39.001 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= Server2003, db = ProjectServer_Draft, trusted = 1
08/12/2009 17:55:39.481 Created DSN MSP-12-WORKING-DB-DSN
08/12/2009 17:55:40.533 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/12/2009 17:55:40.533 Connecting to Project Server 2007 published db...
08/12/2009 17:55:40.553 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = Server2003, db = ProjectServer_Draft, trusted = 1
08/12/2009 17:55:40.583 Created DSN MSP-12-PUBLISHED-DB-DSN
08/12/2009 17:55:40.643 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/12/2009 17:55:40.643 Project Server 2007 url = http://Server2003/pwa
08/12/2009 17:55:40.663 Creating Project Server 2007 soap object...
08/12/2009 17:55:42.456 Creating Project Server 2007 resource soap object...
08/12/2009 17:55:42.546 Creating Project Server 2007 winproj soap object...
08/12/2009 17:55:42.766 Creating Project Server 2007 wssinterop soap
object...
08/12/2009 17:55:42.836 Getting all Upgraded Projects from Project Server
2007
08/12/2009 17:55:42.866 preparing Query select distinct A.UPG_P11_ENT_ID,
A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from
dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B,
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID
AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID =
'CECFE271-6660-4ABE-97ED-208D3C71FC18'
08/12/2009 17:55:43.127 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/12/2009 17:55:43.257 Project Server 2007 Project Server version is
12,0,15,45181014
08/12/2009 17:55:43.267 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********

08/12/2009 17:56:14.802 Initializations succeeded, Starting migration


**********Phase:Migration initialization start**********
08/12/2009 17:56:14.802 Policy to fix up project server security
categories = true.
08/12/2009 17:56:14.832 Policy to never publish master projects = true.
08/12/2009 17:56:14.842 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
08/12/2009 17:56:17.917 Adding to run table
08/12/2009 17:56:17.917 preparing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/12/2009 17:56:18.137 Executing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/12/2009 17:56:18.297 Connecting to Project Server 2003 sql server
project database
08/12/2009 17:56:18.317 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/12/2009 17:56:18.357 Created DSN P11-PROJECT-SERVER-DSN
08/12/2009 17:56:18.528 Connection string
DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/12/2009 17:56:18.528 Connecting to the Project Server 2003 sql server
web database
08/12/2009 17:56:18.538 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/12/2009 17:56:18.558 Created DSN P11-PROJECT-SERVER-WEB-DSN
08/12/2009 17:56:18.608 Connection string
DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/12/2009 17:56:18.608 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/12/2009 17:56:19.299 Project Server 2003 version is 11,0,15,20030816
08/12/2009 17:56:19.309 ERROR: The Project Server 2003 version (major =
11, minor = 0) is not supported for migration. Please upgrade to the latest
service pack and try again.08/12/2009 17:56:19.359 Time to execute
CUpgrader::CheckP11Version(): 751 ms
08/12/2009 17:56:19.369 Updating run table
08/12/2009 17:56:19.369 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/12/2009 17:56:19.369 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/12/2009 17:56:19.479 Migration finished with return code 80004005
08/12/2009 17:56:19.479 Project migration failed.


The migration guide says that i shud have upgraded the project server 2003
install to Service pack sp2a. I have done the same, but i still get this
error. Can somebody let me know the needful that is to be done.

Kannan
 
J

JennPenn07

when you apply the SP to PS2003 you're supposed to update the database server
with this file ProjectServer2003-KB887621-SQLFile-ENU.exe. If you didn't
perhaps that is your problem. Also if you dont get a better answer, you
could apply SP3 to your PS2003 and try again.
 
K

Kannan

Thanks for the reply. regarding the database, i have restored the project
server 2003 database from the SQL Server 2000 on to the SQl server 2005. Now
when i apply this SQL patch, should i apply it to the SQL Server 2000 or the
SQL server 2005? Please let know. if i run Sp3 for project Server 2003, will
this take care of applying the patch on both the project Server 2003 and SQL
server 2005?

Kannan
 
K

Kannan

I did the following

1. backed up the project server 2003 database. This is on SQL Server 2000
2. Restored the project serverr 2003 database on to the SQL server (SQL
Server 2005) for Office Server 2007.
3. Installed the SP2a Update ProjectServer2003-KB887621-SQLFile-ENU on the
restored database.
4. When i run the migration tool, i get the error as shown in the log below

08/13/2009 17:16:51.500 Log file Initialized
08/13/2009 17:16:51.510 Migration tool version is 12,0,4518,1014
08/13/2009 17:16:51.510 Configuration file is C:\Documents and
Settings\Kannan\My Documents\P12MIGRATION.INI
08/13/2009 17:16:54.273 Connecting to Project Server 2007 Draft db...
08/13/2009 17:16:54.374 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:55.205 Created DSN MSP-12-WORKING-DB-DSN
08/13/2009 17:16:56.316 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.316 Connecting to Project Server 2007 published db...
08/13/2009 17:16:56.326 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:56.356 Created DSN MSP-12-PUBLISHED-DB-DSN
08/13/2009 17:16:56.467 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.467 Project Server 2007 url = http://Server2003/pwa
08/13/2009 17:16:56.477 Creating Project Server 2007 soap object...
08/13/2009 17:16:57.839 Creating Project Server 2007 resource soap object...
08/13/2009 17:16:57.909 Creating Project Server 2007 winproj soap object...
08/13/2009 17:16:58.169 Creating Project Server 2007 wssinterop soap
object...
08/13/2009 17:16:58.229 Getting all Upgraded Projects from Project Server
2007
08/13/2009 17:16:58.249 preparing Query select distinct A.UPG_P11_ENT_ID,
A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from
dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B,
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID
AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID =
'CECFE271-6660-4ABE-97ED-208D3C71FC18'
08/13/2009 17:16:58.339 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:16:58.399 Project Server 2007 Project Server version is
12,0,15,45181014
08/13/2009 17:16:58.399 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********
08/13/2009 17:16:59.952 Initializations succeeded, Starting migration

**********Phase:Migration initialization start**********
08/13/2009 17:16:59.952 Policy to fix up project server security
categories = true.
08/13/2009 17:16:59.972 Policy to never publish master projects = true.
08/13/2009 17:16:59.982 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
08/13/2009 17:17:00.613 Adding to run table
08/13/2009 17:17:00.613 preparing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.633 Executing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.743 Connecting to Project Server 2003 sql server
project database
08/13/2009 17:17:00.753 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:00.773 Created DSN P11-PROJECT-SERVER-DSN
08/13/2009 17:17:01.033 Connection string
DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.043 Connecting to the Project Server 2003 sql server
web database
08/13/2009 17:17:01.043 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:01.063 Created DSN P11-PROJECT-SERVER-WEB-DSN
08/13/2009 17:17:01.294 Connection string
DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.314 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.634 Project Server 2003 version is 11,2,15,20030816
08/13/2009 17:17:01.634 Time to execute CUpgrader::CheckP11Version(): 341 ms
08/13/2009 17:17:01.634 preparing Query select WADMIN_DEFAULT_LANGUAGE
from dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.734 preparing Query select WADMIN_DEFAULT_LANGUAGE
from MSP_WEB_ADMIN
08/13/2009 17:17:01.784 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.995 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:03.377 preparing Query select VERS_VERSION from
dbo.MSP_VERSIONS where VERS_DEFAULT = 1
08/13/2009 17:17:03.687 preparing Query select UPG_PHASE_RUN_STATUS from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
08/13/2009 17:17:05.049 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.620 preparing Query exec
dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003 ?, ?
08/13/2009 17:17:05.690 Executing query failed with -1
08/13/2009 17:17:05.690 Cmd failed retcode= -1
08/13/2009 17:17:05.690 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server
Driver][SQL Server]Could not find stored procedure
'dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003'.
08/13/2009 17:17:05.710 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.740 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.750 Time to execute CUpgrader::UpgradePWASetupViews():
2063 ms
08/13/2009 17:17:05.750 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.770 Updating run table
08/13/2009 17:17:05.770 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:05.770 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:06.050 Migration finished with return code 80004005
08/13/2009 17:17:06.050 Project migration failed.

The following is a copy of the contents in the INI file

[General]
LogFilePath=c:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes
[Project Names to Save]
Project PlanBPO.published
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
;The following setting identifies the Project Web Access URL.
Project2007PWAServer=http://Server2003/pwa
Project2007SQLServer=Server2003
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Draft
[Project Server 2003]
Project2003ProjectTablesDB= ProjectServer2003
Project2003WebTablesDB=ProjectServer2003
;Project2003LinkedSQLServer=LinkedSQLServerName

Please let me know what is wrong so that i can get the migration done
successfully

Kannan
 
K

Kannan

Forgot to mention, the SQL Server 2000 and SQL server 2005 are all in the
same machine.

Kannan said:
I did the following

1. backed up the project server 2003 database. This is on SQL Server 2000
2. Restored the project serverr 2003 database on to the SQL server (SQL
Server 2005) for Office Server 2007.
3. Installed the SP2a Update ProjectServer2003-KB887621-SQLFile-ENU on the
restored database.
4. When i run the migration tool, i get the error as shown in the log below

08/13/2009 17:16:51.500 Log file Initialized
08/13/2009 17:16:51.510 Migration tool version is 12,0,4518,1014
08/13/2009 17:16:51.510 Configuration file is C:\Documents and
Settings\Kannan\My Documents\P12MIGRATION.INI
08/13/2009 17:16:54.273 Connecting to Project Server 2007 Draft db...
08/13/2009 17:16:54.374 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:55.205 Created DSN MSP-12-WORKING-DB-DSN
08/13/2009 17:16:56.316 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.316 Connecting to Project Server 2007 published db...
08/13/2009 17:16:56.326 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:56.356 Created DSN MSP-12-PUBLISHED-DB-DSN
08/13/2009 17:16:56.467 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.467 Project Server 2007 url = http://Server2003/pwa
08/13/2009 17:16:56.477 Creating Project Server 2007 soap object...
08/13/2009 17:16:57.839 Creating Project Server 2007 resource soap object...
08/13/2009 17:16:57.909 Creating Project Server 2007 winproj soap object...
08/13/2009 17:16:58.169 Creating Project Server 2007 wssinterop soap
object...
08/13/2009 17:16:58.229 Getting all Upgraded Projects from Project Server
2007
08/13/2009 17:16:58.249 preparing Query select distinct A.UPG_P11_ENT_ID,
A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from
dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B,
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID
AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID =
'CECFE271-6660-4ABE-97ED-208D3C71FC18'
08/13/2009 17:16:58.339 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:16:58.399 Project Server 2007 Project Server version is
12,0,15,45181014
08/13/2009 17:16:58.399 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********
08/13/2009 17:16:59.952 Initializations succeeded, Starting migration

**********Phase:Migration initialization start**********
08/13/2009 17:16:59.952 Policy to fix up project server security
categories = true.
08/13/2009 17:16:59.972 Policy to never publish master projects = true.
08/13/2009 17:16:59.982 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
08/13/2009 17:17:00.613 Adding to run table
08/13/2009 17:17:00.613 preparing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.633 Executing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.743 Connecting to Project Server 2003 sql server
project database
08/13/2009 17:17:00.753 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:00.773 Created DSN P11-PROJECT-SERVER-DSN
08/13/2009 17:17:01.033 Connection string
DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.043 Connecting to the Project Server 2003 sql server
web database
08/13/2009 17:17:01.043 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:01.063 Created DSN P11-PROJECT-SERVER-WEB-DSN
08/13/2009 17:17:01.294 Connection string
DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.314 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.634 Project Server 2003 version is 11,2,15,20030816
08/13/2009 17:17:01.634 Time to execute CUpgrader::CheckP11Version(): 341 ms
08/13/2009 17:17:01.634 preparing Query select WADMIN_DEFAULT_LANGUAGE
from dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.734 preparing Query select WADMIN_DEFAULT_LANGUAGE
from MSP_WEB_ADMIN
08/13/2009 17:17:01.784 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.995 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:03.377 preparing Query select VERS_VERSION from
dbo.MSP_VERSIONS where VERS_DEFAULT = 1
08/13/2009 17:17:03.687 preparing Query select UPG_PHASE_RUN_STATUS from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
08/13/2009 17:17:05.049 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.620 preparing Query exec
dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003 ?, ?
08/13/2009 17:17:05.690 Executing query failed with -1
08/13/2009 17:17:05.690 Cmd failed retcode= -1
08/13/2009 17:17:05.690 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server
Driver][SQL Server]Could not find stored procedure
'dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003'.
08/13/2009 17:17:05.710 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.740 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.750 Time to execute CUpgrader::UpgradePWASetupViews():
2063 ms
08/13/2009 17:17:05.750 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.770 Updating run table
08/13/2009 17:17:05.770 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:05.770 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:06.050 Migration finished with return code 80004005
08/13/2009 17:17:06.050 Project migration failed.

The following is a copy of the contents in the INI file

[General]
LogFilePath=c:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes
[Project Names to Save]
Project PlanBPO.published
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
;The following setting identifies the Project Web Access URL.
Project2007PWAServer=http://Server2003/pwa
Project2007SQLServer=Server2003
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Draft
[Project Server 2003]
Project2003ProjectTablesDB= ProjectServer2003
Project2003WebTablesDB=ProjectServer2003
;Project2003LinkedSQLServer=LinkedSQLServerName

Please let me know what is wrong so that i can get the migration done
successfully

Kannan

Kannan said:
Thanks for the reply. regarding the database, i have restored the project
server 2003 database from the SQL Server 2000 on to the SQl server 2005. Now
when i apply this SQL patch, should i apply it to the SQL Server 2000 or the
SQL server 2005? Please let know. if i run Sp3 for project Server 2003, will
this take care of applying the patch on both the project Server 2003 and SQL
server 2005?

Kannan
Click to expand...
Click to expand...
 
J

JennPenn07

Hi Kannan,

You should verify the data in your migration file. For example, it looks
like you used the 2003PWA link where you should have put the 2007PWA link.
You have:
Project2007PWAServer=http://Server2003/pwa
Project2007SQLServer=Server2003
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Draft

should be:
Project2007PWAServer=http://Server2007/pwa
Project2007SQLServer= name of SQLServer2005/wfresh ps2007 DBs
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published

Are you using this migration guide:
http://technet.microsoft.com/en-us/library/cc197505.aspx ?
I hope this helps.

Kannan said:
I did the following

1. backed up the project server 2003 database. This is on SQL Server 2000
2. Restored the project serverr 2003 database on to the SQL server (SQL
Server 2005) for Office Server 2007.
3. Installed the SP2a Update ProjectServer2003-KB887621-SQLFile-ENU on the
restored database.
4. When i run the migration tool, i get the error as shown in the log below

08/13/2009 17:16:51.500 Log file Initialized
08/13/2009 17:16:51.510 Migration tool version is 12,0,4518,1014
08/13/2009 17:16:51.510 Configuration file is C:\Documents and
Settings\Kannan\My Documents\P12MIGRATION.INI
08/13/2009 17:16:54.273 Connecting to Project Server 2007 Draft db...
08/13/2009 17:16:54.374 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:55.205 Created DSN MSP-12-WORKING-DB-DSN
08/13/2009 17:16:56.316 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.316 Connecting to Project Server 2007 published db...
08/13/2009 17:16:56.326 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:56.356 Created DSN MSP-12-PUBLISHED-DB-DSN
08/13/2009 17:16:56.467 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.467 Project Server 2007 url = http://Server2003/pwa
08/13/2009 17:16:56.477 Creating Project Server 2007 soap object...
08/13/2009 17:16:57.839 Creating Project Server 2007 resource soap object...
08/13/2009 17:16:57.909 Creating Project Server 2007 winproj soap object...
08/13/2009 17:16:58.169 Creating Project Server 2007 wssinterop soap
object...
08/13/2009 17:16:58.229 Getting all Upgraded Projects from Project Server
2007
08/13/2009 17:16:58.249 preparing Query select distinct A.UPG_P11_ENT_ID,
A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from
dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B,
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID
AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID =
'CECFE271-6660-4ABE-97ED-208D3C71FC18'
08/13/2009 17:16:58.339 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:16:58.399 Project Server 2007 Project Server version is
12,0,15,45181014
08/13/2009 17:16:58.399 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********
08/13/2009 17:16:59.952 Initializations succeeded, Starting migration

**********Phase:Migration initialization start**********
08/13/2009 17:16:59.952 Policy to fix up project server security
categories = true.
08/13/2009 17:16:59.972 Policy to never publish master projects = true.
08/13/2009 17:16:59.982 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
08/13/2009 17:17:00.613 Adding to run table
08/13/2009 17:17:00.613 preparing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.633 Executing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.743 Connecting to Project Server 2003 sql server
project database
08/13/2009 17:17:00.753 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:00.773 Created DSN P11-PROJECT-SERVER-DSN
08/13/2009 17:17:01.033 Connection string
DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.043 Connecting to the Project Server 2003 sql server
web database
08/13/2009 17:17:01.043 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:01.063 Created DSN P11-PROJECT-SERVER-WEB-DSN
08/13/2009 17:17:01.294 Connection string
DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.314 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.634 Project Server 2003 version is 11,2,15,20030816
08/13/2009 17:17:01.634 Time to execute CUpgrader::CheckP11Version(): 341 ms
08/13/2009 17:17:01.634 preparing Query select WADMIN_DEFAULT_LANGUAGE
from dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.734 preparing Query select WADMIN_DEFAULT_LANGUAGE
from MSP_WEB_ADMIN
08/13/2009 17:17:01.784 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.995 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:03.377 preparing Query select VERS_VERSION from
dbo.MSP_VERSIONS where VERS_DEFAULT = 1
08/13/2009 17:17:03.687 preparing Query select UPG_PHASE_RUN_STATUS from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
08/13/2009 17:17:05.049 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.620 preparing Query exec
dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003 ?, ?
08/13/2009 17:17:05.690 Executing query failed with -1
08/13/2009 17:17:05.690 Cmd failed retcode= -1
08/13/2009 17:17:05.690 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server
Driver][SQL Server]Could not find stored procedure
'dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003'.
08/13/2009 17:17:05.710 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.740 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.750 Time to execute CUpgrader::UpgradePWASetupViews():
2063 ms
08/13/2009 17:17:05.750 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.770 Updating run table
08/13/2009 17:17:05.770 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:05.770 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:06.050 Migration finished with return code 80004005
08/13/2009 17:17:06.050 Project migration failed.

The following is a copy of the contents in the INI file

[General]
LogFilePath=c:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes
[Project Names to Save]
Project PlanBPO.published
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
;The following setting identifies the Project Web Access URL.
Project2007PWAServer=http://Server2003/pwa
Project2007SQLServer=Server2003
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Draft
[Project Server 2003]
Project2003ProjectTablesDB= ProjectServer2003
Project2003WebTablesDB=ProjectServer2003
;Project2003LinkedSQLServer=LinkedSQLServerName

Please let me know what is wrong so that i can get the migration done
successfully

Kannan

Kannan said:
Thanks for the reply. regarding the database, i have restored the project
server 2003 database from the SQL Server 2000 on to the SQl server 2005. Now
when i apply this SQL patch, should i apply it to the SQL Server 2000 or the
SQL server 2005? Please let know. if i run Sp3 for project Server 2003, will
this take care of applying the patch on both the project Server 2003 and SQL
server 2005?

Kannan
Click to expand...
Click to expand...
 
K

Kannan

Thanks for the reply

The name of the server that hosts the project Server 2007 is Server2003. I
anyways got through the migration and it is succesful. I had a problem in the
config file. I had the migration tool point to the wrong DB for the publoshed
database. I set that right and i have done the migration successfully

Kannan

JennPenn07 said:
Hi Kannan,

You should verify the data in your migration file. For example, it looks
like you used the 2003PWA link where you should have put the 2007PWA link.
You have:
Project2007PWAServer=http://Server2003/pwa
Project2007SQLServer=Server2003
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Draft

should be:
Project2007PWAServer=http://Server2007/pwa
Project2007SQLServer= name of SQLServer2005/wfresh ps2007 DBs
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published

Are you using this migration guide:
http://technet.microsoft.com/en-us/library/cc197505.aspx ?
I hope this helps.

Kannan said:
I did the following

1. backed up the project server 2003 database. This is on SQL Server 2000
2. Restored the project serverr 2003 database on to the SQL server (SQL
Server 2005) for Office Server 2007.
3. Installed the SP2a Update ProjectServer2003-KB887621-SQLFile-ENU on the
restored database.
4. When i run the migration tool, i get the error as shown in the log below

08/13/2009 17:16:51.500 Log file Initialized
08/13/2009 17:16:51.510 Migration tool version is 12,0,4518,1014
08/13/2009 17:16:51.510 Configuration file is C:\Documents and
Settings\Kannan\My Documents\P12MIGRATION.INI
08/13/2009 17:16:54.273 Connecting to Project Server 2007 Draft db...
08/13/2009 17:16:54.374 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:55.205 Created DSN MSP-12-WORKING-DB-DSN
08/13/2009 17:16:56.316 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.316 Connecting to Project Server 2007 published db...
08/13/2009 17:16:56.326 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:56.356 Created DSN MSP-12-PUBLISHED-DB-DSN
08/13/2009 17:16:56.467 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.467 Project Server 2007 url = http://Server2003/pwa
08/13/2009 17:16:56.477 Creating Project Server 2007 soap object...
08/13/2009 17:16:57.839 Creating Project Server 2007 resource soap object...
08/13/2009 17:16:57.909 Creating Project Server 2007 winproj soap object...
08/13/2009 17:16:58.169 Creating Project Server 2007 wssinterop soap
object...
08/13/2009 17:16:58.229 Getting all Upgraded Projects from Project Server
2007
08/13/2009 17:16:58.249 preparing Query select distinct A.UPG_P11_ENT_ID,
A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from
dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B,
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID
AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID =
'CECFE271-6660-4ABE-97ED-208D3C71FC18'
08/13/2009 17:16:58.339 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:16:58.399 Project Server 2007 Project Server version is
12,0,15,45181014
08/13/2009 17:16:58.399 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********
08/13/2009 17:16:59.952 Initializations succeeded, Starting migration

**********Phase:Migration initialization start**********
08/13/2009 17:16:59.952 Policy to fix up project server security
categories = true.
08/13/2009 17:16:59.972 Policy to never publish master projects = true.
08/13/2009 17:16:59.982 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
08/13/2009 17:17:00.613 Adding to run table
08/13/2009 17:17:00.613 preparing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.633 Executing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.743 Connecting to Project Server 2003 sql server
project database
08/13/2009 17:17:00.753 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:00.773 Created DSN P11-PROJECT-SERVER-DSN
08/13/2009 17:17:01.033 Connection string
DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.043 Connecting to the Project Server 2003 sql server
web database
08/13/2009 17:17:01.043 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:01.063 Created DSN P11-PROJECT-SERVER-WEB-DSN
08/13/2009 17:17:01.294 Connection string
DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.314 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.634 Project Server 2003 version is 11,2,15,20030816
08/13/2009 17:17:01.634 Time to execute CUpgrader::CheckP11Version(): 341 ms
08/13/2009 17:17:01.634 preparing Query select WADMIN_DEFAULT_LANGUAGE
from dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.734 preparing Query select WADMIN_DEFAULT_LANGUAGE
from MSP_WEB_ADMIN
08/13/2009 17:17:01.784 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.995 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:03.377 preparing Query select VERS_VERSION from
dbo.MSP_VERSIONS where VERS_DEFAULT = 1
08/13/2009 17:17:03.687 preparing Query select UPG_PHASE_RUN_STATUS from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
08/13/2009 17:17:05.049 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.620 preparing Query exec
dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003 ?, ?
08/13/2009 17:17:05.690 Executing query failed with -1
08/13/2009 17:17:05.690 Cmd failed retcode= -1
08/13/2009 17:17:05.690 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server
Driver][SQL Server]Could not find stored procedure
'dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003'.
08/13/2009 17:17:05.710 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.740 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.750 Time to execute CUpgrader::UpgradePWASetupViews():
2063 ms
08/13/2009 17:17:05.750 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.770 Updating run table
08/13/2009 17:17:05.770 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:05.770 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:06.050 Migration finished with return code 80004005
08/13/2009 17:17:06.050 Project migration failed.

The following is a copy of the contents in the INI file

[General]
LogFilePath=c:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes
[Project Names to Save]
Project PlanBPO.published
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
;The following setting identifies the Project Web Access URL.
Project2007PWAServer=http://Server2003/pwa
Project2007SQLServer=Server2003
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Draft
[Project Server 2003]
Project2003ProjectTablesDB= ProjectServer2003
Project2003WebTablesDB=ProjectServer2003
;Project2003LinkedSQLServer=LinkedSQLServerName

Please let me know what is wrong so that i can get the migration done
successfully

Kannan

Kannan said:
Thanks for the reply. regarding the database, i have restored the project
server 2003 database from the SQL Server 2000 on to the SQl server 2005. Now
when i apply this SQL patch, should i apply it to the SQL Server 2000 or the
SQL server 2005? Please let know. if i run Sp3 for project Server 2003, will
this take care of applying the patch on both the project Server 2003 and SQL
server 2005?

Kannan

:

when you apply the SP to PS2003 you're supposed to update the database server
with this file ProjectServer2003-KB887621-SQLFile-ENU.exe. If you didn't
perhaps that is your problem. Also if you dont get a better answer, you
could apply SP3 to your PS2003 and try again.

:

my VPC has the following

1. Project server 2003 with Service pack sp2a
2. SQL server 2000
3. SQL server 2005
4. Project Server 2007

I have created a PWA and was able to provision the same successfully. My
project server 2003 contains only one project and i am trying to migrate the
same to project server 2007. When i run the migration tool, i get the log as
shown below


08/12/2009 17:55:35.115 Log file Initialized
08/12/2009 17:55:35.115 Migration tool version is 12,0,4518,1014
08/12/2009 17:55:35.115 Configuration file is C:\Documents and
Settings\Kannan\My Documents\P12MIGRATION.INI
08/12/2009 17:55:38.931 Connecting to Project Server 2007 Draft db...
08/12/2009 17:55:39.001 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= Server2003, db = ProjectServer_Draft, trusted = 1
08/12/2009 17:55:39.481 Created DSN MSP-12-WORKING-DB-DSN
08/12/2009 17:55:40.533 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/12/2009 17:55:40.533 Connecting to Project Server 2007 published db...
08/12/2009 17:55:40.553 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = Server2003, db = ProjectServer_Draft, trusted = 1
08/12/2009 17:55:40.583 Created DSN MSP-12-PUBLISHED-DB-DSN
08/12/2009 17:55:40.643 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/12/2009 17:55:40.643 Project Server 2007 url = http://Server2003/pwa
08/12/2009 17:55:40.663 Creating Project Server 2007 soap object...
08/12/2009 17:55:42.456 Creating Project Server 2007 resource soap object...
08/12/2009 17:55:42.546 Creating Project Server 2007 winproj soap object...
08/12/2009 17:55:42.766 Creating Project Server 2007 wssinterop soap
object...
08/12/2009 17:55:42.836 Getting all Upgraded Projects from Project Server
2007
08/12/2009 17:55:42.866 preparing Query select distinct A.UPG_P11_ENT_ID,
A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from
dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B,
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID
AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID =
'CECFE271-6660-4ABE-97ED-208D3C71FC18'
08/12/2009 17:55:43.127 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/12/2009 17:55:43.257 Project Server 2007 Project Server version is
12,0,15,45181014
08/12/2009 17:55:43.267 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********

08/12/2009 17:56:14.802 Initializations succeeded, Starting migration


**********Phase:Migration initialization start**********
08/12/2009 17:56:14.802 Policy to fix up project server security
categories = true.
08/12/2009 17:56:14.832 Policy to never publish master projects = true.
08/12/2009 17:56:14.842 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
08/12/2009 17:56:17.917 Adding to run table
08/12/2009 17:56:17.917 preparing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/12/2009 17:56:18.137 Executing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/12/2009 17:56:18.297 Connecting to Project Server 2003 sql server
project database
08/12/2009 17:56:18.317 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/12/2009 17:56:18.357 Created DSN P11-PROJECT-SERVER-DSN
08/12/2009 17:56:18.528 Connection string
DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/12/2009 17:56:18.528 Connecting to the Project Server 2003 sql server
web database
08/12/2009 17:56:18.538 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/12/2009 17:56:18.558 Created DSN P11-PROJECT-SERVER-WEB-DSN
08/12/2009 17:56:18.608 Connection string
DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/12/2009 17:56:18.608 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/12/2009 17:56:19.299 Project Server 2003 version is 11,0,15,20030816
08/12/2009 17:56:19.309 ERROR: The Project Server 2003 version (major =
11, minor = 0) is not supported for migration. Please upgrade to the latest
service pack and try again.08/12/2009 17:56:19.359 Time to execute
CUpgrader::CheckP11Version(): 751 ms
08/12/2009 17:56:19.369 Updating run table
08/12/2009 17:56:19.369 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/12/2009 17:56:19.369 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/12/2009 17:56:19.479 Migration finished with return code 80004005
08/12/2009 17:56:19.479 Project migration failed.
Click to expand...
Click to expand...
Click to expand...
 
K

Kannan

Thanks for the reply. Typo in the config file. That caused the problem.
Thanks for pointing out the same. That was of help

Kannan said:
Thanks for the reply

The name of the server that hosts the project Server 2007 is Server2003. I
anyways got through the migration and it is succesful. I had a problem in the
config file. I had the migration tool point to the wrong DB for the publoshed
database. I set that right and i have done the migration successfully

Kannan

JennPenn07 said:
Hi Kannan,

You should verify the data in your migration file. For example, it looks
like you used the 2003PWA link where you should have put the 2007PWA link.
You have:
Project2007PWAServer=http://Server2003/pwa
Project2007SQLServer=Server2003
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Draft

should be:
Project2007PWAServer=http://Server2007/pwa
Project2007SQLServer= name of SQLServer2005/wfresh ps2007 DBs
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published

Are you using this migration guide:
http://technet.microsoft.com/en-us/library/cc197505.aspx ?
I hope this helps.

Kannan said:
I did the following

1. backed up the project server 2003 database. This is on SQL Server 2000
2. Restored the project serverr 2003 database on to the SQL server (SQL
Server 2005) for Office Server 2007.
3. Installed the SP2a Update ProjectServer2003-KB887621-SQLFile-ENU on the
restored database.
4. When i run the migration tool, i get the error as shown in the log below

08/13/2009 17:16:51.500 Log file Initialized
08/13/2009 17:16:51.510 Migration tool version is 12,0,4518,1014
08/13/2009 17:16:51.510 Configuration file is C:\Documents and
Settings\Kannan\My Documents\P12MIGRATION.INI
08/13/2009 17:16:54.273 Connecting to Project Server 2007 Draft db...
08/13/2009 17:16:54.374 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:55.205 Created DSN MSP-12-WORKING-DB-DSN
08/13/2009 17:16:56.316 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.316 Connecting to Project Server 2007 published db...
08/13/2009 17:16:56.326 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = Server2003, db = ProjectServer_Draft, trusted = 1
08/13/2009 17:16:56.356 Created DSN MSP-12-PUBLISHED-DB-DSN
08/13/2009 17:16:56.467 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/13/2009 17:16:56.467 Project Server 2007 url = http://Server2003/pwa
08/13/2009 17:16:56.477 Creating Project Server 2007 soap object...
08/13/2009 17:16:57.839 Creating Project Server 2007 resource soap object...
08/13/2009 17:16:57.909 Creating Project Server 2007 winproj soap object...
08/13/2009 17:16:58.169 Creating Project Server 2007 wssinterop soap
object...
08/13/2009 17:16:58.229 Getting all Upgraded Projects from Project Server
2007
08/13/2009 17:16:58.249 preparing Query select distinct A.UPG_P11_ENT_ID,
A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from
dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B,
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID
AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID =
'CECFE271-6660-4ABE-97ED-208D3C71FC18'
08/13/2009 17:16:58.339 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:16:58.399 Project Server 2007 Project Server version is
12,0,15,45181014
08/13/2009 17:16:58.399 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********
08/13/2009 17:16:59.952 Initializations succeeded, Starting migration

**********Phase:Migration initialization start**********
08/13/2009 17:16:59.952 Policy to fix up project server security
categories = true.
08/13/2009 17:16:59.972 Policy to never publish master projects = true.
08/13/2009 17:16:59.982 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
08/13/2009 17:17:00.613 Adding to run table
08/13/2009 17:17:00.613 preparing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.633 Executing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/13/2009 17:17:00.743 Connecting to Project Server 2003 sql server
project database
08/13/2009 17:17:00.753 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:00.773 Created DSN P11-PROJECT-SERVER-DSN
08/13/2009 17:17:01.033 Connection string
DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.043 Connecting to the Project Server 2003 sql server
web database
08/13/2009 17:17:01.043 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/13/2009 17:17:01.063 Created DSN P11-PROJECT-SERVER-WEB-DSN
08/13/2009 17:17:01.294 Connection string
DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/13/2009 17:17:01.314 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.634 Project Server 2003 version is 11,2,15,20030816
08/13/2009 17:17:01.634 Time to execute CUpgrader::CheckP11Version(): 341 ms
08/13/2009 17:17:01.634 preparing Query select WADMIN_DEFAULT_LANGUAGE
from dbo.MSP_WEB_ADMIN
08/13/2009 17:17:01.734 preparing Query select WADMIN_DEFAULT_LANGUAGE
from MSP_WEB_ADMIN
08/13/2009 17:17:01.784 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:01.995 preparing Query select isnull(is_member(?), 0)
08/13/2009 17:17:03.377 preparing Query select VERS_VERSION from
dbo.MSP_VERSIONS where VERS_DEFAULT = 1
08/13/2009 17:17:03.687 preparing Query select UPG_PHASE_RUN_STATUS from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
08/13/2009 17:17:05.049 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.620 preparing Query exec
dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003 ?, ?
08/13/2009 17:17:05.690 Executing query failed with -1
08/13/2009 17:17:05.690 Cmd failed retcode= -1
08/13/2009 17:17:05.690 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server
Driver][SQL Server]Could not find stored procedure
'dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003'.
08/13/2009 17:17:05.710 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
08/13/2009 17:17:05.740 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.750 Time to execute CUpgrader::UpgradePWASetupViews():
2063 ms
08/13/2009 17:17:05.750 PWA Migration: Setup Views to Project Server 2003
-- Failed.
08/13/2009 17:17:05.770 Updating run table
08/13/2009 17:17:05.770 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:05.770 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
08/13/2009 17:17:06.050 Migration finished with return code 80004005
08/13/2009 17:17:06.050 Project migration failed.

The following is a copy of the contents in the INI file

[General]
LogFilePath=c:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes
[Project Names to Save]
Project PlanBPO.published
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
;The following setting identifies the Project Web Access URL.
Project2007PWAServer=http://Server2003/pwa
Project2007SQLServer=Server2003
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Draft
[Project Server 2003]
Project2003ProjectTablesDB= ProjectServer2003
Project2003WebTablesDB=ProjectServer2003
;Project2003LinkedSQLServer=LinkedSQLServerName

Please let me know what is wrong so that i can get the migration done
successfully

Kannan

:

Thanks for the reply. regarding the database, i have restored the project
server 2003 database from the SQL Server 2000 on to the SQl server 2005. Now
when i apply this SQL patch, should i apply it to the SQL Server 2000 or the
SQL server 2005? Please let know. if i run Sp3 for project Server 2003, will
this take care of applying the patch on both the project Server 2003 and SQL
server 2005?

Kannan

:

when you apply the SP to PS2003 you're supposed to update the database server
with this file ProjectServer2003-KB887621-SQLFile-ENU.exe. If you didn't
perhaps that is your problem. Also if you dont get a better answer, you
could apply SP3 to your PS2003 and try again.

:

my VPC has the following

1. Project server 2003 with Service pack sp2a
2. SQL server 2000
3. SQL server 2005
4. Project Server 2007

I have created a PWA and was able to provision the same successfully. My
project server 2003 contains only one project and i am trying to migrate the
same to project server 2007. When i run the migration tool, i get the log as
shown below


08/12/2009 17:55:35.115 Log file Initialized
08/12/2009 17:55:35.115 Migration tool version is 12,0,4518,1014
08/12/2009 17:55:35.115 Configuration file is C:\Documents and
Settings\Kannan\My Documents\P12MIGRATION.INI
08/12/2009 17:55:38.931 Connecting to Project Server 2007 Draft db...
08/12/2009 17:55:39.001 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= Server2003, db = ProjectServer_Draft, trusted = 1
08/12/2009 17:55:39.481 Created DSN MSP-12-WORKING-DB-DSN
08/12/2009 17:55:40.533 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/12/2009 17:55:40.533 Connecting to Project Server 2007 published db...
08/12/2009 17:55:40.553 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = Server2003, db = ProjectServer_Draft, trusted = 1
08/12/2009 17:55:40.583 Created DSN MSP-12-PUBLISHED-DB-DSN
08/12/2009 17:55:40.643 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes
08/12/2009 17:55:40.643 Project Server 2007 url = http://Server2003/pwa
08/12/2009 17:55:40.663 Creating Project Server 2007 soap object...
08/12/2009 17:55:42.456 Creating Project Server 2007 resource soap object...
08/12/2009 17:55:42.546 Creating Project Server 2007 winproj soap object...
08/12/2009 17:55:42.766 Creating Project Server 2007 wssinterop soap
object...
08/12/2009 17:55:42.836 Getting all Upgraded Projects from Project Server
2007
08/12/2009 17:55:42.866 preparing Query select distinct A.UPG_P11_ENT_ID,
A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from
dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B,
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID
AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID =
'CECFE271-6660-4ABE-97ED-208D3C71FC18'
08/12/2009 17:55:43.127 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/12/2009 17:55:43.257 Project Server 2007 Project Server version is
12,0,15,45181014
08/12/2009 17:55:43.267 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********

08/12/2009 17:56:14.802 Initializations succeeded, Starting migration


**********Phase:Migration initialization start**********
08/12/2009 17:56:14.802 Policy to fix up project server security
categories = true.
08/12/2009 17:56:14.832 Policy to never publish master projects = true.
08/12/2009 17:56:14.842 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
08/12/2009 17:56:17.917 Adding to run table
08/12/2009 17:56:17.917 preparing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/12/2009 17:56:18.137 Executing Query insert into
dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME,
UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())
08/12/2009 17:56:18.297 Connecting to Project Server 2003 sql server
project database
08/12/2009 17:56:18.317 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/12/2009 17:56:18.357 Created DSN P11-PROJECT-SERVER-DSN
08/12/2009 17:56:18.528 Connection string
DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/12/2009 17:56:18.528 Connecting to the Project Server 2003 sql server
web database
08/12/2009 17:56:18.538 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN,
server = Server2003, db = ProjectServer2003, trusted = 1
08/12/2009 17:56:18.558 Created DSN P11-PROJECT-SERVER-WEB-DSN
08/12/2009 17:56:18.608 Connection string
DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes
08/12/2009 17:56:18.608 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
08/12/2009 17:56:19.299 Project Server 2003 version is 11,0,15,20030816
08/12/2009 17:56:19.309 ERROR: The Project Server 2003 version (major =
11, minor = 0) is not supported for migration. Please upgrade to the latest
service pack and try again.08/12/2009 17:56:19.359 Time to execute
CUpgrader::CheckP11Version(): 751 ms
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

migration tool errors 3
Migration of ProjectServer2003 to ProjectServer2007 in single mach 1
Problem migrating data from project2k3server to project2k7server 0
2007 Migration - Invalid DSN 1
PS2003 - PS2007 migration. One project will not migrate, all others fine. 6
problems migrating project2k3server data to project2k7server 0
Migration Tool - Eglobal error message 3
Migration tool fails to migrate project without throwing any error 2

Top