2134323 - Nesting error in SQLRUN_ISU_TRIGGERS: maximum depth 8

During SAP system upgrade, using the near Zero Downtime Option (nZDM), an 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 in the Software Update Manager tool:

Please note that the error details may vary.

The ABAP work process trace file contains 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.

• SAP Netweaver release independent
• SAP HANA database 1.0

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