none
provisioning new PWA from backkup with 5 DB restore in 2010 and get error failed to create platform context RRS feed

  • Question

  • Hello all. We're trying to do a restore of one instance to a new test instance to retrieve some projects.

    When we do the 5 DB restore (MOPS 2010 btw) via provisioning a new PWA in central admin project server service application we get 'an exception has been thrown by the target of the invocation ...failed to create platform context' Any help/ideas are appreciated.

    ULS log and event viewer entries are here:

    Log Name:      Application
    Source:        Microsoft-SharePoint Products-Project Server
    Date:          2012-04-20 12:55:42 PM
    Event ID:      6966
    Task Category: Provisioning
    Level:         Error
    Keywords:     
    User:          xxxxx
    Computer:      xxxxxx.com
    Description:
    Provisioning 'PWA': Post provisioning setup failed. Exception 'Microsoft.Office.Project.Server.Administration.ProvisionException: Post provision setup failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Security.SecurityException: Failed to create platform context: UserName:, CallingUser: xxxxxxxxx, Site: http://xxxxrestore/PWA
       at Microsoft.Office.Project.Server.Base.PlatformContext.FailInitialize(Exception e)
       at Microsoft.Office.Project.Server.Base.PlatformContext..ctor(Boolean isWindowsUser, String username, Guid siteId, SPUrlZone urlZone)
    The Zone of the assembly that failed was:
    MyComputer
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)
       at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
       at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.GetPlatformContext(String Admin, Guid siteId)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.PostProvisionSetup(PostConfigType postConfigType, ProjectSite projectSite, Guid adminGuid)
       --- End of inner exception stack trace ---
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.PostProvisionSetup(PostConfigType postConfigType, ProjectSite projectSite, Guid adminGuid)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)'.
    Event Xml:
    <Event xmlns="http://schemas.microsoftcom/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft-SharePoint Products-Project Server" Guid="{B2178104-1B5B-4C20-8C8F-960678CED9E5}" />
        <EventID>6966</EventID>
        <Version>14</Version>
        <Level>2</Level>
        <Task>20</Task>
        <Opcode>0</Opcode>
        <Keywords>0x4000000000000000</Keywords>
        <TimeCreated SystemTime="2012-04-20T18:55:42.695706600Z" />
        <EventRecordID>134340</EventRecordID>
        <Correlation ActivityID="{7B173AE6-DDC8-4F08-8654-F9EBC35DDA44}" />
        <Execution ProcessID="6044" ThreadID="10372" />
        <Channel>Application</Channel>
        <Computer>xxxxx.com</Computer>
        <Security UserID="S-1-5-21-174793946-378299862-635260049-128222" />
      </System>
      <EventData>
        <Data Name="string0">PWA</Data>
        <Data Name="string1">Microsoft.Office.Project.Server.Administration.ProvisionException: Post provision setup failed. ---&gt; System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---&gt; System.Security.SecurityException: Failed to create platform context: UserName:, CallingUser: xxxxxxxxxxxxx, Site: http://xxxxrestore/PWA
       at Microsoft.Office.Project.Server.Base.PlatformContext.FailInitialize(Exception e)
       at Microsoft.Office.Project.Server.Base.PlatformContext..ctor(Boolean isWindowsUser, String username, Guid siteId, SPUrlZone urlZone)
    The Zone of the assembly that failed was:
    MyComputer
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct&amp; signature, IntPtr declaringType)
       at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
       at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.GetPlatformContext(String Admin, Guid siteId)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.PostProvisionSetup(PostConfigType postConfigType, ProjectSite projectSite, Guid adminGuid)
       --- End of inner exception stack trace ---
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.PostProvisionSetup(PostConfigType postConfigType, ProjectSite projectSite, Guid adminGuid)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)</Data>
      </EventData>
    </Event>


    Log Name:      Application
    Source:        Microsoft-SharePoint Products-Project Server
    Date:          2012-04-20 12:55:42 PM
    Event ID:      6971
    Task Category: Provisioning
    Level:         Error
    Keywords:     
    User:          xxxxxx
    Computer:      xxxxx.com
    Description:
    Failed to provision site PWA with error: Microsoft.Office.Project.Server.Administration.ProvisionException: Post provision setup failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Security.SecurityException: Failed to create platform context: UserName:, CallingUser: xxxxxxx, Site: http://xxxxxrestore/PWA
       at Microsoft.Office.Project.Server.Base.PlatformContext.FailInitialize(Exception e)
       at Microsoft.Office.Project.Server.Base.PlatformContext..ctor(Boolean isWindowsUser, String username, Guid siteId, SPUrlZone urlZone)
    The Zone of the assembly that failed was:
    MyComputer
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)
       at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
       at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.GetPlatformContext(String Admin, Guid siteId)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.PostProvisionSetup(PostConfigType postConfigType, ProjectSite projectSite, Guid adminGuid)
       --- End of inner exception stack trace ---
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.PostProvisionSetup(PostConfigType postConfigType, ProjectSite projectSite, Guid adminGuid)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft-SharePoint Products-Project Server" Guid="{B2178104-1B5B-4C20-8C8F-960678CED9E5}" />
        <EventID>6971</EventID>
        <Version>14</Version>
        <Level>2</Level>
        <Task>20</Task>
        <Opcode>0</Opcode>
        <Keywords>0x4000000000000000</Keywords>
        <TimeCreated SystemTime="2012-04-20T18:55:42.851959600Z" />
        <EventRecordID>134341</EventRecordID>
        <Correlation ActivityID="{7B173AE6-DDC8-4F08-8654-F9EBC35DDA44}" />
        <Execution ProcessID="6044" ThreadID="10372" />
        <Channel>Application</Channel>
        <Computer>xxxxxxx</Computer>
        <Security UserID="S-1-5-21-174793946-378299862-635260049-128222" />
      </System>
      <EventData>
        <Data Name="string0">PWA</Data>
        <Data Name="string1">Microsoft.Office.Project.Server.Administration.ProvisionException: Post provision setup failed. ---&gt; System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---&gt; System.Security.SecurityException: Failed to create platform context: UserName:, CallingUser: xxxxxxx, Site: http://xxxxxrestore/PWA
       at Microsoft.Office.Project.Server.Base.PlatformContext.FailInitialize(Exception e)
       at Microsoft.Office.Project.Server.Base.PlatformContext..ctor(Boolean isWindowsUser, String username, Guid siteId, SPUrlZone urlZone)
    The Zone of the assembly that failed was:
    MyComputer
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct&amp; signature, IntPtr declaringType)
       at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
       at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.GetPlatformContext(String Admin, Guid siteId)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.PostProvisionSetup(PostConfigType postConfigType, ProjectSite projectSite, Guid adminGuid)
       --- End of inner exception stack trace ---
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.PostProvisionSetup(PostConfigType postConfigType, ProjectSite projectSite, Guid adminGuid)
       at Microsoft.Office.Project.Server.Administration.PsiServiceApplication.CreateSite(ProjectProvisionSettings provset)</Data>
      </EventData>
    </Event>


    Ray Letts Arbutus Solutions

    Monday, April 23, 2012 7:30 PM

