none
Upgrading from Project Server 2010 to 2013 ConvertTo-SPProjectDatabase gives error RRS feed

  • Question

  • I am upgrading from Project Server 2010 to 2013 and following this TechNet article http://technet.microsoft.com/en-us/library/ee662104(v=office.15).aspx

    When I run following command I get error

    ConvertTo-SPProjectDatabase -WebApplication http://servername:90/ -dbserver dbservername -ArchiveDBName PWA_ProjectServer_Archive -DraftDBName PWA_ProjectServer_Draft -PublishedDBName PWA_ProjectServer_Published -ReportingDBName PWA_ProjectServer_Reporting -ProjectServiceDBName EPM_2013_ProjectServiceDB

    Error in the command window:

    ConvertTo-SPProjectDatabase : Action 15.0.14.0 of
    Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseSequence failed.
    At line:1 char:1
    + ConvertTo-SPProjectDatabase -WebApplication http://srvname:90/
    -dbserver " ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ~~~
        + CategoryInfo          : InvalidOperation: (Microsoft.Offic...baseImpleme
       ntor:ConvertToProjec...baseImplementor) [ConvertTo-SPProjectDatabase], SPU
      pgradeException
        + FullyQualifiedErrorId : Microsoft.Office.Project.Server.Cmdlet.PSCmdletC
       onvertToProjectServiceDatabase

    Error in the ULS Log:

    System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_MSP_WssListItemAssociation'. Cannot insert duplicate key in object 'dbo.MSP_WssListItemAssociation'. The duplicate key value is (17333a00-0658-44d6-822a-f8647806845c, 694a25e7-1846-4525-8064-42376a8a505d, e38ff639-c6de-45cb-9bfe-4b95f35ad46f, 2).  The DELETE statement conflicted with the REFERENCE constraint "FK_MSP_WssListItemAssociation_RelationshipTypeID". The conflict occurred in database "PWA_ProjectServer_Reporting", table "dbo.MSP_WssListItemAssociation", column 'RelationshipTypeID'.  The statement has been terminated.  The statement has been terminated.   

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)   

    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)   

    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)   

    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)   

    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()   

    at Microsoft.Office.Project.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)  ClientConnectionId:bc463038-2222-4c8f-8ea2-6e4832268a9e

    Please help!!!

    Wednesday, October 30, 2013 7:15 PM

Answers

  • Solved this issue by deleting the conflicting row from dbo.MSP_WssListItemAssociation table with primary key values shown in the error.
    • Marked as answer by UsmanGhous Tuesday, November 5, 2013 1:42 PM
    Tuesday, November 5, 2013 1:42 PM

All replies

  • Hi,

    Review versions of SQL. I got the same issue and with SQL 2012 SP1 I got to solve it.

    Tuesday, November 5, 2013 7:33 AM
  • Solved this issue by deleting the conflicting row from dbo.MSP_WssListItemAssociation table with primary key values shown in the error.
    • Marked as answer by UsmanGhous Tuesday, November 5, 2013 1:42 PM
    Tuesday, November 5, 2013 1:42 PM