none
Unknown error when trying to change the Workflow proxy account after Database-attach core upgrade to Project Server 2010 RRS feed

  • Question

  • Hi,

    I have followed the guide: http://technet.microsoft.com/en-us/library/ee662499(office.14)#provision to upgrade from 2007 to 2010 in a new server setup (2008R2).

    And everything have worked fine but when trying to change the Workflow Proxy User, the GUI gives me "An unexpexted error has occured"

    Here is the Sharepoint logs for this event, not a pretty format I know:

    09/07/2012 09:08:39.57 w3wp.exe (0x1740)                       0x10DC Project Server                 Project Web App               2q1k Exception System.Data.StrongTypingException: The value for column 'WRES_ACCOUNT' in table 'Resources' is DBNull. ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.     at Microsoft.Office.Project.Server.Schema.ResourceDataSet.ResourcesRow.get_WRES_ACCOUNT()     --- End of inner exception stack trace ---     at Microsoft.Office.Project.Server.Schema.ResourceDataSet.ResourcesRow.get_WRES_ACCOUNT()     at Microsoft.Office.Project.PWA.ApplicationPages.WorkflowSettingsPage.ActionBtn_Click(Object sender, CommandEventArgs e)     at Microsoft.Office.Project.PWA.CommonControls.PWAButton.OnClick(CommandEventArgs e)     at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)     at System.Web.UI.Page.ProcessReque... 84343041-f69c-4810-997a-9f595b9a44e1
    09/07/2012 09:08:39.57* w3wp.exe (0x1740)                       0x10DC Project Server                 Project Web App               2q1k Exception ...stMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 84343041-f69c-4810-997a-9f595b9a44e1
    09/07/2012 09:08:39.57 w3wp.exe (0x1740)                       0x10DC Project Server                 Unified Logging Service       c91s Monitorable Watson bucket parameters: Microsoft Project Server 2010, ULSException14, 070f6ea0 "project server", 0e00178d "14.0.6029.0", 45684664 "microsoft.office.project.schema", 0e00177f "14.0.6015.0", 4d0ffd7c "tue dec 21 02:06:04 2010", 0000678c "0000678c", 00000026 "00000026", 97e4a676 "strongtypingexception", 3271316b "2q1k" 84343041-f69c-4810-997a-9f595b9a44e1
    09/07/2012 09:08:39.57 w3wp.exe (0x1740)                       0x10DC SharePoint Foundation         Runtime                       tkau Unexpected System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.    at Microsoft.Office.Project.Server.Schema.ResourceDataSet.ResourcesRow.get_WRES_ACCOUNT() 84343041-f69c-4810-997a-9f595b9a44e1

    Anyone got any information about this issue?

    Friday, September 7, 2012 7:12 AM

All replies

  • If the account is no exist in the SPS, Project Server ERP and the active directory, it will give the following account.

    The specified Workflow Proxy User account does not exist.

    However the account is there, but the NT account is not present in the MSP_Resources in Published database, then it will give this error

    Check the published database using the following Query.

    select * from MSP_RESOURCES where RES_NAME=' Resource Name'

    select WRES_ACCOUNT from MSP_RESOURCES where RES_NAME='Resource Name'

     


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management


    Monday, September 10, 2012 4:30 PM
    Moderator
  • Hi and thanks for trying to solve this.

    However the account looks fine as far as I can see in MSP_RESOURCES.

    I can see both RES_NAME and WRES_ACCOUNT for the account I´m trying to change to.

    The above error is generated for what ever account i´m entering.

    Looking at the Stored Procedures for this database shows one called  [MSP_WORKFLOW_CreateDefaultWorkflowProxyUser].

    Would a workaround for this problem be to update the table "MSP_WEB_ADMIN" and set WADMIN_WORKFLOW_PROXY_UID to NULL and the manually run the storedprocedure with the correct WADMIN_WORKFLOW_PROXY_UID?

    Any Ideas what the impact might be?

    Tuesday, September 11, 2012 7:45 AM
  • Logically no impact, better you check it on Development Server before production.

    Try to update the new account through PWA after making the  WADMIN_WORKFLOW_PROXY_UID to NULL.

    Direct database modification is not supported by MS, recommend to open a support incident.


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management

    Thursday, September 13, 2012 3:34 PM
    Moderator
  • Hi Sriram,

    I have same problem. Need you help please. I have this problem on project server 2013 not on 2010.

    I have update WADMIN_WORKFLOW_PROXY_UID to null. Now when I try to update from Central admin UI, still gettting same error.

    Also I don't see [MSP_WORKFLOW_CreateDefaultWorkflowProxyUser] stored proc in 2013, so not even able to update using stored proc.

    Can I execute update query "update MSP_WEB_ADMIN" table and set WADMIN_WORKFLOW_PROXY_UID = '<<GUID>>' "? Do you see any issues doing so?

    Thanks in advance...

    Thursday, November 21, 2013 2:27 PM
  • In project server 2013 , we recommend declarative workflow model.

    Did you configure Workflow Manager, Service Bus on your SPS farm?

    Or, want to setup traditional workflow model?

    http://msdn.microsoft.com/en-us/library/office/jj163494.aspx


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management

    Thursday, November 21, 2013 3:39 PM
    Moderator
  • Hi Sriram,

    We have recently migrated to project server 2013. So we are using traditional workflow model for our old workflows. however we have install and configure Workflow manager for new workflow which will come in future.

    Now problem is Workflow proxy account is configured with farm admin(system account) service account, due to which workflow are not getting triggered. When ever we are trying to create project queue job "start workflow" is failing with error mentioned below. Also project site update job is failing.

    WorkflowCannotStartWorkflow (35100). Details: id='35100' name='WorkflowCannotStartWorkflow' uid='72a773ca-2a51-e311-942e-005056072911'.

    So we want to change workflow proxy account. But its not allowing to change workflow proxy account.

    Thanks in advance...

    Thursday, November 21, 2013 5:48 PM
  • Hi Sriram,

    For changing workflow proxy account can I execute update query in Sql DB "update MSP_WEB_ADMIN" table set WADMIN_WORKFLOW_PROXY_UID = '<<GUID>>' "? Do you see any issues doing so?

    Thank you...

    Thursday, November 21, 2013 6:13 PM
  • What is the current UID configured in that table?

    Direct DB change is an unsupported scenario...Go ahead if you are trying on Test environment.

    However, I have some questions.

    WorkflowCannotStartWorkflow (35100) is a common error.

    Did you see any error related proxy account?

    What is the error in ULS when you update the value in GUI?

    Did you check the ULS when the project failed to start?

    Do you have SharePoint web service on project server application server?


    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management

    Thursday, November 21, 2013 6:26 PM
    Moderator