Unable to Publish Nintex Workflows After Restoring a Site from Another Farm

Issue

After restoring a site from another farm, saving and publishing Nintex workflows fails without an error message.

Resolution

1. Run the following command in PowerShell get the SiteID of the imported site:

   Add-PSSnapin Microsoft.SharePoint.PowerShellget-SpSite -Identity http://<<replace with your siteurl>> | FL ID

2. Open SQL Management Studio and navigate to Nintex Workflow Config Db > Tables > dbo.Storage.
3. Right-click on dbo.Storage and 'Select top 1000 rows'.
4. Check the results and verify that the Site ID is missing from the list.
5. Go back to the Site at Site Collection level.
6. Click on Site Action > Site Settings (SP 2010) or click on the Cog icon (SP 2013 and above)
7. In Site Collection Features, deactivate 'Nintex Workflow', and then re-activate it.