SAP Knowledge Base Article - Preview

2134323 - Nesting error in SQLRUN_ISU_TRIGGERS: maximum depth 8

Symptom

During SAP system upgrades using the near Zero Downtime Option (nZDM), and error might take place during phase SQLRUN_ISU_TRIGGERS with HANA databases, similar to the following 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
RUNSQL TASKS ERRORS and RETURN CODE in SQLRUN_ISU-TRIGGERS_01.ABC
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3 ETQ398XSQL:  "/1CRR/LT00001488" VALUES ( "SEQ_/1CRR/LT00001488".NEXTVAL,
3 ETQ398XSQL:  TO_VARCHAR(CURRENT_TIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF4'),  ' ',
3 ETQ398XSQL:  :newrow."MANDT",  :newrow."MSEHI", 'I'); END;
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20130923051243
1EETQ008 Error message: DBSL error 99 (db code 517):
nesting depth of trigger and procedure is exceeded: maximum nesting depth 8, procedure _SYS_BIC.sap.erp.sappl.lo.md.bom/MAT_DETERMINE_HEADER(8) <- (7) <- procedure E_ECN_EFFECTIVITY(6) <- procedure _SYS_BIC.sap.erp.sappl.lo.md.bom/MAT_BOM_EXPLODE_KEY(5) <- procedure _SYS_BIC.sap.erp.sappl.lo.md.bom/MAT_EXPLODE_WITH_MRP_ATTRIBUTES(4) <- procedure _SYS_BIC.sap.erp.sappl.pph.v02.mrp.iOM_EXPLODE_KEY(5) <- procedure _SYS_BIC.sap.erp.sappl.lo.md.bom/MAT_EXPLODE_WITH_MRP_ATTRIBUTES(4) <- procedure _SYS_BIC.sap.erp.sappl.pph.v02.mrp.inh_prod/BOM_EXPLOSION(3) <- procedure _SYS_BIC.sap.erp.sappl.pph.v02.mrp _SYS_BIC.sap.erp.sappl.lo.md.bom/MAT_SINGLE_LEVEL_EXPLOD
1EETQ003 exit code: "12" 

 

 

 

As seen on the Software Update Manager tool:

SQLRUN_ISU_1.JPG 

 

 

Note that the error details may vary.

 

The ABAP work process trace file contain entries similar to the following:

M Tue Feb 10 10:04:56 2015
M *** ERROR => ThISetCommAttr: bad conv id 70348340, cannot add attr 0x2
[thxxcpic.c 7542]
M
{root-id=3CD92B048CA61EE4ACA07A3D6837F859}_{conn-id=00000000000000000000000000000000}_0
A
A Tue Feb 10 10:07:40 2015
A TH VERBOSE LEVEL FULL
A ** RABAX: end RX_GET_MESSAGE
A TH VERBOSE LEVEL FULL
A ** RABAX: end RX_GET_MESSAGE
A
A Tue Feb 10 10:17:39 2015
A bgRFC> [W] cl_bgrfc_supervisor=>schedule_tasks called
B
B Tue Feb 10 10:19:39 2015
B dbsync[db_syexe]: wait=0, call_no=431, current_ts=20150210101938, last_counter=197922193
C
C Tue Feb 10 10:25:25 2015
C *** ERROR => execute(), rc=1, rcSQL=324 [dbsdbsql.cpp 1055]
C
{root-id=0050569437041ED4A9DC25C53D931416}_{conn-id=54D950A13C78192CE10000000A116C1C}_12C *** ERROR => EXECUTE on connection 1, rc=324
[dbslsdb.cpp 3691]
C SQLCODE : 324
C SQLERRTEXT : cannot use duplicate sequence name:
SEQ_/1CADMC/00000338:
line 1 col 17 (at pos 16)
C SQL COMMAND: CREATE SEQUENCE "SEQ_/1CADMC/00000338" RESET BY SELECT IFNULL(MAX(IUUC_SEQUENCE),0)+1 FROM "/1CADMC/\
C 00000338" ;
B ***LOG BY2=> sql error 324 performing EXE [dbds 670]
B ***LOG BY0=> cannot use duplicate sequence name:
SEQ_/1CADMC/00000338:
line 1 col 17 (at pos 16) [dbds 670]
C *** ERROR => execute(), rc=1, rcSQL=517
[dbsdbsql.cpp 1055]
C *** ERROR => EXECUTE on connection 1, rc=517
[dbslsdb.cpp 3691]
C SQLCODE : 517
C SQLERRTEXT : nesting depth of trigger and procedure is exceeded:
maximum nesting depth 8, procedure _SYS_BIC.sap.\C erp.sappl.lo.md.bom/MAT_DETERMINE_HEADER(8) <- (7) <- procedure _SYS_BIC.sap.erp.sappl.lo.md.bom/MAT\C _SINGLE_LEVEL_EXPLODE(6) <- procedure_SYS_BIC.sap.erp.sappl.lo.md.bom/MAT_BOM_EXPLODE_KEY(5) <- procedure_SYS_BIC.sap.erp.sappl.lo.md.bom/MAT_EXPLODE_WITH_MRP_ATTRIBUTES(4) <- procedure _SYS_BIC.sap\C .erp.sappl.pph.v02.mrp.inh_prod/BOM_EXPLOSION(3) <-procedure _SYS_BIC.sap.erp.sappl.pph.v02.mrp.inh\C _prod/INHOUSE_HANDLE(2) <- procedure
_SYS_BIC.sap.erp.sappl.pph.v02.mrp.run/CALC_CHANGES(1) <- procedure_SYS_BIC.sap.erp.sappl.pph.v02.mrp.run/MAT_PLANT_MRP_PREPARE, nested execution depth limit exce\ C eded, cannot create trigger C SQL COMMAND: CREATE TRIGGER "/1LT/00000338INS" AFTER INSERT ON
"MARA" REFERENCING NEW ROW NEW FOR EACH ROW\ C BEGIN INSERT INTO "/1CADMC/00000338" VALUES ( "SEQ_/1CADMC/00000338".NEXTVAL, \ C TO_CHAR(CURRENT_UTCTIMESTAMP,'yyyymmddhh24missFF7'),'0', :NEW."MANDT" , :NEW."MATN\ C R", 'I'); END; ;
B ***LOG BY2=> sql error 517 performing EXE [dbds 670]
B ***LOG BY0=> nesting depth of trigger and procedure is exceeded:
maximum nesting depth 8, procedure _SYS_BIC.sap.erp.sappl.lo.md. 

*Note the information nesting depth of trigger and procedure is exceeded and maximum nesting depth 8

 

 

You're not able to proceed.

This error happens only on HANA databases.


Read more...

Environment

  • SAP Netweaver release independent
  • SAP HANA database 1.0

Product

SAP HANA, platform edition all versions

Keywords

MAIN_SHDRUN, SUBMOD_FDC_RUN, SQLRUNTASK_ISU_TRIGGERS_FDC, parallel, execution, SAPup, update, support package, indexserver.ini, internally, SQL, nested_trigger_limit  , KBA , HAN-DB , SAP HANA Database , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem

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.