SO I re-ran the install for Workflow.... Install went really fast (like it really did not have anything or much to update) and everything look fine ...except that I did not have an option to upgrade the DB.
Tested my workflow, and I got the same error.
Poked around trying to find out what the deal was...went back to the Nintex DB page and I WAS no able to upgrade the DB.
I was thinking Awesome!... upgraded the DB.... I still get the error
Really old Post, but had the issue last week. We were upgrading from Nintex 2013 to Nintex 2016. It should be the same solution if migrating to 2019 or SPSE.
If you get this message after trying to publish in your new environment:
Server unable to process request --> Could not find stored procedure "NM_DeleteFormByWorkflowBaseID".
Chances are that during the FORMS database configuration, the specified configuration database was the Workflow one, NOT the Forms one. Nintex support helped me by going to central admin and writing this URL on the browser:
http://YOUR_CENTRAL_ADMIN/_admin/NintexForms/ProvisionDatabase.aspx
Now specify the FORMS database you attached to the new SQL Server. In my case, the specified database was wrong and pointed to the workflow configuration database. That is why it could not find the stored procedures.
After that, upgrade your database and make sure to restart the server. Now its working fine.