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.