locked
Provisioning failed because the databases specified did not match.. RRS feed

  • Question

  •  

    I`m now stuck at getting this error while tring to provision pwa site:

    Provisioning failed because the databases specified did not match..


    12/23/2010 17:14:30.95     OWSTIMER.EXE (0x07D0)                       0x0680    Project Server                    Provisioning                      7070    Critical    Provisioning 'PWA': One or more of the databases already contains schema. When editing or creating a Project Server instance, you may specify: * Four databases that do not exist * Four existing, blank databases * Four existing Project Server databases of the same version from the same installation. Combinations of blank, new, and existing databases are not allowed.    061ec463-cd2d-4d27-ae16-d4b6b2a8af3f
    12/23/2010 17:14:30.95     OWSTIMER.EXE (0x07D0)                       0x0680    Project Server                    Provisioning                      6993    Critical    Provisioning 'PWA': Failed to provision databases. An exception occurred: Provisioning failed because the databases specified did not match..    061ec463-cd2d-4d27-ae16-d4b6b2a8af3f
    12/23/2010 17:14:30.95     OWSTIMER.EXE (0x07D0)                       0x0680    Project Server                    Provisioning                      6958    Critical    Provisioning 'PWA': Database provisioning failed.    061ec463-cd2d-4d27-ae16-d4b6b2a8af3f
    12/23/2010 17:14:30.95     OWSTIMER.EXE (0x07D0)                       0x0680    Project Server                    Provisioning                      6971    Critical    Failed to provision site PWA with error: Microsoft.Office.Project.Server.Administration.ProvisionException: Failed to provision databases. ---> Microsoft.Office.Project.Server.Administration.ProvisionException: Provisioning failed because the databases specified did not match.     ? Microsoft.Office.Project.Server.Administration.PsiServiceApplication.EnsureDatabases(ProjectProvisionSettings provset, SPSite pwaSite, String adminName, String adminEmail, ProjectDatabaseStateType& originalDatabaseState, Guid& adminGuid)     --- ????? ??????????? ??????????? ????? ?????????? ---     ? Microsoft.Office.Project.Server.Administration.PsiServiceApplication.EnsureDatabases(ProjectProvisionSettings provset, SPSite pwaSite, String adminName, String adminEmail, ProjectDatabaseStateType& originalDatabas...    061ec463-cd2d-4d27-ae16-d4b6b2a8af3f
    12/23/2010 17:14:30.95*    OWSTIMER.EXE (0x07D0)                       0x0680    Project Server                    Provisioning                      6971    Critical    ...eState, Guid& adminGuid)     ? Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)    061ec463-cd2d-4d27-ae16-d4b6b2a8af3f

    What the problem can be?

    Thursday, December 23, 2010 4:02 PM

Answers

All replies

  • Either no permission with the databases or combination of new and old databases.

    Open SQL management Studio --> Check what are all the Project databases available.

    Later create PWA with appropriate database names..

     


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Thursday, December 23, 2010 5:18 PM
  • I turned every relevant service under single farm admin account (just testing environment) - so should not be any problems with access. 4 Project bases are 100% match source ones.

    I made another VM PS2007 and there i`m getting this error while provisioning:


    12/24/2010 16:56:14.74     OWSTIMER.EXE (0x0A30)                       0x0CD4    Project Server                    Project Server Provisioning       7021    Critical    ProjectPSISharedApplicationTimerJob failed.     
    12/24/2010 16:56:14.74     OWSTIMER.EXE (0x0A30)                       0x0CD4    Office Server                     Office Server General             900n    Critical    A runtime exception was detected. Details follow.  Message: Cannot insert duplicate key row in object 'dbo.Objects' with unique index 'IX_Objects_ClassId_ParentId_Name'.  The statement has been terminated.  Techinal Details: System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Objects' with unique index 'IX_Objects_ClassId_ParentId_Name'.  The statement has been terminated.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at Sy...     
    12/24/2010 16:56:14.74*    OWSTIMER.EXE (0x0A30)                       0x0CD4    Office Server                     Office Server General             900n    Critical    ...stem.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior r     

    Friday, December 24, 2010 2:04 PM
  • Option#1 - Change the regional settings
    1. Change the regional settings on the server to MATCH the language of the MUI.
    2. Provision site
    3. Change the regional settings back to its original.

    http://blogs.msdn.com/b/brismith/archive/2009/05/28/project-server-2007-pwa-provisioning-issue-after-february-cu-cannot-insert-duplicate-key-row.aspx
    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management
    Friday, December 24, 2010 11:16 PM
  • I am facing the same issue initially posted by EVERNITE... when i try to Provision a NEW PWA (Not upgrading it neither attaching old 5 dbs), I just ran the Project Server 2010 SP1 and suddenly all got messed up, i deleted the old PWA and now creating a new one but still having the same issue:

    EVENT ID: 6971, 6950, 6948 (In event viewer after Provisioning failed)


    Maaz Ibrahim
    Thursday, July 14, 2011 7:48 AM
  • Are you specifically entering different database names?  What happens if
    your provision a new PWA site with new DB names?
     
     

    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Thursday, July 14, 2011 12:58 PM