Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.