SAP Knowledge Base Article - Preview

1572769 - Dump DBSQL_DUPLICATE_KEY_ERROR in SAPLM61U when running MRP

Symptom

During execution of transactions MD01, MDBT, MD02, MD03 or MD01N you receive the following dump:

Category               ABAP programming error
Runtime Errors         DBSQL_DUPLICATE_KEY_ERROR
Except.                CX_SY_OPEN_SQL_DB
ABAP Program           SAPLM61U
Application Component  PP-MRP-BD

In MRP performance log, you may receive the following message:

"MRP run terminated (help for analysis in note 2432291)
Open SQL array insert produces duplicate records in the data base".


Read more...

Environment

  • SAP ERP Logistics (PP)  
  • SAP R/3
  • SAP R/3 Enterprise
  • SAP ERP Central Component
  • SAP ERP
  • SAP Enhancement package for SAP ERP
  • SAP Enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4 HANA, on premise
  • SAP S/4HANA Cloud Private Edition Release Independent

Product

SAP ERP Central Component all versions ; SAP ERP all versions ; SAP R/3 Enterprise all versions ; SAP R/3 all versions ; SAP S/4HANA Cloud Private Edition all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

INSERT_MDSBI_IN_MDSB, DBSQL_DUPLICATE_KEY_ERROR, SAPSQL_ARRAY_INSERT_DUPREC, CX_SY_OPEN_SQL_DB, SAPLM61U, LM61UF1T, number range, intervals, RESB, EBAN, OMI2, RSNUM , KBA , PP-MRP-PR , Planning Execution , 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.