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