cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

2010/2013 migration: error mounting configuration database

Jump to solution

Hi there,

I'm currently migrating SharePoint 2010 farm with Nintex Workflow 2010 installed to SharePoint 2013 with Nintex Workflow 2013. Following the guidelines in "Nintex Workflow 2010 – 2013 Upgrade instructions" I'm running into an error at step "Nintex Workflow Configuration Database > Using an existing configuration database". When mounting the restored Nintex configuration (and content) database in SharePoint 2013 the following error message appears in Central Admin: "Sorry, something went wrong
Unexpected SQL error occurred. Server name: SERVICE_ALIAS; Database name: NintexWorkflowDb."

In the ULSLogs there's some more detailed information/error message:

06.26.2015 14:34:09.18 w3wp.exe (0x07F0) 0x3764 Nintex Workflow 2013 Database 00000 Unexpected Error provisioning database:: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Parameters'.  Invalid column name 'Parameters'.  Invalid column name 'Parameters'.  Invalid column name 'Parameters'.  Changed database context to 'NintexWorkflowDb'.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Nintex.Workflow.Administration.DBExecuteScript.ActionScript(String script, Boolean useTransaction)     at Nintex.Workflow.Administration.DBExecuteScript.ExecuteEmbeddedScript(String scriptResourceName, String dbName, Boolean useTransaction)     at Nintex.Workflow.Administration.ConfigurationDatabase.EnsureExistingConfigDatabase(String databaseName, SqlConnectionStringBuilder connectionString)     at Nintex.Workflow.AdministrationPages.DatabaseSettings.btnOk_Click(Object sender, EventArgs e)  ClientConnectionId:fc9d1ec4-3452-495c-a311-cee725a03368 (Build:3120) 8820149d-5700-3062-191c-600586c76975
06.26.2015 14:34:09.21 w3wp.exe (0x07F0) 0x3764 SharePoint Foundation General 8nca Medium Application error when access /_admin/NintexWorkflow/DatabaseSettings.aspx, Error=Unexpected SQL error occurred. Server name: SERVICE_ALIAS; Database name: NintexWorkflowDb.   at Nintex.Workflow.AdministrationPages.DatabaseSettings.btnOk_Click(Object sender, EventArgs e)     at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 8820149d-5700-3062-191c-600586c76975
06.26.2015 14:34:09.24 w3wp.exe (0x07F0) 0x3764 SharePoint Foundation Runtime tkau Unexpected Microsoft.SharePoint.SPException: Unexpected SQL error occurred. Server name: SERVICE_ALIAS; Database name: NintexWorkflowDb.    at Nintex.Workflow.AdministrationPages.DatabaseSettings.btnOk_Click(Object sender, EventArgs e)     at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 8820149d-5700-3062-191c-600586c76975
06.26.2015 14:34:09.25 w3wp.exe (0x07F0) 0x3764 SharePoint Foundation General ajlz0 High Getting Error Message for Exception System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.SharePoint.SPException: Unexpected SQL error occurred. Server name: SERVICE_ALIAS; Database name: NintexWorkflowDb.     at Nintex.Workflow.AdministrationPages.DatabaseSettings.btnOk_Click(Object sender, EventArgs e)     at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)     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.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 8820149d-5700-3062-191c-600586c76975

To make a long story short: I'm pretty clueless how to solve this error. However, what I've seen is that when I then create a new configuration database and mount the above database as content database only, it obviously works. Well, I don't want to create a new configuration database but migrate everything from source SharePoint 2010 system to target 2013 environment.

Anybody has a clue what might be the error here?

Forgot to mention the respective versions of Nintex Workflow and its database. Nintex Workflow 2010 is running at version 2.4.4.11, database schema versions as follows:

Data Source=spdbserver;Initial Catalog=SP2010_Nintex;Integrated Security=True
Type: Configuration
Version: 2.0.2.7
Data Source=spdbserver;Initial Catalog=SP2010_Nintex;Integrated Security=True
Type: Content
Version: 2.0.2.7

Nintex Workflow 2013 is running at version 3.1.2.0. Dedicated database version is 3.0.0.9 (when creating new configuration/content database).

Any help and support is appreciated.

Kind regards and thanks in advance

Michael

Labels: (1)
0 Kudos
Reply
3 Replies
Highlighted
Nintex Newbie

Re: 2010/2013 migration: error mounting configuration database

Jump to solution

I'm also receiving this error - did you find a solution?

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: 2010/2013 migration: error mounting configuration database

Jump to solution

This issue will occur when the version for the 2010 Farm is newer than the version for the 2013 farm.  In this case, migrating from version 2.4.4.11 (June 2015 Build) to version 3.1.2.0 (January 2015 Build) caused this behavior.  The reason why this will cause issues is that the database schema on the 2010 version will not match with the 2013 build and cannot be updated to do so. The standard scripts that attach the database to the farm, will typically run through the database schema updates for each new version of the product, but when the 2013 version is older, the database will not be able to build the schema to the correct version.

As a best practice, we always recommend migrating only to the same release (2010 / 2013 released on same day) or newer of the product. 

View solution in original post

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: 2010/2013 migration: error mounting configuration database

Jump to solution

Hi ‌,

I know your question is old but have you been able to solve your migration issue following Dan Burke's suggestion? If yes, could you write us back so we can mark it as correct (if it is..), the author of the question has deactivated the account so I can't ask him about the issue..

Giacomo

0 Kudos
Reply