Summary

This article details hotfix 1012797 for Laserfiche Workflow Suite 8.0.1, which resolves the following issue:

• Laserfiche Workflow does not create a new workflow instance when an LDAP user account satisfies a starting rule. The Workflow error.log file will contain an entry similar to the following (73293):

Timestamp: 5/26/2011 5:13:29 PM
Message: HandlingInstanceID: 1ea4d76f-74ae-4f17-9834-cf28d0c9f90d
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
05/26/2011 10:13:29
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Procedure or function 'UpdateWorkflowInformation' expects parameter '@User', which was not supplied.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 16
LineNumber : 0
Number : 201
Procedure : UpdateWorkflowInformation
Server : SampleServer
State : 4
ErrorCode : -2146232060
Data : System.Collections.ListDictionaryInternal
TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
Stack Trace : 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 Laserfiche.Workflow.Runtime.SearchTrackingDatabaseProvider.UpdateWorkflowInformation(Int64 internalId, String ruleName, String workflowName, String user, Int32 version)

The update includes the following files:

• Laserfiche.Workflow.Subscriber.exe (8.0.1.577)
• Laserfiche.Workflow.dll (file version 8.0.1.571)

Resolution

The hotfix is available as a self-contained .exe file.

After applying the hotfix, Workflow will properly initiate new workflow instances when an LDAP user account satisfies a starting rule; however, be aware of the following caveats:

• The value of the initiator token for such a workflow instance will be the SID of the LDAP user.
• If you want to search for workflows started by an LDAP user, you must search using the LDAP user's SID.

To update Workflow 8.0.1

1. Click one of the following links to download either the 32-bit or 64-bit version of the hotfix for the Workflow Subscriber:

Subscriberx86 - June 2011 Rollup KB1012797.zip

Subscriberx64 - June 2011 Rollup KB1012797.zip

2. Extract the contents of the zip file to a temporary location on the Workflow Subscriber computer and double-click the appropriate .exe to begin the update.

Related Links

The 1012797 Workflow Subscriber update also contains the Subscriber hotfix previously released in the following Knowledge Base article:

1012678 List of Changes for Workflow 8.0.1 Cumulative Hotfix 1012678.

For more information on Workflow 8.0.1 hotfixes, see:

1012551 FIX: Release and Hotfix Information for Laserfiche Workflow 8.0.1.