
TLDR is in the last paragraph so jump there if you’re in a hurry.
A developer was attempting to deploy a site workflow to a new site and sent this error message to me. This was new but I assumed it had something to do with the fact that I had had some difficulty getting the site setup, which can happen for a number of reasons. When a site fails to setup as expected (I script site setups), I go in and delete the site, detach the SharePoint Content Database, remove the entries from a few Nintex tables via sql, Delete the databases from the sql instance, do an IIS reset and then start the process over again. For this site I had to run through this not once but 3 times!
My first stop was Central Admin to check the 3 pages in the Database Setup area. The view Database Mappings page showed that the site URL did not have the Workflow Database value so I went into Manage Database Mappings to try to set it. Well I got an error on that page that I’ve seen before when the mappings were off so I was getting closer.
I opened SSMS and checked the nintex mappings in the Storage, ContentDbMapping and Databases tables. Sure enough the DatabaseId in the Storage table was 1 less than the NWContentDbId value in the ContentDbMapping table. This was due to the multiple setups. I updated it and then checked back in CA on the the View Database Mappings page and it was showing correctly now. However the Manage Databse Mappings page still threw an error. This will still throw an error until some time has passed and then the changes will be properly reflected.
However this didn’t resolve the problem! The developer had tried to publish a workflow before there was a proper mapping of the site to a nintex database. As you know that’s kind of a required element. There was a folder in the NintexWorkflows library (<fqdn to site>/NintexWorkflows/Forms/AllItems.aspx) on the Sharepoint site that had been created and was empty. Once deleted he was able to publish the workflow.
For you sadists here is the corresponding URL entry for this error:
0x197C SharePoint Foundation Runtime tkau Unexpected System.ArgumentException: urlOfFile Parameter name: Specified value is not supported for the urlOfFile parameter.
at Microsoft.SharePoint.SPFileCollection.get_Item(String urlOfFile)
at Nintex.Workflow.WorkflowRepository.NameInUse(String workflowName, Guid listId, WorkflowType& workflowType)
at Nintex.Workflow.ApplicationPages.SetName.Page_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at Microsoft.SharePoint.WebControls.UnsecuredLayoutsPageBase.OnLoad(EventArgs e)
at Microsoft.SharePoint.WebControls.LayoutsPageBase.OnLoad(EventArgs e)
at Nintex.Workflow.ServerControls.NintexLayoutsBase.OnLoad(EventArgs e)
at Nintex.Workflow.ApplicationPages.SetName.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Getting Error Message for Exception System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentException: urlOfFile Parameter name: Specified value is not supported for the urlOfFile parameter.
at Microsoft.SharePoint.SPFileCollection.get_Item(String urlOfFile)
at Nintex.Workflow.WorkflowRepository.NameInUse(String workflowName, Guid listId, WorkflowType& workflowType)
at Nintex.Workflow.ApplicationPages.SetName.Page_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at Microsoft.SharePoint.WebControls.UnsecuredLayoutsPageBase.OnLoad(EventArgs e)
at Microsoft.SharePoint.WebControls.LayoutsPageBase.OnLoad(EventArgs e)
at Nintex.Workflow.ServerControls.NintexLayoutsBase.OnLoad(EventArgs e)
at Nintex.Workflow.ApplicationPages.SetName.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ba25629f-eb8d-2008-632b-ce07b318b838