Missing stored procedure "RetrieveNonblockingInstanceStateIds"

Marcus Lindblom

Vote:

I have installed EPiServer CMS RC1 using EPiServerManager but at least one stored procedure is missing. Is this a known issue and how can i solve the problem?

#15669

May 04, 2007 8:45

Johan Björnfot

Vote:

That is a stored procedure that is shipped with .NET 3.0 (workflow part). Make sure you have installed .NET 3.0 on your machine. You can manually install the workflow schema/logic on your existing episerver db by running C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN\SqlPersistenceService_Schema.sql and C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN\SqlPersistenceService_Logic.sql (that is the script the installer runs)

#16112

May 04, 2007 9:16

Marcus Lindblom

Vote:

Thank you, that solved my problem.

#16113

May 04, 2007 16:41

Jonas Hjalmarsson

Vote:

This bug occurs in the swedish version of Windows 7. I solved it by duplicating the existing 'sv' directory to one called 'EN' in the Windows Workflow Foundatione\SQL directory since the installation is interrupted otherwise,

#33739

Oct 19, 2009 14:09

Shailendra Dukane

Vote:

Thank you! Johan Björnfot This also resolved my problem

#173738

Jan 06, 2017 13:55