3004306 - Violation of PRIMARY KEY constraint PK__BC_IV_DC

The following error is being recorded in the default trace files:

#Error#com.sap.iv.dc.remote.IntegrationVisibilityHandleBean#
#BC-BMT-IV-DC#sap.com/tc~iv~dc~pi~ear##sap.com/tc~iv~dc~pi~ear#com.sap.iv.dc.remote.IntegrationVisibilityHandleBean##0###0#MS Queue Worker [AS2_http://sap.com/xi/XI/AS2Send]#Plain##
SQL Error
[EXCEPTION]
com.sap.sql.exception.OpenBatchUpdateException: Violation of PRIMARY KEY constraint 'PK__BC_IV_DC__XXXXXXXXX'. Cannot insert duplicate key in object 'SAPXXXDB.BC_IV_DC_DH'. The duplicate key value is (XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXXXX, OUTBOUND, /EDI/ReceiverId, http://sap.com/xi/XI/EDISeparator/EDISeparator).
OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION]
at com.sap.iv.dc.remote.IntegrationVisibilityHandleBean.insertPayloadAttribute(IntegrationVisibilityHandleBean.java:134)
at sun.reflect.GeneratedMethodAccessor499.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[...]
at com.sap.aii.parameters.search.module.EDISearchParametersModule.insertDynamicHeadersToIVTable(EDISearchParametersModule.java:241)
at com.sap.aii.parameters.search.module.EDISearchParametersModule.process(EDISearchParametersModule.java:88)
at sun.reflect.GeneratedMethodAccessor498.invoke(Unknown Source)

When you check the message ID in question, it has been successfully processed.

It is not necessary to have Integration Visibility configured in the system, but the EDISearchParametersModule is being used at least in one scenario.

Read more...

• SAP enhancement package 1 for SAP NetWeaver Process Integration 7.1 >= SP08
• SAP NetWeaver 7.3 >= SP05
• SAP enhancement package 1 for SAP NetWeaver 7.3
• SAP NetWeaver 7.4
• SAP NetWeaver 7.5
• SAP Process Integration, business-to-business add-on

SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP NetWeaver Process Integration, business-to-business add-on 1.0 ; SAP NetWeaver Process Integration, secure connectivity add-on 1.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3

B2B Add-on, Process Integration 7.11, PI 7.11, Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.4, PI 7.4, PO 7.4, Process Orchestration 7.5, PI 7.5, PO 7.5, XI, AEX, B2B Add-on 1.0, EDI Adapter, EDISeparator Adapter, BC_IV_DC, IV, B2B Adapter, database, db, BC_IV_DC_DH , KBA , BC-XI-CON-B2B-MOD , EDI Modules - Plain Text, Archiving, etc. , BC-BMT-IV , Integration Visibility , Problem