BizTalk 2006 Event Log Warnings – Cannot insert duplicate key row in object ‘dta_MessageFieldValues’ with unique index ‘IX_MessageFieldValues’.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizTalk 2006 Event Log Warnings – Cannot insert duplicate key row in object ‘dta_MessageFieldValues’ with unique index ‘IX_MessageFieldValues’.

Viewing 0 reply threads
  • Author
    Posts
    • May 1, 2015 at 4:24 AM #26510
      community-content

        Hi There,

        We have been seeing the following ‘warnings’ in the event log of our BizTalkmachine since upgrading to BTS 2006. They seem to occurrandomly 6 or 8 times per day.

        Does anyone know what this means and whatneeds to be done to clear it up? we have only one BizTalk server which is running on only one machine.

         am new to BizTalk, so I am unable to find how many tracking host instances running for BizTalk server. Also, can you please let me know that we can configure only one instance for one server/machine?

        Source: BAM EventBus

        ServiceEvent: 5

        Execute batch error. Exception information: TDDS failed to batch executionof streams. SQLServer: bizprod, Database: BizTalkDTADb.Cannot insertduplicate key row in object ‘dta_MessageFieldValues’ with unique index’IX_MessageFieldValues’.The statement has been terminated..

    • Author
      Posts
    Viewing 0 reply threads
    • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.