BizTalk Server Orchestration - Updating a database from Orchestration

Author

Updating a database from Orchestration

njhudson

2005-08-05, 8:47 pm

I have an orchestration which updates a value in a SQL Server database
using the SQL Adapter and calling a stored procedure. The stored
procedure simply icrements the field each time. A map used in the
orch then uses the database lookup functoid to retrieve the new
value. But I noticed a couple of odd behaviors: First, even though
the send shape that sends a message to the SQL Adapter comes before
the transformation shape, the old value is sometimes used by the map.
I also sent five files into this orchestration and each occurence of
the field had the same post update value in it instead of five
separte values incremeted by one each time. What is happening here
and how do I cure it?

Thanks,
Nathan