none
Project Server Migration from 2007 to 2010 RRS feed

  • Question

  • Hi Team,

    I am migrating project server 2007 and wss 3.0 to sharePoint 2010 and project server 2010. I am using full database attach upgrade method. The provisioning process end up with failure and uls logs showing the below mentioned errors.

    Questions:

    1- the lookup table sample primary objectives and area impacted is not in project server 2007 and how i can delete it when i have no 2010 environment.

    2- if it takes reference from project server 2007 database, then can you please give me directions how to delete them from database

    I made several attempts but every time i ended up with the error screenshot. I need your ideas.

    Kashif


    Kashif Saeed

    Tuesday, March 17, 2015 7:45 AM

Answers

  • Hi Kashif,

    I quickly scanned your log (thanks) and I can see that there is an error: Critical Provisioning 'PWA': Error provisioning site or databases

    and if I combine this one with the error in your original post (The Site with Id ... could not be found) looks like there is a problem the content db migration.

    Have you tried the migration using only the 4 project server databases?

    Is the PWA content db attached to the correct web application? Have you tried locking the other content databases on the same web application before provisioning the PWA (this will make sure the PWA will fall in the correct content DB)?

    Another option for you if you still get the error is to restore only the 4 project server databases and do an stsadm backup/restore for the PWA sites

    Paul

    • Marked as answer by Kaashif.Saeed Thursday, March 19, 2015 12:26 PM
    Wednesday, March 18, 2015 8:35 PM

