Hi,
I am using Updategram to insert the messages into the SQL Server. I
have five scheduled jobs which run at the same time and download the
files from the client server and then after some processing, saves them
into our SQL Server Database same Table. My schedules run once a day.
Sometimes all the files gets saved into the SQL Server and sometime one
or two are missing. I have enabled the message tracking and I can see
all the five files Updategram messages being created and passed to the
Send port. But still only four files were saved into the SQL Server.
Then i saved the message from the tracking database into the file and
passed the message again to the Biztalk receive port, and then the same
message was saved to the SQL Server. This is a very strange behaviour.
Since the message which was sent to SQL Adaptor send port in morning
didn't save the data, but when the same message was thrown into the
receive location later in the day, it did work. I have compared the
Updategram's created in the morning with the one i have just tested.
They both are exactly same.
Does any body have any idea why this could be happening? Any sort of
hint would be of great help.
Regards,
Zia