Updategram issue

Home Page Forums BizTalk 2004 – BizTalk 2010 Updategram issue

Viewing 1 reply thread
  • Author
    Posts
    • #16827

      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

    • #17000

      Are you getting any errors in the event log?  If not, it must be some problem with your data colliding with each other or locking in some manner.

       

      Maybe you need to always process your 5 files in order?  This can be set on the Send Port (assuming they all use the same Send Port).

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.