Video Screencast Help

Execute Reader error in a Workflow project

Created: 18 Jul 2013 • Updated: 18 Jul 2013 | 1 comment

I am developing a workflow project whose Configurable Auto Start component reads a database to determine if there is any work to process.  Following the Configurable Auto Start I execute the same query again to pull the Ids of the records to be processed.  For each of the record Ids I execute a component that uses the ORMQueue to create a Request object which is then processed.

I am having intermittent problems where I get an error dealing with the DataReader.  The messages are

ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.  The Transaction property of the command has not been initialized.

or

There is already an open DataReader associated with this Command which must be closed first

Are there components I can utilize to resolve these errors when they are thrown?

Operating Systems:

Comments 1 CommentJump to latest comment

M Rutledge's picture

I realized my workflow lacked an Exception Trigger component that would catch any errors and then go to the End component.  Once I added that logic, the workflow would get cleaned up between executions.