logo

Migration 2003-2007 Project Server details

By Rob Haycox
Printer Friendly Version
View My Articles
116 Views
    

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.




Didn't Find The Answer You Were Looking For?

EggHeadCafe has experts online right now that may know the answer to your question.  We pay them a bonus for answering as many questions as they can.  So, why not help them and yourself by becoming a member (free) and ask them your question right now?
Ask Question In Live Forum

If you have an OpenID and do not want to become a member of the EggHeadCafe forum, you can also sign on to Chat Chaos and post your question to our real time Silverlight chat application.
Ask Question In Chat Chaos

Article Discussion: Migration 2003-2007 Project Server details
Rob Haycox posted at Thursday, December 20, 2007 6:16 PM
Original Article
 






  $1000 Contest    [)ia6l0 iii - $228  |  Jonathan VH - $161  |  Huggy Bear - $135  |  F Cali - $95  |  egg egg - $94  |  more Advertise  |  Privacy  |   (c) 2010