[BizTalker] Open DataReader Problem

[CRANFORD, CHRIS]

Title: Open DataReader Problem

I have developed an orchestration that receives an incoming message from SAP and the performs the following ODBC transactions:

ODBC Send/Recv To Get Header Record Sequence Id
ODBC Send To Insert Header Record
Loop For Each Line
  ODBC Send/Recv To Get Line Record Sequence Id
  ODBC Send To Insert Line Record
End Loop

I see this error a lot in HAT regarding this orchestration:
  There is already an open DataReader associated with this connection which must be closed first.

Is there something I am doing wrong or is there something I need to do in order to prevent this from happening?  Sometimes it seems once another message comes in that BizTalk picks up where it left off for this message type and continues to process them.  Just wanted to make sure when I start looking at a large scale amount of volume that this won't become an issue.

Thanks
Chris

_______________________________________________________
Chris Cranford
Programmer/Developer
SETECH Inc. & Companies
6302 Fairview Rd, Suite 201, Charlotte, NC  28210
Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042 
Email: chris.cranford@xxxxxxxxxxxxx

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net