SAP Knowledge Base Article - Preview

3004306 - Violation of PRIMARY KEY constraint PK__BC_IV_DC

Symptom

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...

Environment

  • 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

Product

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

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.