Re: Update gram Issue
Joerg Fischer
Have you encountered any Event Log error in the Application Eventlog? Could
be that you are facing a locking issue, however, this should be clearly
indicated by the event log.
Sincerely
Joerg Fischer
"Zia" <Z...@discussions.microsoft.com> schrieb im Newsbeitrag
news:76D29DD7-C170-4EC2...@microsoft.com...
> 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