cancel
Showing results for 
Search instead for 
Did you mean: 

Could not find stored procedure 'StoredProcedure'

Issue

When attempting to publish a workflow, publish a form, or run an NWAdmin command you receive the following message:

Could not find stored procedure 'STOREDPROCEDURE'

Resolution

Missing stored procedure messages are in relation to Nintex databases not being updated properly. To ensure your databases are updated, run the following commands in the SharePoint Management Shell or Powershell with Add-PSSnapin Microsoft.SharePoint.PowerShell:

For Nintex Workflow Databases: 
NWAdmin.exe -o UpgradeDatabases

For Nintex Forms Databases: 
Install-NFService
Upgrade-NFService

Error Code

Examples include but are not limited to: NWAdmin -o DetachDatabase - Could not find stored procedure 'GetExtIOSiteMapping' Publishing a Nintex Form - Could not find stored procedure 'NM_DeleteFormByContentTypeAndList' Publishing a Nintex Workflow - Server was unable to process request. ----> Cound not find stored procedure 'NM_DeleteFormByWorkflowBaseID'

Additional Information

These errors indicate that a stored procedure is not present in a database. Running the relevant commands updates/checks the database schema and should recreate the stored procedure.

Related Links

NWAdmin -o UpgradeDatabases
UpgradeDatabases

Install-NFService
Install-NFService

Upgrade-NFService
Upgrade-NFService

Labels: (2)
Version history
Revision #:
5 of 5
Last update:
2 weeks ago
Updated by: