3521028 - AMDP_EXECUTION_FAILED Dump: Error while executing a database procedure CL_PPS4_MRP_CALC=>CALC_CHANGES an error occurred. SQL code of the database: 129

You encounter a ST22 dump during MRP live execution

Category: ABAP Programming Error
Runtime Errors: AMDP_EXECUTION_FAILED
Exception: CX_AMDP_EXECUTION_FAILED
ABAP Program: CL_PPS4_MRP_CALC==============CP
Application Component: PP-MRP
Date and Time: 00.00.0000, 00:00:00 (PST)

Short Text

Error occurred while executing a database procedure.

What Happened?

During the execution of the database procedure CL_PPS4_MRP_CALC=>CALC_CHANGES, an error occurred.

----------------------------------------------------------------------------------------------------

The corresponding dev_W* log shows detailed information about this:

A  TH VERBOSE LEVEL FULL
A  ** RABAX: level LEV_RX_STANDARD entered.
A  ** RABAX: level LEV_RX_STANDARD completed.
A  ** RABAX: level LEV_RX_STDERR entered.
A
A  ABAP Program CL_PPS4_MRP_CALC==============CP        .
A  Source CL_PPS4_MRP_CALC==============CM004      Line 1134.
A  Error Code AMDP_EXECUTION_FAILED.
A  Module  $Id: //bas/789_STACK/src/krn/abap/runt/abrabax.c#2 $ SAP.
A  Function ab_amdp_rabax Line 7476.
A  P1: CL_PPS4_MRP_CALC=>CALC_CHANGES
A  P2: transaction rolled back by an internal error: "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP##": line 16 col 3 (at pos 586): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP": line 66 col 7 (at pos 2524): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT
A  P3: 129
A  P4: CL_PPS4_MRP_RUN=>MAT_PLANT_MRP

Note the suggested problem hint is linked to top proc call "CL_PPS4_MRP_RUN=>MAT_PLANT_MRP#stb2#20240709121344", not the underlying proc call "CL_PPS4_MRP_CALC=>CALC_CHANGES" generates the error

• Upon checking of App code from proc CALC_CHANGES, confirm the error line "et_resb_new = select * from :lt_resb_new_inhouse" is from this underlying proc

----------------------------------------------------------------------------------------------------

Source Code Extract

    Line            Code

     1104                           m.dbskz,
     1105                           m.kzvbr as kzvbr_pegarea,
     1106                           l.plifz,
     1107                           l.reslo,
     1108                           l.srm_contract_id,
     1109                           l.srm_contract_itm,
     1110                           l.sgt_rcat,
     1111                           l.sgt_scat
     1112                       from :lt_newlot_sos_f as l
     1113                       inner join :lt_newlots_enriched as m on  m.the_index = l.the_index
     1114                       where l.delkz = 'UR'
     1115                         and ( m.matnr, m.werks ) not in (  select matnr, werks from :lt_messages_sos )
     1116                       ;
     1117                   --  call thread for stock transfer
     1118                       call "CL_PPS4_MRP_STOCKTRANSFER=>STTRANS_HANDLE"(
     1119                           iv_mandt         => :iv_mandt,
     1120                           iv_today         => :iv_today,
     1121                           iv_user          => :iv_user,
     1122                           iv_schema        => :iv_schema,
     1123                           iv_plng_mode     => :iv_plng_mode,
     1124                           it_ctrl_mrp      => :it_ctrl_mrp,
     1125                           it_period_tab    => :lt_period_tab,
     1126                           it_mdps_new      => :lt_sttrans_in,
     1127                           it_mdpso         => :lt_sttrans_mdpso_in,
     1128                           et_rkpf_new      => et_rkpf_new,
     1129                           et_resb_new      => lt_resb_sttrans_new,
     1130                           et_mdpso         => lt_mdpso_sttrans
     1131                       );
     1132
     1133                   --***********************************************************************************
    >>>>>                       et_resb_new = select * from :lt_resb_new_inhouse         -- inhouse
     1135                                     union all
     1136                                     select * from :lt_resb_new_subcon          -- subcon
     1137                                     union all
     1138                                     select * from :lt_resb_sttrans_new         -- stock transfer reserv
     1139                                     ;
     1140
     1141                   --  Collect output tables from individual threads where required
     1142                       et_mdpso =  select * from :lt_mdpso_ext_proc      -- eban
     1143                                   union all
     1144                                   select * from :lt_mdpso_inh           -- inhouse
     1145                                   union all
     1146                                   select * from :lt_mdpso_subcon        -- subcon
     1147                                   union all
     1148                                   select * from :lt_mdpso_sttrans       -- stock transfer reservation
     1149                                   ;
     1150
     1151                       et_plaf_upd = select * from :lt_mdps_plaf_reexpl_inh
     1152                                     union all
     1153                                     select * from :lt_mdps_plaf_reexpl_subcon

From the indexserver trace at the timeframe of dump is seen:

[19121]\{329387\}[94/1410776224] 2024-08-27 06:46:23.767161 e EmbeddedAPI      Connection.cc(01651) : exception  1: no.1000007  (ptime/query/esx/esx_util.h:43) TID: 19121
    Cannot convert value: ''pointer'' from type ESX::EsxColumn to type ESX::EsxInternalColumn<TrexTypes::DecFloatAttributeValue>
exception throw location:
   0: 0x00007f6da07a15d9 in ESX::executeJobs(ESX::RuntimeData&, unsigned int, unsigned int, unsigned int, TRexUtils::Parallel::Context&) [clone .constprop.0] [clone .cold]+0x45 at ptime/query/esx/esx_util.h:43 (libhdbesx.so)
   1: 0x00007f6da05abcdb in ESX::Plan::generateItab(ESX::RuntimeData&) const+0x477 at ptime/query/esx/esx_itab_materialize.cc:24 (libhdbesx.so)
   2: 0x00007f6da03692cf in ESX::Plan::getOutputItab(ESX::RuntimeData&) const+0x6b at ptime/query/esx/esx_plan.cc:202 (libhdbesx.so)
   3: 0x00007f6dcc7f1882 in ptime::Esx_search::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x150 at ptime/query/plan_executor/dml/qe_esx_search.cc:33 (libhdbrskernel.so)
   4: 0x00007f6dcc5e96a0 in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0x1c0 at ptime/query/plan_executor/dml/qe_table.cc:194 (libhdbrskernel.so)
   5: 0x00007f6dcc5d19cc in
......

HANA 2.0 Rev < SPS 07 Revision 079.00

CL_PPS4_MRP_CALC=>CALC_CHANGES, AMDP_EXECUTION_FAILED, Error while executing a database procedure, ESX,  incorrect type casting , KBA , HAN-DB , SAP HANA Database , Problem