Could not find stored procedure 'RetrieveNonblockingInstanceStateIds' RRS feed

  • Question

  • hi all
    i have downloaded an windows workflow example from the net. The name of the project is "HelpDeskWorkflow".
    When I execute the project I get the error:
     "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Workflow.Runtime.dll
    Additional information: Could not find stored procedure 'RetrieveNonblockingInstanceStateIds'."

    I mentioned by Shawn I have executed the "CreateDatabaseObjects.cmd" executatble. The "TrackingStore" Database is created and the "RetrieveNonblockingInstanceStateIds" SP is foundin this database. I have executed this SP in the database of the project.

    Even after doing all this, I still continue to get the error. Can Anyone help me out???

    Thanks in advance


    Sunday, May 11, 2008 10:11 AM


  • Can you post a link for where you downloaded the sample from?  The stored proc should be in the persistence database, not the tracking one.

    Sunday, May 11, 2008 6:26 PM