SAP Knowledge Base Article - Preview

2402304 - Cannot insert duplicate key in object 'SAPLISDB.BC_XMLA_ASESSIONS'

Symptom

Using archive set bpm_proc to schedule multiple archive sessions to be executed in the future, archive session cannot be created because of  error shown in following image when "Path Extension" value has been used in previous created archive session.

error_screenshot.png

If check default trace, following error can be seen.
Inserting the Archiving Session data failed
[EXCEPTION]
com.sap.sql.exception.OpenSQLIntegrityConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__BC_XMLA___7D28D23BD55E70F0'. Cannot insert duplicate key in object 'SAPLISDB.BC_XMLA_ASESSIONS'. The duplicate key value is (/lis/bpm_proc/2016-12-09/01).
OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION]
......
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__BC_XMLA___7D28D23BD55E70F0'. Cannot insert duplicate key in object 'SAPLISDB.BC_XMLA_ASESSIONS'. The duplicate key value is (/lis/bpm_proc/2016-12-09/01).
......
Setting an archiving session to state "SCW" failed
[EXCEPTION]
com.sap.sql.exception.OpenSQLIntegrityConstraintViolationException: Violation of PRIMARY KEY constraint 'PK__BC_XMLA___7D28D23BD55E70F0'. Cannot insert duplicate key in object 'SAPLISDB.BC_XMLA_ASESSIONS'. The duplicate key value is (/lis/bpm_proc/2016-12-09/01).
OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION]
.......
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__BC_XMLA___7D28D23BD55E70F0'. Cannot insert duplicate key in object 'SAPLISDB.BC_XMLA_ASESSIONS'. The duplicate key value is (/lis/bpm_proc/2016-12-09/01).
.......
Scheduling of an archiving session failed
[EXCEPTION]
com.sap.archtech.archconn.exceptions.SessionHandlingException: Problem persisting session info: Violation of PRIMARY KEY constraint 'PK__BC_XMLA___7D28D23BD55E70F0'. Cannot insert duplicate key in object 'SAPLISDB.BC_XMLA_ASESSIONS'. The duplicate key value is (/lis/bpm_proc/2016-12-09/01).
OpenSQLExceptionCategories: [NON_TRANSIENT, INTEGRITY_CONSTRAINT_VIOLATION]
......


Read more...

Environment

SAP NetWeaver 7.2
SAP NetWeaver 7.3
SAP enhancement package 1 for SAP NetWeaver 7.3
SAP NetWeaver 7.4
SAP NetWeaver 7.5

Product

SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

bpm archive, java archiving cockpit, java scheduler, start write session, archiving monitor , KBA , BC-BMT-BPM-DSK , Process Desk , BC-JAS-BTC , NetWeaver Scheduler (Java) , Problem

About this page

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

Search for additional results

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