Skip to main content
Nintex Community Menu Bar

Could not find stored procedure 'StoredProcedure'

  • March 26, 2021
  • 0 replies
  • 111 views
  • Translate

Forum|alt.badge.img+8

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

 

Did this topic help you find an answer to your question?

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings