at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at LogicBase.Ensemble.Workflow.Reporting.Gateways.SQLStorageGateway.ExecuteCommand(IDbConnection con, IDbCommand cmd)
The SQl query surrounding the UpdateProcessLastModifiedDate, a query that is used frequently, was returning an unnecesarily excessive amount of data. Much more than was required. Mostly due to the use of SELECT * and an improper WHERE clause configuration. There was also an UPDATE which was updating all the columns even though only a single column needed to be updated.
In all cases, for this query to perform its required function, the only column that needed to be updated was ModifiedOn in the ReportProcess table. This is done every time a change is made to a process.
A revised build of Workflow - 7.5.3001.64 or later, contains this fix. See KB Article HOWTO95421, for the correct build.
Servicedesk 7.5 Mp1
Imported Document ID: TECH225361
Subscribing will provide email updates when this Article is updated. Login is required.