Migration to 2007 error

[lesiano]

Hi all,

I'm trying to migrate a 2003 ms project server database to a 2007 project
server database and I receive always the same error:

Time to execute P12UpgradeDoc::Load(): 19078 ms
Loading resource global failed with error 80004005
Executing Query update dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set
UPG_PROJ_STATUS = 2, UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID =
1
preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?,
?
Resource global migration failed with error 80004005
**********Phase:Resource global migration end**********

Time to execute CUpgrader::CheckAndUpgradeResGlobal(): 19128 ms
Updating run table
preparing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS =
?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?
Executing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS =
?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?
Migration finished with return code 80004005
Project migration failed.


I have tried using linked servers and I received always the error above.
Right now I have restored the 2003 database in the 2007 server with SQL 2005
and when I try to migrate with the verify options it says that the migration
was successfully but when I try to migrate it gives me the same error.

Some help will be really apreciated.

Thanks in advance.

Pedro

 

[Gordon]

Hi lesiano,

Before migrating the project 2003 database to PS2007 it is important you
follow the guide closely and carefully.

I would recommend you backup and then restore the DB on 2005 then run the
migration process.

Have you conducted all your SQL checks Ex (finding if projects are not
externally edited)

 

[lesiano]

Hi Gordon,

Before I have made the backup I have checked in all workplans and I have run
all SQL checks.

It seems that the error is in the global resources file but I cannot see
anything that can produce this error.

Thanks for your help

Regards

Pedro