Workflow and ServiceDesk Community

 View Only
  • 1.  Execute Reader error in a Workflow project

    Posted Jul 18, 2013 10:25 AM
      |   view attached

    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?

    Attachment(s)



  • 2.  RE: Execute Reader error in a Workflow project

    Posted Jul 18, 2013 03:03 PM

    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.