none
Enable-SPFeature : The Project content database extension has not been provisioned for this content database. RRS feed

  • Question

  • Hello, 

    after created my test farm on SP2016 and Projectserver 2016 I have a problem

    PowerShell reply:

    Enable-SPFeature : The Project content database extension has not been
    provisioned for this content database.
    At line:1 char:1
    + Enable-SPFeature pwasite -URL http://server.domain.us/PWA
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : InvalidData: (Microsoft.Share...etEnableFeature:
       SPCmdletEnableFeature) [Enable-SPFeature], SPException
        + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletEnableFe
       ature

    I deploy PWA  to instructions (http://myprojectexpert.com/Lists/Posts/Post.aspx?ID=78)

    farm level - custom

    and  I do not find  in directory c:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\TEMPLATE\SQL\

    no sql script   with project DB query!! 

    • Edited by hsdr Monday, December 21, 2015 8:24 PM
    Monday, December 21, 2015 8:13 PM

All replies

  • Make sure that the project service is created and started before enabling.

    Also, I haven't test the script on SharePoint 2016 Technical Preview 2, so that may also be an issue. I hope to  try this in the next week or two.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Monday, December 28, 2015 11:34 AM
    Moderator
  • Below commands should fix your problem.

    $svc=[Microsoft.SharePoint.Administration.SPWebService]::ContentService [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Project.Server.Database.Extension")

    $svc.RegisteredDatabaseExtensionTypes.EnsureAdded([Microsoft.office.Project.Server.Database.Extension])

    $svc.Update($true)

    After you run this command all newly created ContentDbs will be provisioned with project server content db extension. For existing content db run

    Upgrade-SpContentDatabase

    Hope this helps! 

     
    Thursday, January 7, 2016 6:35 PM
  • I get the same error, and the supposed fix above does not work.

    Paul Fox

    Thursday, February 4, 2016 3:02 PM
  • Well, it does. The scripts need to run line by line. And so just to let you know this problem has been fixed with latest builds. 
    Wednesday, March 2, 2016 10:36 PM
  • I got the same error, tried the script above and it returned an error 

    Unable to find type [Microsoft.office.Project.Server.Database.Extension]. Make
    sure that the assembly that contains this type is loaded.
    At line:1 char:1
    + $svc.RegisteredDatabaseExtensionTypes.EnsureAdded([Microsoft.office.Project.S
    erv ...
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    ~~~
        + CategoryInfo          : InvalidOperation: (Microsoft.offic...abase.Exten
       sion:TypeName) [], RuntimeException
        + FullyQualifiedErrorId : TypeNotFound

    What am I doing wrong

    Tx

    Andrew


    Andrew Payze

    Wednesday, July 27, 2016 9:47 PM
  • This error and fix was valid before public release. I'm not sure what Build you're on now but any build after RTM doesn't require you to run the scripts. 
    Thursday, August 4, 2016 8:41 PM
  • The solution above is not required anymore.  It was only required for the Project Server 2016 Beta.  Since then Microsoft has included the extensions.

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Proposed as answer by Andrew Payze Monday, October 24, 2016 1:46 PM
    • Unproposed as answer by Andrew Payze Monday, October 24, 2016 1:46 PM
    • Proposed as answer by Andrew Payze Monday, October 24, 2016 1:47 PM
    Wednesday, August 31, 2016 2:27 AM
    Moderator