CODEWITHSUNDEEP
biztalkbiztalk-2006
Ashish Rasal
Ashish Rasal

Reputation: 11

BizTalk 2006 Event Log Warnings - Cannot insert duplicate key row in object 'dta_MessageFieldValues' with unique index 'IX_MessageFieldValues'

We have been seeing the following 'warnings' in the event log of our BizTalk machine since upgrading to BTS 2006. They seem to occur randomly 6 or 8 times per day.

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

I 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 Service

Event: 5

Warning Details: Execute batch error. Exception information: TDDS failed to batch execution of streams. SQLServer: bizprod, Database: BizTalkDTADb.Cannot insert duplicate key row in object 'dta_MessageFieldValues' with unique index 'IX_MessageFieldValues'. The statement has been terminated..

Upvotes: 0

Views: 583

Answers (1)

Dijkgraaf
Dijkgraaf

Reputation: 11527

I see you got a partial answer in your MSDN Post

go to BizTalk Admin Console ,check in Platform Settings -> Hosts, in the list of hosts on the right, confirm that only a single Host has the Tracking column marked as Yes.

As to your other question. Yes you can run a Single Host Instance on a Single Server. Although when your server starts to come under a bit of load you may want to consider setting up some more so you can balance the workload better.

Upvotes: 0

Related Questions