locked
Failed Sharepoint Project Web Access Provision RRS feed

  • Question

  • I am trying to create a project web access site and it keeps failing with the log messages:

    Provisioning 'PMO': Server versions: Primary 10.50.1600.1, Reporting 10.50.1600.1.     
    Provisioning 'PMO': Databases specified for site 'ProjectServer' are as follows: Published: Name = 'ClaudioProjectServer_Published', State = ProjectSchema Draft: Name = 'ClaudioProjectServer_Draft', State = ProjectSchema Archive: Name = 'ClaudioProjectServer_Archive', State = ProjectSchema Reporting: Name = 'ClaudioProjectServer_Reporting', State = ProjectSchema     
    Provisioning 'PMO': Failed to provision databases. An exception occurred: Specified cast is not valid..     
    Provisioning 'PMO': Database provisioning failed.

    Sunday, August 29, 2010 5:45 PM

Answers

  • I resolved the issue. My server did not have Office Server Service Pack 2.
    • Marked as answer by Claudioji Tuesday, August 31, 2010 9:03 AM
    Tuesday, August 31, 2010 9:03 AM

All replies

  • Now I get this error:

    Provisioning 'PMO': Failed to provision databases. An exception occurred: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_MSP_NOTIFICATION_XSLS_NOTIFICATION_EMAIL_MODE_ID". The conflict occurred in database "ClaudioProjectServer_Published", table "dbo.MSP_NOTIFICATION_MODE", column 'NOTIFICATION_EMAIL_MODE_ID'.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated.
    The statement has been terminated..

    Sunday, August 29, 2010 9:53 PM
  • What are the version of the PWA database you are trying to provision?
    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Monday, August 30, 2010 6:11 PM
  • I am trying to install project server 2007 on a sharepoint 2007 server farm.
    Tuesday, August 31, 2010 6:56 AM
  • I resolved the issue. My server did not have Office Server Service Pack 2.
    • Marked as answer by Claudioji Tuesday, August 31, 2010 9:03 AM
    Tuesday, August 31, 2010 9:03 AM