none
Getting error while Upgrading Project Server 2013 to 2016 RRS feed

  • Question

  • Hi 

    I am Migrating my Project 2013 environment to 2016 but every steps did work well but at the end of Project database Migration, i am getting Following error:

    Migrate-SPProjectDatabase : Error encountered while migrating project data in
    Content database. Violation of PRIMARY KEY constraint 'PK_MSP_EpmProject'.
    Cannot insert duplicate key in object 'pjrep.MSP_EpmProject'. The duplicate
    key value is (c00891b5-81d4-4d78-a040-44bc9f825e85,
    00fc2525-20e7-e511-80d5-00505681479d).
    The statement has been terminated.

    For your kind information, I have followed following reference to perform this Migration. Also, i have checked (while taking backup of 2013 database) all the entity was checked in and no pending Queue jobs

    https://technet.microsoft.com/en-us/library/ee662104(v=office.16).aspx

    https://blogs.msdn.microsoft.com/sayedali/2016/10/17/project-server-2016-upgrade-overview-steps/

    Error screen shot as below:


    Regards, Pankaj Waghmare - MCTS | Consultant

    Sunday, October 1, 2017 8:06 PM