cancel
Showing results for 
Search instead for 
Did you mean: 
cbrutscheck
Nintex Newbie

Existing workflows does not start after moving databases

Hello,

 

we recently moved our databases to another server by using a nintex manual (http://nintexdownload.com/Nsupport/Moving_NW2010db.pdf).

We also set an alias via cliconfg.

 

Everything seems to work, but existing workflows don't start.

New workflows in the same website collection work properly.

I've installed the newest Version of Nintex Workflows 2010 (2.5.8.0), but the behavior didn't change.

 

The following errors pop up in the log:

  • Error establishing database connection. SQL Error: 229.: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'DirectInsertWorkflowInstance', database 'NW2010DB_qmportal_qm_gesamt', schema 'dbo'.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Nintex.Workflow.Administration.Database.ExecuteNonQuery(SqlCommand command, Boolean useTransaction) (Build:2580)
  • Failed to create non existing workflow instance (Instance Id: c94f8c72-5c1e-4375-9ea7-8d28ff4b186f) from HistoryEventReceiver: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'DirectInsertWorkflowInstance', database 'NW2010DB_qmportal_qm_gesamt', schema 'dbo'.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Nintex.Workflow.Administration.Database.ExecuteNonQuery(SqlCommand command, Boolean useTransaction)     at Nintex.Workflow.Runtime.WorkflowInstance.DirectInsertWorkflowInstance(SPWorkflow workflow)     at Nintex.Workflow.Features.WorkflowHistoryEventReciever.ItemAdded(SPItemEventProperties properties) (Build:2580)

 

Do you have any suggestions?

 

Thank you in advance!

Labels: (1)
0 Kudos
Reply
1 Reply
Highlighted
PSTERN
Nintex Newbie

Re: Existing workflows does not start after moving databases

We are facing same issue on our production enviroment, I have raised a support case today, it happen recently end of March 2019

 

Failed to create non existing workflow instance (Instance Id: 9321a502-103e-47a2-99b4-c90aa195197c) from HistoryEventReceiver: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'DirectInsertWorkflowInstance', database 'Nintex2010_content', schema 'dbo'.   

 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)   

 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   

 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)   

 

Error establishing database connection. SQL Error: 229.: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'DirectInsertWorkflowInstance', database 'Nintex2010_content', schema 'dbo'.   

 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)   

 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)   

 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

0 Kudos
Reply