Error in System copy import abap phase

[Former Member]

Hi,

We are getting error in Import abap phase.  114 jobs completed, 2 jobs failed.

SAPSDIC.log:

(SQL) INFO: K:\PRD_Exp\ABAP\DB/ORA/SDIC.SQL opened
(DB) ERROR: DDL statement failed
(DROP TABLE "DDSTORAGE")
DbSlExecute: rc = 103
  (SQL error 942)
  error message returned by DbSl:
ORA-00942: table or view does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 900 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-00900 occurred at SQL stmt (parse error offset=6)

(DB) ERROR: DDL statement failed
(      DEFAULT ' ' NOT NULL,         DEFAULT ' ' NOT NULL,         DEFAULT ' ' NOT NULL,        "USEFLAG" VARCHAR2 (000001)         DEFAULT ' ' NOT NULL,        "POSNR" NUMBER (000005, 000000)         DEFAULT 0 NOT NULL,        "SIGN" VARCHAR2 (000001)         DEFAULT ' ' NOT NULL,        "PARNAME" VARCHAR2 (000030)         DEFAULT ' ' NOT NULL,        "TEXT" VARCHAR2 (000079)         DEFAULT ' ' NOT NULL)       PCTFREE 10       PCTUSED 00       INITRANS 001       TABLESPACE PSAPSR3    NOCOMPRESS    STORAGE (INITIAL     0000000224 K                NEXT        0000001024 K                MINEXTENTS  0000000001                MAXEXTENTS  UNLIMITED                PCTINCREASE 0000                FREELISTS   001                FREELIST GROUPS 01) )
DbSlExecute: rc = 99
  (SQL error 900)
  error message returned by DbSl:
ORA-00900: invalid SQL statement
(DB) INFO: disconnected from DB

K:\usr\sap\QAS\SYS\exe\nuc\NTAMD64\R3load.exe: job finished with 1 error(s)
K:\usr\sap\QAS\SYS\exe\nuc\NTAMD64\R3load.exe: END OF LOG: 20130125041429

Ours's is ECC 6.0 sp24, Win 2k3, ora 11.2

Regards

[former_member188883]

Hi Praveen,

Solution 1:  Please apply SAP note 1309055 and rerun report SMIGR_CREATE_DDL. This should solve the problem. In this case you may need to re-run the entire installation to have clean system.

Solution 2: For DDSTORAGE, the sql statements can be deleted directly from the file  K:\PRD_Exp\ABAP\DB/ORA/SDIC.SQL. This menthod also works.

Regards,

Deepak Kori

[Former Member]

Hi,

Note valid for Oracle database ? getting message in SE80 -Function Group LSMIGR_DB6F01 does not exist.

Our's is SAPKB70024, correction already delivered in SAPKB70020

Regards

[former_member188883]

Hi Praveen,

You may then go ahead with solution 2 and proceed with installaiton.

Regards,

Deepak Kori

[Former Member]

Hi,

Is Note 1583782 applicable ? Shall We again apply to system and again run smigr* report

Regards

[former_member188883]

Hi Praveen,

YES. SAP note 1583782 is applicable to your system. You shall need to run SMIGR_CREATE_DDL again. Take a fresh export dump and restart system copy process from scratch.

Regards,

Deepak Kori