|
| facts:
w2k3, sql2ksp3x, bts2k4sp1
i have to receive and sort a very large amount of messages, buffer them into
sql table (as xml in a text field), and send out sorted under special
conditions...
i put the messages into the table from orch. using sql adapter and a stored
procedure. later in the same orch. i call a method from an external assembly
that builds a custom select statement and will gets selected data from the
table and returns me back in my orch. this scenario runs fine when i put ONE
message to process. but if i put a lot of messages into biztalk, there comes
out several exceptions like "unknown exception", "network error", "there is
already an open datareader associated with this connection which must be
closed first" or "null reference exception". these exc. happens after
'SQLDataAdapter.Fill(dsResult);' in external method.
the reason for not using the sql adapter to get the messages out of the sql
table is the datatype 'text' for the message field.
i spent a lot of time in the last few days to solve the problem, but without
any results...
thanks in advance,
lars
|
|