2463049 - SQL0428N The SQL statement is only allowed as the first statement in a unit of work. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2463049 - SQL0428N The SQL statement is only allowed as the first statement in a unit of work.

Symptom

  • Error can occur during SUM/DMO upgrade in phase RUN_SMIGRCREATEDDL_740(RSUPG_SMIGR_CREATE_DDL.SID):
    A3EERS_UPG_TOOL 215 No DB Version provided!"MIGRDDL"
  • The following error is found in the developer work process trace file dev_w*:
  • SQL0428N  The SQL statement is only allowed as the first statement in a unit of work.  SQLSTATE=25001
    TRUNCATE TABLE "MIGRDDL" REUSE STORAGE RESTRICT WHEN DELETE TRIGGERS IMMEDIATE      LOCATION( SAPLSDB2 , 00000 ) -
     - SYSTEM( SID , SAPSID )
    ABAP location info 'SAPLSDB2', 00000
    C  *** ERROR in ExecuteDirect[dbdb6.c, 17199] (END)
    B  ***LOG BY2=> sql error -428       performing EXE        [dbds#1 @ 691] [dbds    0691 ]
    B  ***LOG BY0=> SQL0428N  The SQL statement is only allowed as the first statement in a unit of work.  SQLSTATE=25001 [dbds#1 @ 691]
    B  ***LOG BY2=> sql error -428       performing EXE        [dbacds#2 @ 893] [dbacds  0893 ]

Read more...

Environment

DB2 for LUW database releases:

  • V9.7

Product

SAP ERP 6.0

Keywords

upgrade, DMO, SUM, sluigui, BW_SMIGRCREDDL.ELG, RS_UPG_SMIGR_CREATE_DDL, migration, truncate, disp+work , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.