Answers

  • Hello Ray,

    RES_TYPE=102 indicates account is in inactive state and I believe this is the account has been used as PWA administrator (PWA site provisioning page)

    We need to make the account active , do to so execute following query on Published database

    UPDATE MSP_RESOURCES SET RES_TYPE = 2 WHERE (WRES_ACCOUNT = '{Replace with your Admin Account}')

    Retry to provision the PWA


    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn


    Monday, April 23, 2012 8:13 PM
    Moderator

All replies

  • Hello Ray,

    Post Provisioning error message leads me to the inactive or checked-out admin account

    Execute following query on Project Server Published database and please share the query result

    Select RES_NAME,res_type,RES_CHECKOUTBY from MSP_RESOURCES where  WRES_ACCOUNT='{PWA admin Account}'


    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn

    Monday, April 23, 2012 8:04 PM
    Moderator
  • Hi Hrishi yes saw your previous posting and was wondering about this so ran the query and:

    300A Account, which is the one that runs all SharePoint and Project Server Services found 0 Rows

    The 300B account, which is the Farm Admin / Setup Account Found 1 Row and it is a RES Type of 102

    The 300C Account, which is the Application pool account found 0 rows as well.


    Ray Letts Arbutus Solutions

    Monday, April 23, 2012 8:08 PM
  • Hi there,

    To confirm are you carrying out the 5 DB restore to a separate Test farm? If so, did the PWA site on the Test farm work successfully before the restore?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Monday, April 23, 2012 8:09 PM
    Moderator
  • Hello Ray,

    RES_TYPE=102 indicates account is in inactive state and I believe this is the account has been used as PWA administrator (PWA site provisioning page)

    We need to make the account active , do to so execute following query on Published database

    UPDATE MSP_RESOURCES SET RES_TYPE = 2 WHERE (WRES_ACCOUNT = '{Replace with your Admin Account}')

    Retry to provision the PWA


    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn


    Monday, April 23, 2012 8:13 PM
    Moderator
  • Ray,

    Just a reminder, executing above query on published database is unsupported by Microsoft. You can verify the account status in your source environment by executing first query, if RES_type for the admin account is 2 then take the new set of databases backup (4+1) and try to provision the PWA in your new environment.


    Hrishi Deshpande – DeltaBahn Senior Consultant
    Blog | < | LinkedIn

    Monday, April 23, 2012 8:22 PM
    Moderator