Errors when executing MD01N(MRP live)

1.

Runtime Error    DBPROC_SQL_ERROR

Exception          CX_SY_DB_PROCEDURE_SQL_ERROR

Error Analysis

Error 2048 has occurred while executing database procedure “”_SYS_BIC”.”sap.erp.sappl.pph.v01.mrp.run/MAT_PLANT_MRP”” on the current database connection “R/3”. Database error text: column store error: search table error:  [2620] _SYS_BIC.sap.erp.sappl.pph.v01.mrp.run/MAT_PLANT_MRP: line 48 col 3 (at pos  2038): InternalFatal exception: _SYS_BIC.sap.erp.sappl.pph.v01.mrp.run/MAT_PLANT_MRP_PREPARE: line 19 col 3  (at pos 1961): Internal Triggering statement: “dsql_open_proc”

Solution:

To execute MRP Live on HANA, active ScriptServer is required. KBA 1994190 (Shot dump DBPROC_SQL_ERROR occurs when executing transaction code MD01N) explains this. Note 1650957 describes how to activate ScriptServer from HANA database perspective.

2.

“No planning file entry  exists for this selection” is displayed on the left bottom of MD01N initial screen.

Solution:

The planning file entries in table DBVM is required. You should execute transaction code OM0F to convert planning file entry from table MDVM into DBVM. KBA 1976004 explains this.

3.

MRP run terminated due to error: Fatal exception occured: Number range not maintain

Solution:

You must create a new number range named “PP” for objects BANF, PLAF and RESB. KBA 1993505 explains how to create number range “PP”.

4.

Runtime error    ITAB_DUPLICATE_KEY Program ABAP  CL_PPH_MRP_DISPATCHER=========CP

Solution:

Apply this note to fix the program error.

Note 1919016 – MD01N: Runtime error ITAB_DUPLICATE_KEY