AnsweredAssumed Answered

Problem setting up lazy approval in Central Admin SharePoint 2013 on-prem

Question asked by xakw on Jun 26, 2015
Latest reply on Jun 30, 2015 by shahrzad

When I enter the email address (lazyapproval@nintexqa.Nordstrom.net) in the lazy approval Central Admin section I get an error - the ULS log showa:

Error establishing database connection. SQL Error: 8144.: System.Data.SqlClient.SqlException (0x80131904): Procedure or function SetGlobalSettings has too many arguments specified.     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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, 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.Database.ExecuteNonQuery(SqlCommand command, Boolean useTransaction)  ClientConnectionId:19770ec4-20b6-4cca-acbd-130b95229ccb (Build:3130)

 

This is followed by:

Error enabling or disabling LazyApproval.: System.Data.SqlClient.SqlException (0x80131904): Procedure or function SetGlobalSettings has too many arguments specified.     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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, 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.Database.ExecuteNonQuery(SqlCommand command, Boolean useTransaction)     at Nintex.Workflow.Administration.GlobalConfig.SetGlobalConfig()     at Nintex.Workflow.Administration.LazyApproval.UpdateList(SPWeb web, SPList list, String alias, ConfigurationScope scope, String libraryName)     at Nintex.Workflow.Administration.LazyApproval.<>c__DisplayClass3.<Enable>b__0()     at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass5.<RunWithElevatedPrivileges>b__3()     at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)     at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)     at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)     at Nintex.Workflow.Administration.LazyApproval.Enable(String alias, SPWeb web, ConfigurationScope scope)     at Nintex.Workflow.Administration.LazyApproval.Enable(String alias)     at Nintex.Workflow.ApplicationPages.ManageApprovalAI.btnEnableLazyApproval_Click(Object sender, EventArgs e)  ClientConnectionId:19770ec4-20b6-4cca-acbd-130b95229ccb (Build:3130)

Outcomes