Where is InsertInstanceState SP?

Apr 18, 2007 at 3:21 PM
Hi All,

I am trying to make my damn project work using WCSF. It keeps on complaining, Could not find stored procedure 'InsertInstanceState'. This is supposed to be in PageFlowPersistenceStore. I could not find the script either. Can some one guide me where is the script?

Cheers!
Sameer
Apr 19, 2007 at 5:54 AM
Well...!

On googling I found that the SP is not part of WCSF but of WWF. Amazingly i have installed all the stuff necessary for WCSF including WWF extensions but still I donno how the installer could miss these SPs.

The script for the SP mentioned is available at,

C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN

Hope this would help someone like me who lost in darkeness.

Cheers...!
Sameer.



dsameer wrote:
Hi All,

I am trying to make my damn project work using WCSF. It keeps on complaining, Could not find stored procedure 'InsertInstanceState'. This is supposed to be in PageFlowPersistenceStore. I could not find the script either. Can some one guide me where is the script?

Cheers!
Sameer


Apr 28, 2007 at 6:42 AM
Open the web.config in the development web site.
Find the following string: System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService
(only occurs once. This is where the connection to the database is added for the workflow persistence)
Change the initial catalog to WorkflowPersistence

Don't ask why the initial catalog was set to the sample database :).