Tags: Project 2007, Project Server 2003, Project Server 2007, Project Server 2010, PS2003, PS2007, PS2010
I recently worked on a project to migrate from Project Server 2003 to Project Server 2010. While running the P12 migration tool the error below was thrown in the command prompt window:
PWA Migration: Setup views to Project Server 2003 – Failed
The Log file details for the error were as follows:
Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server Drive][SQL Server] could not find server ‘server name’ in sys.servers. Verify that the correct server name was specified. If necessary, execute the sp_addlinkedserver to add the server.
Migration finished with error return code 80004005.
Running the –verify switch completed successfully but running the actual migration failed.
This is due to using an FQDN or DNS Alias name for the SQL Server in the P12 configuration file rather than the actual short name for the SQL Server. After updating the configuration file “Project2007SQLServer” value the migration ran successfully.
Tags: Project Server 2003, Project Server 2007, PS2003, PS2007
I came across an issue today running the P12 migration tool and thought I would share the error and simple fix. The command prompt didn’t update for around an hour, the last entry mentioned about custom field name conflicts. Looking in the log file it was just repeating the following messages:
Received serializer callback: 4
Waiting for Job to be Processed. percentage complete: 0
Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms
After looking in Project Server 2007 PWA it appeared that there was an issue with the queue service as the jobs were waiting to be processed. After a restart of the Project Server Queue service, the jobs processed though the queue and the migration then progressed and completed successfully.