[BTS], error handling?

What's wrong with this?

Event Type: Warning
Event Source: BizTalk Server 2006
Event Type: BizTalk Server 2006
Event ID: 5740
Date:
Event: 13:46:51
User: N/
COMPUTER: EIAC-TEMP5
Description:
The adapter "SQL" returns an error message. The detailed information is "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> ".

Event Type: Error
Event Source: XLANG/s
Event Type: None
Event ID: 10034
Date:
Event: 13:46:52
User: N/
COMPUTER: EIAC-TEMP5
Description:
An uncaptured exception (see internal exceptions below) has suspended an instance of the Service EIAC. OA. icationicationsystem. Orchestrations. Main (a44769cf-20b3-668b-e434-e1b03b6f84c2.
It remains suspended until it is managed to recover or terminate the service instance.
If the service instance is restored, it will continue from the last continuous state, which may cause the same exception again.
Instance ID: d9c408b3-57ab-48dd-937c-80dd864c1580
Shape Name:
Shape ID:
Exception location: Segment-1, process-1
Internal exception: An error occurred while processing the message. For more information, see the details section.
Message ID: {2F367584-1D89-4551-A76A-1223E5BB2F4E}
Instance ID: {FA895E7E-1DBA-4293-A0F5-E6DFD753BB3A}
Error Description: 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>

 

Exception type: XlangSoapException
Source: Microsoft. XLANGs. BizTalk. Engine
Target Site: Void VerifyTransport (Microsoft. XLANGs. Core. Envelope, Int32, Microsoft. XLANGs. Core. Context)
The following is a stack trace used to identify the location where an exception occurred.

In Microsoft. BizTalk. XLANGs. BTXEngine. BTXPortBase. VerifyTransport (Envelope env, Int32 operationId, Context ctx)
In Microsoft. XLANGs. Core. submodules. Receive (Segment s, Context ctx, Envelope & env, Boolean topOnly)
In Microsoft. XLANGs. Core. PortBase. GetMessageId (subscribe, Segment currentSegment, Context cxt, Envelope & env, CachedObject location)
In EIAC. OA. icationicationsystem. Orchestrations. Main. segment17 (StopConditions stopOn)
In Microsoft. XLANGs. Core. segmentschedment. RunASegment (Segment s, StopConditions stopCond, Exception & exp)

These several times found that errors such as 5470,547, 10034, and often occur at the same time. 10034 does not need to worry about it.

5470 again, it is reported that there is a problem with sqladapter, is it so fragile?

Test phenomenon. The main problem is that when the updategram update operation is executed concurrently in the process, the above error is reported. Note: It is concurrent execution. When the number of concurrent threads is greater than 3, an error occurs. Why?

In short, I still can't explain it, but compared with previous projects, I found that the main difference is that the ID field of the defined data table is not set to PK. The problem is solved by changing it!

After suffering me for one afternoon, the problem was a PK.