Problems Caused by Migration from 2003

I have been doing another migration of projects and workspaces from a Project Server 2003 based environment to a new 2007 environment and have encountered another ‘interesting’ problem.
Whilst running the the content upgrade process (stsadm -o addcontentdb etc…) the underlying server crashed and the process was interrupted. Following the instructions published by Microsoft I simply ran stsadm.exe -o upgrade. This ran and finished but didn’t do the addcontentdb as I expected it would so I re-ran the first step mentioned above. This ran to completion but somewhere along the line something has got screwed up big time and now we are unable to create or save projects in our Project Server 2007 environment from Project Professional and can’t edit project properties from within PWA. When I tried to run the project migration tool (P12MigrationTool.exe) to load a project I received the following error when it was trying to save the project:
 
Saving to Project Server 2007
ERROR: Serializer error: 0x2 psi error: 0x1
Migration failed for project 09079007_System_Environment_Upgrade.Published
migration of project 09079007_System_Environment_Upgrade.Published failed
 
After digging around a bit I discovered the following error related to the Project Server Queue and the PSI in the IIS logs:
 
 
 PSI:   [QUEUE] ProjectQ Receiver restarting 08a35856-9250-4da6-9d74-b8528681c191
 PSI:   SqlException occurred in DAL: 
<Error>
<State>1</State>
<LineNumber>14</LineNumber>
<Number>208</Number>
<Procedure>MSP_ProjQ_Lift_Off</Procedure>
  <Message>  System.Data.SqlClient.SqlError: Invalid object name ‘MSP_QUEUE_RENDEZVOUS’.  </Message>
  <CallStack>     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
MSP_QUEUE_RENDEZVOUS is a view within the Drafts project server database and when I went looking for it instead of the 100+ views that should be there we only had 3. After checking the other project server databases I found a similar story. Only a few of the large numbers of views were actually in the databases. I suspect something in the migration process has either removed them or possibly was recreating them when the system crashed leaving the process unfinished. I’ve done a number of migrations like this and have never encountered this problem when the migration tools have completed without interruption.
 
Thankfully I have access to some other instances of project server so I was able to generate some SQL scripts to recreate the views within this environment. After the views were created the project migration worked successfully and the other problems we were having from Project Professional and PWA also went away.
Advertisements

Leave a comment

Filed under Project Server 2007

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s