none
Migrate-SPProjectDatabase : Error encountered while migrating project data in Content database. RRS feed

  • Question

  • Hi,

    We are migrating Project Server 2013 to Project server 2016.

    We successfully migrate SharePoint content database that contains project server data.

    But while migrating PWA (Project Server Database) database we are facing issue "Migrate-SPProjectDatabase : Error encountered while migrating project data in Content database. "

    Detailed Error log

    --------------------------------------------------------------------------------------------------------------------------------------------------------

    Timestamp              Process                                  TID    Area                          Category                      EventID Level      Message Correlation
    02/20/2018 15:13:45.67 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t INFO ProjectDatabase Name=PWA_C3IT_2013 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.67 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t ERROR Upgrade [ProjectDatabase Name=PWA_2013] failed. 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.70 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t INFO ProjectDatabase Name=PWA_2013 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.70 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t ERROR Inner Exception: An item with the same key has already been added. 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.73 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t INFO ProjectDatabase Name=PWA_2013 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.73 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t ERROR    at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)     at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)     at Microsoft.Office.Project.Server.Administration.TargetDatabaseObjectProvider.Initialize()     at Microsoft.Office.Project.Server.Upgrade.SqlMetadataManager.InitializeObjectsFromTargetDatabase()     at Microsoft.Office.Project.Server.Upgrade.SqlMetadataManager.<>c__DisplayClass2.<Initialize>b__1()     at System.Threading.Tasks.Task.Execute() 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.77 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t INFO ProjectDatabase Name=PWA_2013 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.77 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t ERROR Exception: One or more errors occurred. 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.79 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t INFO ProjectDatabase Name=PWA_2013 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.79 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPUpgradeSession an59t ERROR    at System.Threading.Tasks.Task.FastWaitAll(Task[] tasks)     at System.Threading.Tasks.Parallel.Invoke(ParallelOptions parallelOptions, Action[] actions)     at Microsoft.Office.Project.Server.Upgrade.SqlMetadataManager.Initialize()     at Microsoft.Office.Project.Server.Database.Upgrade.PSDatabasePostUpgrade.RefreshSqlObjects(IProjectServerSqlSession sqlSession)     at Microsoft.Office.Project.Server.Database.Upgrade.PSDatabasePostUpgrade.PostUpgrade(SPDatabase database)     at Microsoft.Office.Project.Server.Upgrade.PSDatabaseSequence.PostUpgrade()     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.RunPostUpgraders(Object o, List`1 lstClass)     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse) 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.87 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPManager aj26w INFO No context object 594c4c9e-727b-703d-a7bf-c617f8aec6f1
    02/20/2018 15:13:45.87 powershell (0x6AF0) 0x6B98 SharePoint Foundation Upgrade SPManager aj26w ERROR Upgrade session failed due to unexpected exception: System.AggregateException: One or more errors occurred. ---> System.ArgumentException: An item with the same key has already been added.     at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)     at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)     at Microsoft.Office.Project.Server.Administration.TargetDatabaseObjectProvider.Initialize()     at Microsoft.Office.Project.Server.Upgrade.SqlMetadataManager.InitializeObjectsFromTargetDatabase()     at Microsoft.Office.Project.Server.Upgrade.SqlMetadataManager.<>c__DisplayClass2.<Initialize>b__1()     at System.Threading.Tasks.Task.Execute()     --- End of inner exception stack trace ---     at System.Threading.Tasks.Task.FastWaitAll(Task[] tasks)     at System.Threading.Tasks.Parallel.Invoke(ParallelOptions parallelOptions, Action[] actions)     at Microsoft.Office.Project.Server.Upgrade.SqlMetadataManager.Initialize()     at Microsoft.Office.Project.Server.Database.Upgrade.PSDatabasePostUpgrade.RefreshSqlObjects(IProjectServerSqlSession sqlSession)     at Microsoft.Office.Project.Server.Database.Upgrade.PSDatabasePostUpgrade.PostUpgrade(SPDatabase database)     at Microsoft.Office.Project.Server.Upgrade.PSDatabaseSequence.PostUpgrade()     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.RunPostUpgraders(Object o, List`1 lstClass)     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)     at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.Upgrade(Boolean recursively)     at Microsoft.SharePoint.Administration.SPDatabase.Upgrade(Boolean recursively)     at Microsoft.SharePoint.Upgrade.SPManager.RunUpgradeSession(Object lockObject, IUpgradable iup, SPUpgradeOperationFlags upgradeOperationFlags)  ---> (Inner Exception #0) System.ArgumentException: An item with the same key has already been added.     at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)     at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)     at Microsoft.Office.Project.Server.Administration.TargetDatabaseObjectProvider.Initialize()     at Microsoft.Office.Project.Server.Upgrade.SqlMetadataManager.InitializeObjectsFromTargetDatabase()     at Microsoft.Office.Project.Server.Upgrade.SqlMetadataManager.<>c__DisplayClass2.<Initialize>b__1()     at System.Threading.Tasks.Task.Execute()<---  . 594c4c9e-727b-703d-a7bf-c617f8aec6f1

    ---------------------------------------------------------------------------------------------------------------------------------------------------------

    Please help on this

    Thank you in advance

    Regards,

    Faiyaj

    Tuesday, February 20, 2018 10:07 AM