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.