none
Upgrade Project server upgrade 2013 to 2016 RRS feed

  • Question

  • Hi,

    I have setup SP 2016 Server.

    Site content db from SP 2013 to SP 2016 tested and mounted successfully.

    when run

    Migrate-SPProjectDatabase -DatabaseName "WSS_Content_PWA_Portal" -SiteCollection "http://it.myportal.com/pwa"

    getting following error

    Migrate-SPProjectDatabase : Error encountered while migrating project data in Content database. Action 16.0.20.0 of
    Microsoft.Office.Project.Server.Upgrade.PSDatabaseSequence failed.
    At line:1 char:1
    + Migrate-SPProjectDatabase -DatabaseName "WSS_Content_PWA_Portal" -Sit ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : OperationStopped: (Microsoft.Offic...ProjectDatabase:PSCmdletMigrateSPProjectDatabase) [
       Migrate-SPProjectDatabase], SPException
        + FullyQualifiedErrorId : Microsoft.Office.Project.Server.Cmdlet.PSCmdletMigrateSPProjectDatabase


    Microsoft.SharePoint.SPException: Error encountered while migrating project data in Content database. Action 16.0.20.0 of Microsoft.Office.Project.Server.Upgrade.PSDatabaseSequence failed. ---> Microsoft.SharePoint.Upgrade.SPUpgradeException: Action 16.0.20.0 of Microsoft.Office.Project.Server.Upgrade.PSDatabaseSequence failed. ---> System.Data.SqlClient.SqlException: Invalid object name 'pub.MSP_WEB_CONVERSIONS'.    
     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.SqlDataReader.TryConsumeMetaData()    
     at System.Data.SqlClient.SqlDataReader.get_MetaData()    
     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)    
     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)    
     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)    
     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)    
     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)    
     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)    
     at Microsoft.Office.Project.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)    
     at Microsoft.Office.Project.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior)    
     at Microsoft.Office.Project.Server.DataAccessLayer.SqlSessionManager.TransactionalSqlSessionAdapter.SqlSessionInterfaceImpl.ExecuteReader(SqlCommand command)    
     at Microsoft.Office.Project.Server.Administration.Telemetry.ExecuteScriptWithTelemetry(ISqlSession sqlSession, String commandText, SPLog log, Boolean areWarningsErrors)    
     at Microsoft.Office.Project.Server.Upgrade.ProjectDatabaseUpgrader.ExecuteUpgraderSqlScript(String sql)    
     at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()     -
     -- End of inner exception stack trace ---    
     at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade()    
     at Microsoft.SharePoint.Upgrade.SPUpgradeSession.RunUpgraders(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)    
     at Microsoft.Office.Project.Server.Cmdlet.PSCmdletMigrateSPProjectDatabase.InternalProcessRecord()     -
     -- End of inner exception stack trace ---

    pls guide what is an issue and how to fix it.

    Thx

     


    iffi

    Wednesday, September 12, 2018 9:58 AM

All replies

  • Experienced the same Issue.

    Per observation, noticed that the SharePoint session with SQL server was failed due to the network outage.

    Tried the same Cmdlet again on a new PowerShell window, everything went well.

    Migrate-SPProjectDatabase -DatabaseName ProjectWebApp -SiteCollection "http://PWASiteURL"

    WSS_Content_PWA_Portal - Is it your 2013 Project Database?

    With Regards,

    Sriram


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management


    Friday, September 14, 2018 10:09 PM
    Moderator
  • Here are few things that may help

    1) Enable-spFeature

    2) specify SQL server name

    Enable-spfeature -identity PWABIODataReports -Url $SitePwaURL  -Force

    # Migrate ProjectWebApp 2013 to 2016
    Migrate-SPProjectDatabase -SiteCollection $SitePwaURL -DatabaseServer $SqlServerName -DatabaseName $ProjectWebApp2013 -Overwrite -Confirm:$false -Verbose 


    Michael Wharton, Project MVP, MBA, PMP and a Great Guy <br/> Website http://www.WhartonComputer.com <br/> Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Wednesday, September 19, 2018 10:19 AM
    Moderator
  • Hello, have you solved this issue? I Experienced the same Issue
    Monday, August 17, 2020 3:13 PM