locked
June 2013 CU...object error on ProjectServer_Reporting_DB RRS feed

  • Question

  • While trying to install the revised June 2013 CU for Project Server 2010, the field engineer received the below error message. Has anyone encountered this same issue? If so, and you were able to resolve it on your own without PSS's help, can you please share how you resolved it?  Thanks in advance.

    [OWSTIMER] [SPUpgradeSession] [INFO] [9/14/2013 2:47:15 PM]: ProjectDatabase Name=abc_ProjectServer_Reporting_DB
    [OWSTIMER] [SPUpgradeSession] [ERROR] [9/14/2013 2:47:15 PM]: Upgrade [ProjectDatabase Name=abc_ProjectServer_Reporting_DB] failed.
    [OWSTIMER] [SPUpgradeSession] [INFO] [9/14/2013 2:47:15 PM]: ProjectDatabase Name=abc_ProjectServer_Reporting_DB
    [OWSTIMER] [SPUpgradeSession] [ERROR] [9/14/2013 2:47:15 PM]: Exception: Invalid object name 'abc_ProjectServer_Published_DB.dbo.MSP_TASK_BASELINES_20130628'.
    Invalid object name 'abc_ProjectServer_Published_DB.dbo.MSP_TASK_BASELINES_20130628_deletedRecords'.
    [OWSTIMER] [SPUpgradeSession] [INFO] [9/14/2013 2:47:15 PM]: ProjectDatabase Name=abc_ProjectServer_Reporting_DB

    Saturday, September 14, 2013 10:47 PM

Answers

  • Hi US_Coder,

    Message says that upgrading the reporting database actually failed. Looks like reporting database has some kind of reference to 'abc_projectserver_published_DB.dbo.MSP_TASK_BASELINES_20130628'. and now it is not able to find that table.

    Hope this helps you troubleshoot further.


    Vikram Daruru - MSFT

    • Marked as answer by Vikram Daruru Tuesday, January 13, 2015 6:51 AM
    Tuesday, January 13, 2015 6:51 AM