[BTS] 5740,574 3 how to handle errors?

Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5740
Date: 2/28/2008
Time: 6:33:04
User: N/
Computer: LABS
Description:
The adapter "SQL" raised an error message. Details "HRESULT =" 0x80040e14 "Description =" SQLOLEDB Error Description: Ambiguous update, unique identifier required Transaction aborted"
<Root xmlns: ns00 = "urn: schemas-microsoft-com: xml-updategram"> <? MSSQLError HResult = "0x80040e14" Source = "Microsoft ole db Provider for SQL Server" Description = "SQLOLEDB Error Description: Ambiguous update, unique identifier required Transaction aborted"?> </Root> ".

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: BizTalk Server 2006
Event ID: 5743
Date: 2/28/2008
Time: 6:33:04
User: N/
Computer: LABS
Description:
The adapter failed to transmit message going to send port "UpdateSMGPLog" with URL "SQL: // labs/icationicationsystem /". it will be retransmitted after the retry interval specified for this Send Port. details: "HRESULT =" 0x80040e14 "Description =" SQLOLEDB Error Description: Ambiguous update, unique identifier required Transaction aborted"
<Root xmlns: ns00 = "urn: schemas-microsoft-com: xml-updategram"> <? MSSQLError HResult = "0x80040e14" Source = "Microsoft ole db Provider for SQL Server" Description = "SQLOLEDB Error Description: Ambiguous update, unique identifier required Transaction aborted"?> </Root> ".

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

By transferring the Xml of several key messages in the process, we can find that the Update Message is incomplete.

<Ns0: UpdateOCSLogRequest xmlns: ns0 = "http://EIAC.OA.NotificationSystem.UpdateOCSLog">
<Ns0: sync>
<Ns0: before> <ns0: OCSMessageLog> </ns0: OCSMessageLog> </ns0: before>
<Ns0: after> <ns0: OCSMessageLog StateID = "1"> </ns0: OCSMessageLog> </ns0: after>
</Ns0: sync>
</Ns0: UpdateOCSLogRequest>

Without the Before condition, this is equivalent to your SQL statement!
Update table set StateID = 1 where <???> People don't know who to update!

Find the cause of the error and sort out the corresponding process code. Are you sure you want to test again, this before already has data.

 

The problem has been solved again!

Xizang workers