Nintex Connect

The Official Community Site for Nintex Software Products, including Nintex Workflow 2007, 2010 and 2013; Nintex Workflow for Project Server 2010; Nintex Reporting 2008 and Nintex Analytics 2010; Nintex Forms 2010; Nintex Live and Nintex SmartLibrary.
Welcome to Nintex Connect Sign in | Join | Help
in Search

Error when trying to Approve

Last post 07-19-2012, 12:26 PM by McCool. 2 replies.
Sort Posts: Previous Next
  •  07-09-2012, 10:39 PM 23904

    Error when trying to Approve

    I've setup a simple workflow that has a single request for approval. I've set it up with a flexi task as well as approval. Either way, when I follow the "Respond to Task" link from the Workflow Status page, I get the following error in the ULS:

    Error establishing database connection. SQL Error: 8144.: System.Data.SqlClient.SqlException: Procedure or function GetHumanWorkflowId has too many arguments specified. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString... f4f765e9-1071-40d5-b489-9d481da75ed4
    07/09/2012 13:16:38.66* w3wp.exe (0x2A90) 0x106C Nintex Workflow 2010 Database 0000 Unexpected ...) 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Nintex.Workflow.Administration.Database.ExecuteScalar(SqlCommand command) (Build:2350) f4f765e9-1071-40d5-b489-9d481da75ed4
    07/09/2012 13:16:38.68 w3wp.exe (0x2A90) 0x106C SharePoint Foundation Runtime tkau Unexpected System.Data.SqlClient.SqlException: Procedure or function GetHumanWorkflowId has too many arguments specified. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderT... f4f765e9-1071-40d5-b489-9d481da75ed4
    07/09/2012 13:16:38.68* w3wp.exe (0x2A90) 0x106C SharePoint Foundation Runtime tkau Unexpected ...ds(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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Nintex.Workflow.Administration.Database.ExecuteScalar(SqlCommand command) at Nintex.Workflow.HumanApproval.NintexTask.GetHumanWorkflowId(SPWeb web, Guid taskListId, Int32 spTaskId) at Nintex.Workflow.HumanApproval.NintexTask.RetrieveTask(Int32 spTaskID, SPWeb web, SPList taskList) at Nintex.Workflow.ApplicationP... f4f765e9-1071-40d5-b489-9d481da75ed4
    07/09/2012 13:16:38.68* w3wp.exe (0x2A90) 0x106C SharePoint Foundation Runtime tkau Unexpected ...ages.ApproveReject.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(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 System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) f4f765e9-1071-40d5-b489-9d481da75ed4
    07/09/2012 13:16:38.68 w3wp.exe (0x2A90) 0x106C SharePoint Foundation Performance nask High An SPRequest object was not disposed before the end of this thread. To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it. This object will now be disposed. Allocation Id: {8E333660-444B-4695-BFDB-634BA0F1DF36} To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true. f4f765e9-1071-40d5-b489-9d481da75ed4
    07/09/2012 13:16:38.68 w3wp.exe (0x2A90) 0x106C SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:https://aaaaaaa.aaaaaaa.aaa:443/WPR/_layouts/NintexWorkflow/ApproveReject.aspx?List=9af6842c%2Db106%2D4ee9%2D8475%2D456a38afbe3d&ID=7&source=https%3A%2F%2Fsp2010beta%2Elanl%2Egov%2FWPR%2F%5Flayouts%2FNintexWorkflow%2Fpreview%2Easpx%3Fmode%3DRunTime%26InstanceId%3Da7e30eb0%2D3730%2D42ec%2D8c7d%2Debf04f8ea3a9&Web=03678c4d%2Deccc%2D439c%2Dbe3e%2D88a0341cb644)). Execution Time=1043.05896419796 f4f765e9-1071-40d5-b489-9d481da75ed4

    Where should I look to next?

    Thanks,

    Brian

     

  •  07-15-2012, 4:25 AM 24076 in reply to 23904

    Re: Error when trying to Approve

    Hi,

    I would first check in Central Administration to make sure the database does not need to be updated, I believe in the database administration section. If it needs to be updated the GUI will tell you and you should do so.

    If the database is up to date, then I am not sure and it would be best to escalate via support@nintex.com who can provide more assistance.

  •  07-19-2012, 12:26 PM 24156 in reply to 24076

    Re: Error when trying to Approve

    The database was out of date.  Once our admins fixed that the workflows worked as they should!
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems