Migration 2003-2007 Project Server details

I am running a migration of 2003 Project server data to 2007 - This is the error msg I get - Anyone assist? 12/20/2007 16:08:42.165 Log file Initialized 12/20/2007 16:08:42.165 Migration tool version is 12,0,4518,1014 12/20/2007 16:08:42.165 Configuration file is C:\ProjectServer2007Migration\P12Migration.ini 12/20/2007 16:08:43.337 Connecting to Project Server 2007 Draft db... 12/20/2007 16:08:43.415 Creating DSN: name = MSP-12-WORKING-DB-DSN, server = ESPROJ2, db = Projectserv

12/20/2007 16:08:42.165   Log file Initialized
12/20/2007 16:08:42.165   Migration tool version is 12,0,4518,1014
12/20/2007 16:08:42.165   Configuration file is C:\ProjectServer2007Migration\P12Migration.ini
12/20/2007 16:08:43.337   Connecting to Project Server 2007 Draft db...
12/20/2007 16:08:43.415   Creating DSN: name = MSP-12-WORKING-DB-DSN, server = ESPROJ2, db = Projectserver_Draft, trusted = 1
12/20/2007 16:08:43.555   Created DSN MSP-12-WORKING-DB-DSN
12/20/2007 16:08:43.665   Connection string DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office system;WSID=ESPROJ2;DATABASE=Projectserver_Draft;Trusted_Connection=Yes
12/20/2007 16:08:43.665   Connecting to Project Server 2007 published db...
12/20/2007 16:08:43.665   Creating DSN: name = MSP-12-PUBLISHED-DB-DSN, server = ESPROJ2, db = ProjectServer_Published, trusted = 1
12/20/2007 16:08:43.665   Created DSN MSP-12-PUBLISHED-DB-DSN
12/20/2007 16:08:43.665   Connection string DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office system;WSID=ESPROJ2;DATABASE=ProjectServer_Published;Trusted_Connection=Yes
12/20/2007 16:08:43.665   Project Server 2007 url = http://esproj2/pwa
12/20/2007 16:08:43.665   Creating Project Server 2007 soap object...
12/20/2007 16:08:44.649   Creating Project Server 2007 resource soap object...
12/20/2007 16:08:45.134   Creating Project Server 2007 winproj soap object...
12/20/2007 16:08:45.571   Creating Project Server 2007 wssinterop soap object...
12/20/2007 16:08:45.587   Getting all Upgraded Projects from Project Server 2007
12/20/2007 16:08:45.618   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'
12/20/2007 16:08:45.696   preparing Query select WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from dbo.MSP_WEB_ADMIN
12/20/2007 16:08:45.696   Project Server 2007 Project Server version is 12,0,15,45181014
12/20/2007 16:08:45.696   Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********

12/20/2007 16:08:49.946   Initializations succeeded, Starting migration


**********Phase:Migration initialization start**********
12/20/2007 16:08:49.946   Policy to fix up project server security categories = true.
12/20/2007 16:08:49.946   Policy to never publish master projects = true.
12/20/2007 16:08:49.946   WARNING: Projects will be migrated even if they have multiple status managers for the same task.
12/20/2007 16:08:50.118   Adding to run table
12/20/2007 16:08:50.118   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())
12/20/2007 16:08:50.134   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())
12/20/2007 16:08:50.181   Connecting to Project Server 2003 sql server project database
12/20/2007 16:08:50.181   Creating DSN: name = P11-PROJECT-SERVER-DSN, server = ESPROJ2, db = ProjectServer2007_1, trusted = 1
12/20/2007 16:08:50.181   Created DSN P11-PROJECT-SERVER-DSN
12/20/2007 16:08:50.196   Connection string DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office system;WSID=ESPROJ2;DATABASE=ProjectServer2007_1;Trusted_Connection=Yes
12/20/2007 16:08:50.196   Connecting to the Project Server 2003 sql server web database
12/20/2007 16:08:50.196   Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN, server = ESPROJ2, db = ProjectServer2007_1, trusted = 1
12/20/2007 16:08:50.196   Created DSN P11-PROJECT-SERVER-WEB-DSN
12/20/2007 16:08:50.196   Connection string DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office system;WSID=ESPROJ2;DATABASE=ProjectServer2007_1;Trusted_Connection=Yes
12/20/2007 16:08:50.196   preparing Query select WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from dbo.MSP_WEB_ADMIN
12/20/2007 16:08:50.196   Executing query failed with -1
12/20/2007 16:08:50.196   Cmd failed retcode= -1
12/20/2007 16:08:50.196   Err1 = S0002 Err2 = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.MSP_WEB_ADMIN'.
12/20/2007 16:08:50.196   cmd.Execute failed with status hr = 80004005
12/20/2007 16:08:50.196   g_p11Comm.GetProjectServerVersion failed with 80004005
12/20/2007 16:08:50.196   Time to execute CUpgrader::CheckP11Version(): 0 ms
12/20/2007 16:08:50.196   Updating run table
12/20/2007 16:08:50.196   preparing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?
12/20/2007 16:08:50.196   Executing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?
12/20/2007 16:08:50.227   Migration finished with return code 80004005
12/20/2007 16:08:50.227   Project migration failed.

By Rob Haycox   Popularity  (1594 Views)