SAP Knowledge Base Article - Preview

2461706 - SQL0901 in phase MAIN_SHDCRE/EU_IMPORT2

Symptom

During a SUM upgrade, you receive an SQL0901 in phase MAIN_SHDCRE/EU_IMPORT2 in the log EX<num>.LOG

ERROR: DDL statement failed   (CREATE TRIGGER "&TMP_DEMO_GTT_I" INSTEAD OF INSERT ON "DEMO_GTT" 
REFERENCING NEW AS NEW FOR EACH ROW MODE DB2ROW BEGIN INSERT INTO "&TMP_DEMO_GTT" ("DB4_CONNID","ID", "COL") VALUES (QSYS2.JOB_NAME, NEW."ID", NEW."COL"); END)  
DbSlExecute: rc = 99 (DB4) ERROR: SQL error -901    Error message returned by DbSl: (DB) ERROR: SQL0901 - Error del sistema SQL. (587712/SAPADM/SUMSTART) 
(IMP) ERROR: (IMP) INFO: Starting create for object "DEMO_SFLIGHT_AGG" of type "global temporary table" #20170419165304 (DB4) INFO: DEMO_SFLIGHT_AGG dropped #20170419165304 (DB4)
ERROR: DDL statement failed   (CREATE TRIGGER "&TMP_DEMO_SFLIGHT_AGG_I" INSTEAD OF INSERT ON "DEMO_SFLIGHT_AGG" REFERENCING NEW AS NEW FOR EACH ROW MODE DB2ROW 
BEGIN INSERT INTO "&TMP_DEMO_SFLIGHT_AGG" ("DB4_CONNID","MANDT", "CARRID", "CONNID", "FLDATE", "SEATSOCC") VALUES (QSYS2.JOB_NAME, NEW."MANDT", NEW."CARRID", NEW."CONNID", NEW."FLDATE", NEW."SEATSOCC"); END)  
DbSlExecute: rc = 99 (DB4) ERROR: SQL error -901    Error message returned by DbSl:


Read more...

Environment

SAP on IBM i

Keywords

SAP on IBM i, iSeries, , KBA , BC-INS-AS4 , Installation and Upgrade AS/400 , BC-DB-DB4 , DB2 for AS/400 , 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.