Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ABAP Import error "DDL statement failed" and "ORA-00955"

Hi experts.

In DB Instance Installation with R3load, I'm facing some import errors.
ABAP import stop due to them.

I faced similar errors in this import, before this error related  to SAPAPPL0.

For example the error of SAPSDIC. (with same error massages .)

However, after I tried "Retry" they're solved.

According to ".TSK file", after I click "Retry" button in the sapinst  window, the ABAP import is restarted  and proceed a little.
However, in this time, the import stop soon after that.

Could someone help me to solve is problem, plsease?

Below are error messages
==================================
<sapinst window  message>
An error occured while processing option SAP NetWeaver 7.0 Support Release 3 ・・・
Program Migration Monitor exits with error code 103.For more details see log file(s) import_monitor.java.log, import_monitor.log
 
<import_monitor.java.log>
Loading of 'SAPAPPL0' import package:ERROR
Import Monitor jobs:running 0, waiting 1, completed 26, failed1, total 28,

<import_monitor.log>
WARNING:YYYY-MM-DD hh:mm:ss
Cannot start import of packages with views because not all import packages with tables are loaded successfully.

WARNING:YYYY-MM-DD hh:mm:ss
1 error(s) during proccessing of packages.

INFO:YYYY-MM-DD hh:mm:ss
Import Monitor is stopped.
===================================

I also checked SAPAPPL0.log.

<SAPAPPL0.log>
DbSl Trace: ORA-1403 when accessing table SAPUSER
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(GSI) INFO: dbname   = "dbname(dummy)"                                                                                    "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "server hostname(dummy)"
(GSI) INFO: sysname  = "Linux"
(GSI) INFO: nodename = "nodename(dummy)"
(GSI) INFO: release  = "2.6.32-400.21.1.el5uek"
(GSI) INFO: version  = "#1 SMP Wed Feb 20 01:35:01 PST 2013"
(GSI) INFO: machine  = "x86_64"
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file /export_dir/ABAP/DB/SQLFiles.LST
(SQL) INFO: /export_dir/ABAP/DB/SQLFiles.LST not found
(SQL) INFO: Searching for SQL file APPL0.SQL
(SQL) INFO: APPL0.SQL not found
(SQL) INFO: Searching for SQL file /export_dir/ABAP/DB/ORA/APPL0.SQL
(SQL) INFO: /export_dir/ABAP/DB/ORA/APPL0.SQL not found
(DB) INFO: /1CN/STXSAPX0104 dropped #YYYYMMDDhhmmss
(DB) INFO: /1CN/STXSAPX0104 created #YYYYMMDDhhmmss
(IMP) INFO: import of /1CN/STXSAPX0104 completed (0 rows) #YYYYMMDDhhmmss
(DB) INFO: /1CN/STXSAPX0104~0 created #YYYYMMDDhhmmss
(DB) ERROR: DDL statement failed
(CREATE TABLE "/1CN/STXSAPX0105" ( "CLIENT" VARCHAR2(9) DEFAULT '000' NOT NULL , "VARNUMH" RAW(16) NOT NULL , "STFKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL , "KZBZG" VARCHAR2(9) DEFAULT ' ' NOT NULL , "KUMZA" NUMBER(10) DEFAULT 0 NOT NULL , "KUMNE" NUMBER(10) DEFAULT 0 NOT NULL , "EXPNT" NUMBER(5) DEFAULT 0 NOT NULL , "MWSK1" VARCHAR2(6) DEFAULT ' ' NOT NULL , "MWSK2" VARCHAR2(6) DEFAULT ' ' NOT NULL , "KONMS" VARCHAR2(9) DEFAULT ' ' NOT NULL , "KONWS" VARCHAR2(15) DEFAULT ' ' NOT NULL , "KSTBM" NUMBER(18,5) DEFAULT 0 NOT NULL , "MEINS" VARCHAR2(9) DEFAULT ' ' NOT NULL , "KZNEP" VARCHAR2(3) DEFAULT ' ' NOT NULL , "MXWRT" NUMBER(15,2) DEFAULT 0 NOT NULL , "GKWRT" NUMBER(15,2) DEFAULT 0 NOT NULL , "PTERM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "VALDT" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "VALTG" VARCHAR2(6) DEFAULT '00' NOT NULL  ) TABLESPACE PSAPSR3  STORAGE (INITIAL 0000000016K NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
  (SQL error 955)
  error message returned by DbSl:
ORA-00955: name is already used by an existing object
(DB) INFO: disconnected from DB
==================================================

Former Member
Not what you were looking for? View more on this topic or Ask a question