Import Errors while doing system copy

[Former Member]

All

We are doing a Export and Impprt in our System Landscape. The export went on well, but we have issues while importing to the Target system. ABAP Import Jobs 2 failed and when I checked the logs of the packages, I have got the following error.

ORADPL:2010.07.23 08:11:49 (ret=-1) ORA-39776: fatal Direct Path API error loading table "SAPSR3"."EUDB"

ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [], []

ORADPL:2010.07.23 08:11:49 fatal error in line 3152, (status=39776) error loading stream

(IMP) ERROR: ExeFastload: rc = 2

DbSl Trace: Error 24795 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-24795 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(DROP INDEX "EUDB~0")

DbSlExecute: rc = 99

(SQL error 24795)

error message returned by DbSl:

ORA-24795: Illegal COMMIT attempt made

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 24795 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-24795 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "EUDB~0" ON "EUDB" ( "RELID", "NAME", "SPRSL", "SRTF2" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 1053696 NEXT 0000000640K MINEXTENTS 000

0000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 24795)

error message returned by DbSl:

ORA-24795: Illegal COMMIT attempt made

DbSl Trace: Error 24795 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-24795 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(DROP TABLE "EUGUITEXT")

DbSlExecute: rc = 99

(SQL error 24795)

error message returned by DbSl:

ORA-24795: Illegal COMMIT attempt made

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 24795 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-24795 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(CREATE TABLE "EUGUITEXT" ( "PROGNAME" VARCHAR2(120) DEFAULT ' ' NOT NULL , "SPRSL" VARCHAR2(3) DEFAULT ' ' NOT NULL , "TYPE" VARCHAR2(3) DEFAULT ' ' NOT NU

LL , "CODE" VARCHAR2(60) DEFAULT ' ' NOT NULL , "DOKU_TEXT" VARCHAR2(180) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 106496 NEXT 00000006

40K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 24795)

error message returned by DbSl:

ORA-24795: Illegal COMMIT attempt made

DbSl Trace: Error 24795 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-24795 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(TRUNCATE TABLE "EUGUITEXT")

DbSlExecute: rc = 99

(SQL error 24795)

error message returned by DbSl:

ORA-24795: Illegal COMMIT attempt made

DbSl Trace: Error 24795 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-24795 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(DROP INDEX "EUGUITEXT~0")

DbSlExecute: rc = 99

(SQL error 24795)

error message returned by DbSl:

ORA-24795: Illegal COMMIT attempt made

Do u think we need to have install any patches to resolve the issue. Please advise.

Please Advise.

[Former Member]

Hi,

As per your query you have to keep same version of all the patches,version,kernal etc. then you can use import. In case you find error pls mentioned here complete detail your both the systems (import & Export) along with patches version,kernal etc.

Anil

[Former Member]

Suggest you to close this thread here and re-open a new thread under SAP on Oracle forum for quick solution/inputs.

Regards,

Nick Loy