All replies

  • Hi Kashif,

    These fields are the sample fields that are usually created in a new 2010 environment. They will not be added to your environment

    Hope this helps

    I can see you have an exception in the log and I would suggest checking the content db migration and if it has been attached to the correct web application etc.

    Paul

    Tuesday, March 17, 2015 10:24 AM
  • Hi Paul,

    Could you please a bit more specific to how can i check content db migration. I have created a new web application in the new 2010 environment. when i mount the content db with the new web application the result is successful and i can see the site collections as well.when i create a new PWA instance and map it with the previously restored dbs of project server then it start for some time and end up with the error as shown above. I have check the ULS logs and nothing found in it. I will send you the update logs. 

    Thank You very much and please help me in sorting this out.

    Kashif

    Logs

    =============================================================================

    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: ======================================================================================
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: Upgrade session starts
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: Command line: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\OWSTIMER.EXE
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: User: CORP\epm_migfarmsvc
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: Current Machine: LVEMIG01
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: Mode: InPlace
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: Current SharePoint Build: 14.0.7015.1000
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: Upgrade Object: ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:20:30 PM]: ======================================================================================
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:20:30 PM]: Preparing to upgrade PersistedUpgradableObject: ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff.  This object's current status is Online. Setting it to Upgrading
    [OWSTIMER] [SPHierarchyManager] [DEBUG] [3/16/2015 3:20:30 PM]: [SPTree Value=ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff] added to dependency cache by lookup
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff IsGrown=False IsRoot=True IsLeaf=True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: NeedsUpgrade [ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff] returned: True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: Upgrading [ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff].
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: [ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff] NeedsUpgrade = FALSE.
    [OWSTIMER] [ProjectSiteSequence] [DEBUG] [3/16/2015 3:20:30 PM]: ProjectSiteSequence.AddNextLevelObjects() ...
    [OWSTIMER] [ProjectSiteSequence] [DEBUG] [3/16/2015 3:20:30 PM]: InitProjectSiteChildren ...
    [OWSTIMER] [ProjectSiteSequence] [DEBUG] [3/16/2015 3:20:30 PM]: Make ProjectSite available to its children ...
    [OWSTIMER] [ProjectSiteSequence] [DEBUG] [3/16/2015 3:20:30 PM]: Init ProjectSite's children ready state ...
    [OWSTIMER] [ProjectSiteSequence] [DEBUG] [3/16/2015 3:20:30 PM]: AddProjectSiteChildrenAsNextLevelObjects ...
    [OWSTIMER] [ProjectSiteSequence] [DEBUG] [3/16/2015 3:20:30 PM]: ProjectSiteSequence.AddNextLevelObjects() done.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: Elapsed time upgrading [ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff]: 00:00:00.
    [OWSTIMER] [SPHierarchyManager] [DEBUG] [3/16/2015 3:20:30 PM]: ProjectDatabase Name=EPM_ProjectServer_Published
    [OWSTIMER] [SPHierarchyManager] [DEBUG] [3/16/2015 3:20:30 PM]: ProjectDatabase Name=EPM_ProjectServer_Draft
    [OWSTIMER] [SPHierarchyManager] [DEBUG] [3/16/2015 3:20:30 PM]: ProjectDatabase Name=EPM_ProjectServer_Archive
    [OWSTIMER] [SPHierarchyManager] [DEBUG] [3/16/2015 3:20:30 PM]: ProjectDatabase Name=EPM_ProjectServer_Reporting
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: UPGRADE PERCENTAGE: 5.00000000% done, Total Elapsed Time 00:00:00.0936001.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:20:30 PM]: Preparing to upgrade PersistedUpgradableObject: ProjectDatabase Name=EPM_ProjectServer_Published.  This object's current status is Online. Setting it to Upgrading
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:20:30 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Published].
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:20:30 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.VersionsDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Published].
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:20:30 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.WorkingDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Published].
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:30 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Published, Status = Upgrading.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:30 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Published, Status = Upgrading.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:30 PM]: UpgradableBuildBypassInternal = 0
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:30 PM]: UpgradableBuildBypass = 0
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: CanUpgrade [ProjectDatabase Name=EPM_ProjectServer_Published] returned: True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: ProjectDatabase Name=EPM_ProjectServer_Published IsGrown=False IsRoot=False IsLeaf=True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:20:30 PM]: Upgrading [ProjectDatabase Name=EPM_ProjectServer_Published].
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:30 PM]: PreUpgrade() ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:30 PM]: DropSqlObjects() ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:30 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delsps12.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:34 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delsps12.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:34 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delvw12.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:34 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delvw12.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:34 PM]: DropSqlObjects() done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:34 PM]: PreUpgrade() done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:34 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Published, Status = Upgrading.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:34 PM]: Microsoft.Office.Project.Server.Upgrade, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Executing SQL DDL Script.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Done setting the compat level to 90.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Published, Status = Upgrading.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Published, Status = Upgrading.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Setting database AUTO_CLOSE to OFF.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: PostUpgrade() ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: CreateSqlObjects() ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Creating invariant objects and data ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\SqlBroker.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\SqlBroker.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:35 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addsps12.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:40 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addsps12.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:40 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addpubvw12.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:40 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addpubvw12.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:40 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addpubsps12.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:52 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addpubsps12.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:52 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\autogen.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:53 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\autogen.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:53 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\CubeAdmin.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:53 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\CubeAdmin.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:53 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addqueue1timesheetsps12.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:54 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addqueue1timesheetsps12.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:54 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addprojdelsps12.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:54 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addprojdelsps12.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:54 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addpublishsps12.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:57 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addpublishsps12.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:57 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addp12upgpubsps.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:59 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addp12upgpubsps.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:59 PM]: Creating SQLCLR objects if applicable ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:59 PM]: CreateMuiData() ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:59 PM]: Creating MUI objects and data for LCID=1033 ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:20:59 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\insdeflp.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:04 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\insdeflp.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:04 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\notification.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:04 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\notification.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:04 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\insreserved.sql' ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:06 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\insreserved.sql' done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:06 PM]: CreateMuiData() done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:06 PM]: Upgrader version: 14.0.7010.1000
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:06 PM]: Upgrader version fixed up: 14.0.70101000.0
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:06 PM]: Existing server version: 14.0.70101000.0
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:21:06 PM]: No need to update server version.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:22:04 PM]: CreateSqlObjects() done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:22:04 PM]: Mark 'Published' database as upgraded.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:22:04 PM]: Checking ProjectSiteChildrenAreReady() ...
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:22:04 PM]: Not all ProjectSite children are ready.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:22:04 PM]: PostUpgrade() done.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:22:04 PM]: [ProjectDatabase Name=EPM_ProjectServer_Published] BuildVersion = 14.0.7010.1000.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:22:04 PM]: Calling set SchemaVersion on Database EPM_ProjectServer_Published, Status = Upgrading.
    [OWSTIMER] [PublishedDatabaseSequence] [DEBUG] [3/16/2015 3:22:04 PM]: [ProjectDatabase Name=EPM_ProjectServer_Published] SchemaVersion = 14.2.151.0.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:04 PM]: [ProjectDatabase Name=EPM_ProjectServer_Published] NeedsUpgrade = FALSE.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:04 PM]: Elapsed time upgrading [ProjectDatabase Name=EPM_ProjectServer_Published]: 00:01:34.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:04 PM]: UPGRADE PERCENTAGE: 6.18750000% done, Total Elapsed Time 00:01:34.7378729.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:04 PM]: UPGRADE PERCENTAGE: 28.75000000% done, Total Elapsed Time 00:01:34.7846730.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:05 PM]: Resetting the status of PersistedUpgradableObject: ProjectDatabase Name=EPM_ProjectServer_Published to Online.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:05 PM]: Finished upgrading ProjectDatabase Name=EPM_ProjectServer_Published.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:05 PM]: Preparing to upgrade PersistedUpgradableObject: ProjectDatabase Name=EPM_ProjectServer_Draft.  This object's current status is Online. Setting it to Upgrading
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:05 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.PublishedDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Draft].
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:05 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Draft].
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:05 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.VersionsDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Draft].
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:05 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Draft, Status = Upgrading.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:05 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Draft, Status = Upgrading.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:05 PM]: UpgradableBuildBypassInternal = 0
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:05 PM]: UpgradableBuildBypass = 0
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:05 PM]: CanUpgrade [ProjectDatabase Name=EPM_ProjectServer_Draft] returned: True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:05 PM]: ProjectDatabase Name=EPM_ProjectServer_Draft IsGrown=False IsRoot=False IsLeaf=True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:05 PM]: Upgrading [ProjectDatabase Name=EPM_ProjectServer_Draft].
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:05 PM]: PreUpgrade() ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:05 PM]: DropSqlObjects() ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:05 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delsps12.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:06 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delsps12.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:06 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delvw12.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delvw12.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: DropSqlObjects() done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: PreUpgrade() done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Draft, Status = Upgrading.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Microsoft.Office.Project.Server.Upgrade, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Executing SQL DDL Script.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Done setting the compat level to 90.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Draft, Status = Upgrading.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Draft, Status = Upgrading.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Setting database AUTO_CLOSE to OFF.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: PostUpgrade() ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: CreateSqlObjects() ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Creating invariant objects and data ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\SqlBroker.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\SqlBroker.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addworkvw12.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addworkvw12.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:07 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addsps12.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:14 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addsps12.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:14 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addworksps12.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:15 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addworksps12.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:15 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\autogen.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:16 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\autogen.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:16 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addqueue1projectsps12.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:16 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addqueue1projectsps12.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:16 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addprojdelsps12.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:16 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addprojdelsps12.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:16 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addworkingsps12.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:17 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addworkingsps12.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:17 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addp12upgworksps.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:18 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addp12upgworksps.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:18 PM]: Creating SQLCLR objects if applicable ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:18 PM]: CreateMuiData() ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:18 PM]: Creating MUI objects and data for LCID=1033 ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:18 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\insdeflp.sql' ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\insdeflp.sql' done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: CreateMuiData() done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: CreateSqlObjects() done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: Mark 'Draft' database as upgraded.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: Checking ProjectSiteChildrenAreReady() ...
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: Not all ProjectSite children are ready.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: PostUpgrade() done.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: [ProjectDatabase Name=EPM_ProjectServer_Draft] BuildVersion = 14.0.7010.1000.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: Calling set SchemaVersion on Database EPM_ProjectServer_Draft, Status = Upgrading.
    [OWSTIMER] [WorkingDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: [ProjectDatabase Name=EPM_ProjectServer_Draft] SchemaVersion = 14.1.601.0.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:23 PM]: [ProjectDatabase Name=EPM_ProjectServer_Draft] NeedsUpgrade = FALSE.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:23 PM]: Elapsed time upgrading [ProjectDatabase Name=EPM_ProjectServer_Draft]: 00:00:18.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:23 PM]: UPGRADE PERCENTAGE: 29.93750000% done, Total Elapsed Time 00:01:53.2863055.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:23 PM]: UPGRADE PERCENTAGE: 52.50000000% done, Total Elapsed Time 00:01:53.3331056.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:23 PM]: Resetting the status of PersistedUpgradableObject: ProjectDatabase Name=EPM_ProjectServer_Draft to Online.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:23 PM]: Finished upgrading ProjectDatabase Name=EPM_ProjectServer_Draft.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:23 PM]: Preparing to upgrade PersistedUpgradableObject: ProjectDatabase Name=EPM_ProjectServer_Archive.  This object's current status is Online. Setting it to Upgrading
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:23 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.PublishedDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Archive].
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:23 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.ReportingDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Archive].
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:23 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.WorkingDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Archive].
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Archive, Status = Upgrading.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Archive, Status = Upgrading.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: UpgradableBuildBypassInternal = 0
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: UpgradableBuildBypass = 0
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:23 PM]: CanUpgrade [ProjectDatabase Name=EPM_ProjectServer_Archive] returned: True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:23 PM]: ProjectDatabase Name=EPM_ProjectServer_Archive IsGrown=False IsRoot=False IsLeaf=True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:23 PM]: Upgrading [ProjectDatabase Name=EPM_ProjectServer_Archive].
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: PreUpgrade() ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: DropSqlObjects() ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:23 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delsps12.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delsps12.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delvw12.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delvw12.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: DropSqlObjects() done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: PreUpgrade() done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Archive, Status = Upgrading.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Microsoft.Office.Project.Server.Upgrade, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing SQL DDL Script.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Done setting the compat level to 90.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Archive, Status = Upgrading.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Archive, Status = Upgrading.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Setting database AUTO_CLOSE to OFF.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: PostUpgrade() ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: CreateSqlObjects() ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Creating invariant objects and data ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\SqlBroker.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\SqlBroker.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\autogen.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\autogen.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addversvw12.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addversvw12.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addprojdelsps12.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addprojdelsps12.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addverssps12.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addverssps12.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:24 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addversionsps12.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:27 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addversionsps12.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:27 PM]: Creating SQLCLR objects if applicable ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:27 PM]: CreateMuiData() ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:27 PM]: Creating MUI objects and data for LCID=1033 ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:27 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\insdeflp.sql' ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\1033\insdeflp.sql' done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: CreateMuiData() done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: CreateSqlObjects() done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: Mark 'Archive' database as upgraded.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: Checking ProjectSiteChildrenAreReady() ...
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: Not all ProjectSite children are ready.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: PostUpgrade() done.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: [ProjectDatabase Name=EPM_ProjectServer_Archive] BuildVersion = 14.0.7010.1000.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: Calling set SchemaVersion on Database EPM_ProjectServer_Archive, Status = Upgrading.
    [OWSTIMER] [VersionsDatabaseSequence] [DEBUG] [3/16/2015 3:22:31 PM]: [ProjectDatabase Name=EPM_ProjectServer_Archive] SchemaVersion = 14.1.101.0.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:31 PM]: [ProjectDatabase Name=EPM_ProjectServer_Archive] NeedsUpgrade = FALSE.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:31 PM]: Elapsed time upgrading [ProjectDatabase Name=EPM_ProjectServer_Archive]: 00:00:08.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:31 PM]: UPGRADE PERCENTAGE: 53.68750000% done, Total Elapsed Time 00:02:01.7056228.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:31 PM]: UPGRADE PERCENTAGE: 76.25000000% done, Total Elapsed Time 00:02:01.7524229.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:31 PM]: Resetting the status of PersistedUpgradableObject: ProjectDatabase Name=EPM_ProjectServer_Archive to Online.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:32 PM]: Finished upgrading ProjectDatabase Name=EPM_ProjectServer_Archive.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:32 PM]: Preparing to upgrade PersistedUpgradableObject: ProjectDatabase Name=EPM_ProjectServer_Reporting.  This object's current status is Online. Setting it to Upgrading
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:32 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.PublishedDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Reporting].
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:32 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.VersionsDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Reporting].
    [OWSTIMER] [SPDelegateManager] [DEBUG] [3/16/2015 3:22:32 PM]: Delegate [Microsoft.Office.Project.Server.Upgrade.WorkingDatabaseSequence] returned not applicable for [ProjectDatabase Name=EPM_ProjectServer_Reporting].
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:32 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Reporting, Status = Upgrading.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:32 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Reporting, Status = Upgrading.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:32 PM]: UpgradableBuildBypassInternal = 0
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:32 PM]: UpgradableBuildBypass = 0
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:32 PM]: CanUpgrade [ProjectDatabase Name=EPM_ProjectServer_Reporting] returned: True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:32 PM]: ProjectDatabase Name=EPM_ProjectServer_Reporting IsGrown=False IsRoot=False IsLeaf=True.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:32 PM]: Upgrading [ProjectDatabase Name=EPM_ProjectServer_Reporting].
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:32 PM]: PreUpgrade() ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:32 PM]: DropSqlObjects() ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:32 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delsps12.sql' ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delsps12.sql' done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delrepvw12.sql' ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\delrepvw12.sql' done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: DropSqlObjects() done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: PreUpgrade() done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Reporting, Status = Upgrading.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Microsoft.Office.Project.Server.Upgrade, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing SQL DDL Script.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Done setting the compat level to 90.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Reporting, Status = Upgrading.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Calling get SchemaVersion on Database EPM_ProjectServer_Reporting, Status = Upgrading.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Setting database AUTO_CLOSE to OFF.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: PostUpgrade() ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: CreateSqlObjects() ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Creating invariant objects and data ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\SqlBroker.sql' ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\SqlBroker.sql' done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addrepvw12.sql' ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addrepvw12.sql' done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:33 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addreportingsps12.sql' ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:41 PM]: Executing file 'C:\Program Files\Microsoft Office Servers\14.0\Sql\Project Server\CORE\addreportingsps12.sql' done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:41 PM]: Creating SQLCLR objects if applicable ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:41 PM]: CreateMuiData() ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:41 PM]: No MUI sql scripts defined for current database, exiting CreateMuiData.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:43 PM]: CreateSqlObjects() done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:43 PM]: Mark 'Reporting' database as upgraded.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:43 PM]: Checking ProjectSiteChildrenAreReady() ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:43 PM]: All ProjectSite children are ready. Invoking ProjectSiteSequence.ProjectSitePostUpgrade ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:43 PM]: ProjectSitePostUpgrade() ...
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:43 PM]: ProjectSite.LinkServers()
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:45 PM]: ProjectSitePostUpgrade() done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:45 PM]: PostUpgrade() done.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:45 PM]: [ProjectDatabase Name=EPM_ProjectServer_Reporting] BuildVersion = 14.0.7010.1000.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:45 PM]: Calling set SchemaVersion on Database EPM_ProjectServer_Reporting, Status = Upgrading.
    [OWSTIMER] [ReportingDatabaseSequence] [DEBUG] [3/16/2015 3:22:45 PM]: [ProjectDatabase Name=EPM_ProjectServer_Reporting] SchemaVersion = 14.1.100.0.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: [ProjectDatabase Name=EPM_ProjectServer_Reporting] NeedsUpgrade = FALSE.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: Elapsed time upgrading [ProjectDatabase Name=EPM_ProjectServer_Reporting]: 00:00:13.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: UPGRADE PERCENTAGE: 77.43750000% done, Total Elapsed Time 00:02:14.9344460.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: UPGRADE PERCENTAGE: 100.00000000% done, Total Elapsed Time 00:02:14.9812461.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:45 PM]: Resetting the status of PersistedUpgradableObject: ProjectDatabase Name=EPM_ProjectServer_Reporting to Online.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:45 PM]: Finished upgrading ProjectDatabase Name=EPM_ProjectServer_Reporting.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: Elapsed time upgrading all objects under [ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff]: 00:02:14.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:45 PM]: Resetting the status of PersistedUpgradableObject: ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff to Online.
    [OWSTIMER] [SPManager] [INFO] [3/16/2015 3:22:45 PM]: Finished upgrading ProjectSite Name=d98b6559-4f75-4074-92d9-d35b029a57ff.
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:22:45 PM]: ======================================================================================
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:22:45 PM]: Upgrade session finished successfully! 0 errors and 0 warnings encountered.
    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:22:45 PM]: ======================================================================================
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: Stop the session maintenance thread.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: Setting upgrade session object to offline in configuration database
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: UPGRADE PERCENTAGE: 100.00000000% done, Total Elapsed Time 00:02:15.1060463.
    [OWSTIMER] [SPUpgradeSession] [DEBUG] [3/16/2015 3:22:45 PM]: Releasing upgrade lock from configuration database


    Kashif Saeed

    Tuesday, March 17, 2015 11:41 AM
  • HI Kaashif.Saeed,

    I cannot see any errors in the log you have sent over

    [OWSTIMER] [SPUpgradeSession] [INFO] [3/16/2015 3:22:45 PM]: Upgrade session finished successfully! 0 errors and 0 warnings encountered.

    Is your migrated environment accessible now?

    Paul

    Tuesday, March 17, 2015 12:02 PM
  • Paul, this is my main concern, nothing in the logs and when i access the PWA site it opened up, i see my projects in project center but when i can not open projects in their workspaces. it showed error that workspace has not been initialized, i can now synchronize them. If i create workspace it is created as new one and no documents and issues and risks are show. My queue jobs can not get processed and it will remain in "waiting to be processed" state.

    Please let me know if any logs, screenshot is required...


    Kashif Saeed

    Tuesday, March 17, 2015 12:38 PM
  • Hi Kashif,

    If you go to the top of your, the position 1 in your queue - are any jobs being processed? If not, try to restart the Microsoft Project Server Queue service. Also, make sure the service account has the proper permissions at db level, pwa instance etc.

    With regards to the project workspaces - has the bulk update being run after the migration?

    Paul

    Tuesday, March 17, 2015 1:23 PM
  • Thanks Paul for the quick response, No queue jobs processed i wait for more then 2 days but no success. I have restarted the project server queue service many times no success and i have configured the service to use my local administrator account which is a domain account no success. The account is db_owner in database and local administrator on the machine

    with regards to project workspaces, i have run the bulk update after migration but it did not update the site urls for long time, project sites are shown but they are not linked with address as in my project server 2007 environment and may be that is why i was not able to open my project sites. my enterprise project type opened with error and nothing shown except "an error occured" when trying to open the project type.

    Kashif


    Kashif Saeed

    Tuesday, March 17, 2015 1:35 PM
  • Hi Kashif,

    I assume the bulk update is still waiting to be processed in the queue. It looks the issue is with the queue not processing any jobs. Here are a number of things you can check:

    1. Test everything works fine with an empty PWA 2010 instance and make sure the jobs are processed
    2. Re-provision the migrated PWA instance (edit in SharePoint Central Admin without changing anything)
    3. Add the service account to the project server admin group and see if that would help

    I will have a think if there is anything else you can try

    Paul


    Tuesday, March 17, 2015 1:53 PM
  • I will test your suggestion and get back to you soon.

    Thanking you once again

    Take Care


    Kashif Saeed

    Tuesday, March 17, 2015 2:12 PM
  • Hi Paul,

    I have tested your suggestions and below are the results.

    I have configured a new PWA instance with new databases and everything is good, queue processing is fine, i have configured a new project and queue processing finished in almost 5 mins.

    I have Re-Provision the PWA instance with previously migrated databases of project server 2007, again it failed and when i open it queue is filled with "User Synchronization (Add Operation) for Project Web App App Root Site and Project Sites" and status is "waiting to be processed", EPT did not load, almost all the previous problems.

    Please see the error log and refer to line 490 to 541 for error details, it is just observed by me, you better have idea and experiance.

    Could you please provide me your email address to send the log file.

    Regards


    Kashif Saeed

    Wednesday, March 18, 2015 10:52 AM
  • Hi Kashif,

    Have you also tried to add the service account as an admin on that project server instance and then restart the Queue job?

    Please send the log files to the email address on my blog: https://pmarinescu.wordpress.com/contact/

    Paul

    Wednesday, March 18, 2015 5:36 PM
  • Hi Kashif,

    I quickly scanned your log (thanks) and I can see that there is an error: Critical Provisioning 'PWA': Error provisioning site or databases

    and if I combine this one with the error in your original post (The Site with Id ... could not be found) looks like there is a problem the content db migration.

    Have you tried the migration using only the 4 project server databases?

    Is the PWA content db attached to the correct web application? Have you tried locking the other content databases on the same web application before provisioning the PWA (this will make sure the PWA will fall in the correct content DB)?

    Another option for you if you still get the error is to restore only the 4 project server databases and do an stsadm backup/restore for the PWA sites

    Paul

    • Marked as answer by Kaashif.Saeed Thursday, March 19, 2015 12:26 PM
    Wednesday, March 18, 2015 8:35 PM
  • Hi Paul,

    Thank you very much for advising the new requirement, I will test them and get back to you if i need your assistance

    regards


    Kashif Saeed

    Thursday, March 19, 2015 12:26 PM