SAP Knowledge Base Article - Preview

2858413 - Dump "DBSQL_DUPLICATE_KEY_ERROR" while managing sort variants

Symptom

While managing and saving sort variants in shift planning (Transaction PP61) the below dump may occur:

Runtime Error:"DBSQL_DUPLICATE_KEY_ERROR"
Exception: "CX_SY_OPEN_SQL_DB"

ABAP program: "SAPLRHSPP_SORT"

Short description

Open SQL Array Insert leads to duplicate records in the database.


Read more...

Environment

  • Human Capital Management (HCM)
  • SAP R/3  
  • SAP R/3 Enterprise
  • SAP ERP Core Component  
  • SAP ERP  
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA

Product

SAP ERP 6.0 ; SAP enhancement package 1 for SAP ERP 6.0 ; SAP enhancement package 2 for SAP ERP 6.0 ; SAP enhancement package 3 for SAP ERP 6.0 ; SAP enhancement package 4 for SAP ERP 6.0 ; SAP enhancement package 5 for SAP ERP 6.0 ; SAP enhancement package 6 for SAP ERP 6.0 ; SAP enhancement package 6 for SAP ERP 6.0, version for SAP HANA ; SAP enhancement package 7 for SAP ERP 6.0 ; SAP enhancement package 8 for SAP ERP 6.0

Keywords

DBSQL_DUPLICATE_KEY_ERROR, CX_SY_OPEN_SQL_DB, SAPLRHSPP_SORT, sorting, P_PEPSVAR, PP61 , KBA , PT-SP , Shift Planning , PT-SP-PS , Public Sector , How To

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.