none
Project Server Workflow and Appsettings RRS feed

  • Question

  • To which config file should I write my settings to be able to read them through Project server workflow?

    I tried to write in the sharepoint portal web.config and to  Microsoft.Office.Project.Server.Queuing.exe.config none of them worked!

    so, any body have tried this?

     


    Twitter : @MShoubaki | http://jo.linkedin.com/in/mshoubaki
    Tuesday, October 25, 2011 1:44 PM

Answers

  • Hi,

    Workflow is being maintained by the Queue Engine, you have to maintain your settings in C:\Program Files\Microsoft Office Servers\14.0\Bin\Microsoft.Office.Project.Server.Queuing.exe.config.

    e.g;

      <connectionStrings>

          <remove name="LocalSqlServer"/>

          <add name="LocalSqlServer" connectionString="data source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=aspnetdb" />

          <add name="conPubDB" connectionString="Data Source=LTGDEDISSQL01\Sharepoint;Initial Catalog=ProjectServer_Published;uid=psrptuser;pwd=pass@word1" providerName="System.Data.SqlClient" />

       </connectionStrings>

     

    Hope this helps.

     


    Ravishankar
    Wednesday, October 26, 2011 5:20 AM
  • hi DiptiK,

    the machine.config wont help you , because the workflow reads settings from 

     C:\Program Files\Microsoft Office Servers\14.0\Bin\Microsoft.Office.Project.Server.Queuing.exe.config.

    for the GUIDs I create my own XML file and I read them from there.

    good luck.


    Twitter : @MShoubaki | http://jo.linkedin.com/in/mshoubaki

    • Proposed as answer by DiptiK Monday, February 11, 2013 4:40 PM
    • Marked as answer by Mohammad Shobaki Monday, February 11, 2013 4:58 PM
    Thursday, February 7, 2013 12:16 PM

All replies

  • Hi Mohammad,

    you can add your key in app settings section in web.config for PWA app.

    From your custom code, you can read these key.

    I hope this can helps you,

    Best Regards

    Paolo O.

    Tuesday, October 25, 2011 4:22 PM
  • Dear Paolo, If u mean the web.config of the sharepoint web application that hosts the PWA portal, the I tried this but did not work :(

    If u mean another config file would u please clarify this?


    Twitter : @MShoubaki | http://jo.linkedin.com/in/mshoubaki
    Tuesday, October 25, 2011 9:38 PM
  • Hi,

    Workflow is being maintained by the Queue Engine, you have to maintain your settings in C:\Program Files\Microsoft Office Servers\14.0\Bin\Microsoft.Office.Project.Server.Queuing.exe.config.

    e.g;

      <connectionStrings>

          <remove name="LocalSqlServer"/>

          <add name="LocalSqlServer" connectionString="data source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=aspnetdb" />

          <add name="conPubDB" connectionString="Data Source=LTGDEDISSQL01\Sharepoint;Initial Catalog=ProjectServer_Published;uid=psrptuser;pwd=pass@word1" providerName="System.Data.SqlClient" />

       </connectionStrings>

     

    Hope this helps.

     


    Ravishankar
    Wednesday, October 26, 2011 5:20 AM
  • Thanks Ravishankar, perfectly worked :)
    Twitter : @MShoubaki | http://jo.linkedin.com/in/mshoubaki
    Wednesday, October 26, 2011 7:11 AM
  • Hi,

     

    I tried reading the Queue config settings using ConfigurationSettings.AppSettings.

    But the workflow is always reading from the C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config.

    Are there any settings we need to make? Pls help me.

    Appreciate your help.

     

    Thanks,

    Ramesh

    Friday, January 13, 2012 9:05 PM
  • I dont think u need any settings , try after modifying the config file restart the project server queue service,
    Twitter : @MShoubaki | http://jo.linkedin.com/in/mshoubaki
    Friday, January 13, 2012 10:41 PM
  • Hi Ravishankar

    I need to pass the stage GUID's as arguments to the workflow. I added that into COnfigurationManager.appsettings but getting error as

    Error 1 Could not create activity of type 'EngWorkflowSolution.Workflow1.Workflow1'. System.ArgumentNullException: Value cannot be null.
    Parameter name: g
       at System.Guid..ctor(String g)
       at EngWorkflowSolution.Workflow1.Workflow1..ctor() C:\Project Server Workflow\EngWorkflowSolution\EngWorkflowSolution 1 1 


    Do I need to add these values in Microsoft.Office.Project.Server.Queuing.exe.config file. If yes, how can I do it?

    In web.config file I added as

     <add key="InitiationStageUid" value="24427350-81f5-4fe3-97d9-f72a4aecfbb2" />

    In workflow solution I added it as

    public Guid InitiationStageUid = new Guid(System.Configuration.ConfigurationManager.AppSettings["InitiationStageUid"]);

    Else is there any other way to create workflow solution package environment free?

    Right now I have to create the workflow solution package for each environment with respective GUIDs.

    Monday, October 8, 2012 11:40 AM
  • Hi DiptiK,

    I know it is a bit late, but here is an answer to your question:

    http://sharepoint1on1.blogspot.com/2013/01/project-server-2010-workflow-appsettings.html

    Hope it helps!

    • Proposed as answer by DiptiK Wednesday, January 23, 2013 4:44 AM
    Saturday, January 5, 2013 6:22 PM
  • Hi

    Passing the Guid values in machine.config also does not work. It gives me the same error as Error

    1 Could not create activity of type 'EngWorkflowSolution.Workflow1.Workflow1'. System.ArgumentNullException: Value cannot be null.
    Parameter name: g
       at System.Guid..ctor(String g)

    Is there anything different one does.

    Does everyone hardcode the guid values into each environment solution for workflow?

    How does everyone use the workflows?


    Thursday, February 7, 2013 11:42 AM
  • hi DiptiK,

    the machine.config wont help you , because the workflow reads settings from 

     C:\Program Files\Microsoft Office Servers\14.0\Bin\Microsoft.Office.Project.Server.Queuing.exe.config.

    for the GUIDs I create my own XML file and I read them from there.

    good luck.


    Twitter : @MShoubaki | http://jo.linkedin.com/in/mshoubaki

    • Proposed as answer by DiptiK Monday, February 11, 2013 4:40 PM
    • Marked as answer by Mohammad Shobaki Monday, February 11, 2013 4:58 PM
    Thursday, February 7, 2013 12:16 PM
  • Hi Ravishankar Polepalli,

    I am also stuck with same issue in project server 2013, So if you have any suggestion pls share with me, its urgent.

    Thanks

    Vaneet Thakur 

    Friday, August 23, 2013 3:58 AM