Symptom
During an upgrade running on MaxDB (or other like MS SQL Server) you receive an error in EU_IMPORT2 phase. Inside the EX0000<nn>.log file you find the following error:
(IMP) INFO: Starting create for object <xxx> of type "global temporary table"
* ERROR: DBSL (DB) ERROR: DDL statement failed
* ERROR: (CREATE TABLE "$TMP_<xxx>" ( "$ada_session_id" CHAR (6) BYTE not null default TRANSACTION,"PGMID" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "OBJ_TYPE" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "OBJ_NAME" VARCHAR2(40) UNICODE DEFAULT ' ' NOT NULL , "SYSTEM_GROUP" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL ) NO FIXED LENGTH COLUMN )
* ERROR: DbSlExecute: rc = 102
* ERROR: (SQL error -955)
* ERROR: Error message returned by DbSl:
* ERROR: : exec_ddl_stmt
(DB) ERROR: POS(15) Duplicate name:$TMP_<xxx>
Read more...
Environment
- Database: MaxDB, MS SQL Server
- SUM 1.0
Product
Keywords
GTT, MaxDB, MS SQL Server, SUM 1.0, $TMP_, EU_IMPORT2, $TMP_SATC_CI_GTT_OBJ , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-SDB-UPG , Upgrade , 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.
SAP Knowledge Base Article - Preview