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 for Me (Login required).

Search for additional results

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