Error during import CU&UC

[Former Member]

Hello

We have migrated 46C to ECC 6.0 EHP4 Stack 8 and an unicode conversion CU&UC.

We are now making the import and in this moment we have two errors. I attach you the relevant part of the logs files:

BSIS__DT.log:

.....

.....

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "BSIS~0" ON "BSIS" ( "MANDT", "BUKRS", "HKONT", "AUGDT", "AUGBL", "ZUONR", "GJAHR", "BELNR", "BUZEI" ) TABLESP

ACE PSAPSR3 STORAGE (INITIAL 1782579200 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPU

TE STATISTICS PARALLEL 4 )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P000

ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

(DB) INFO: disconnected from DB

/usr/sap/MG2/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/MG2/SYS/exe/run/R3load: END OF LOG: 20110403145421

/usr/sap/MG2/SYS/exe/run/R3load: START OF LOG: 20110403203029

....

....

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DB) ERROR: DDL statement failed

(DROP INDEX "BSIS~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

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

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "BSIS~0" ON "BSIS" ( "MANDT", "BUKRS", "HKONT", "AUGDT", "AUGBL", "ZUONR", "GJAHR", "BELNR", "BUZEI" ) TABLESP

ACE PSAPSR3 STORAGE (INITIAL 1782579200 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPU

TE STATISTICS PARALLEL 4 )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P000

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

(DB) INFO: disconnected from DB

/usr/sap/MG2/SYS/exe/run/R3load: job finished with 1 error(s)

As you can see in the log file, we had problems with the PSAPTEMP tablespace and the first time the import canceled.

The other error we had:

SAPAPPL0_6.log:

(DB) ERROR: DDL statement failed

(DROP TABLE "EIPA")

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 1658 in exec_immediate() from oci_execute_stmt(), orpc=0

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "EIPA" ( "MANDT" VARCHAR2(9) DEFAULT '000' NOT NULL , "INFNR" VARCHAR2(30) DEFAULT ' ' NOT NULL , "EBELN" VARCHAR2(30

) DEFAULT ' ' NOT NULL , "EBELP" VARCHAR2(15) DEFAULT '00000' NOT NULL , "ESOKZ" VARCHAR2(3) DEFAULT ' ' NOT NULL , "WERKS" VARCHAR2

(12) DEFAULT ' ' NOT NULL , "EKORG" VARCHAR2(12) DEFAULT ' ' NOT NULL , "BEDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "PREIS" N

UMBER(11,2) DEFAULT 0 NOT NULL , "PEINH" NUMBER(5,0) DEFAULT 0 NOT NULL , "BPRME" VARCHAR2(9) DEFAULT ' ' NOT NULL , "BWAER" VARCHAR

2(15) DEFAULT ' ' NOT NULL , "LPREI" NUMBER(11,2) DEFAULT 0 NOT NULL , "LPEIN" NUMBER(5,0) DEFAULT 0 NOT NULL , "LMEIN" VARCHAR2(9)

DEFAULT ' ' NOT NULL , "LWAER" VARCHAR2(15) DEFAULT ' ' NOT NULL , "MENGE" NUMBER(13,3) DEFAULT 0 NOT NULL ) TABLESPACE PSAPSR3 STO

RAGE (INITIAL 1161150464 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 1658)

error message returned by DbSl:

ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3

(DB) INFO: disconnected from DB

/usr/sap/MG2/SYS/exe/run/R3load: job finished with 1 error(s)

....

....

/usr/sap/MG2/SYS/exe/run/R3load: START OF LOG: 20110403225246

/usr/sap/MG2/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/701_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP

/usr/sap/MG2/SYS/exe/run/R3load: version R7.01/V1.4 [UNICODE]

Compiled Feb 24 2009 23:31:28

/usr/sap/MG2/SYS/exe/run/R3load -i SAPAPPL0_6.cmd -dbcodepage 4102 -l SAPAPPL0_6.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "MG220110403120400

"

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "sap1bdmig "

(GSI) INFO: sysname = "SunOS"

(GSI) INFO: nodename = "sap1bdmig"

(GSI) INFO: release = "5.10"

(GSI) INFO: version = "Generic_144488-02"

(GSI) INFO: machine = "sun4u"

(DB) INFO: EIPA deleted/truncated #20110403225248

(BUF) ERROR: CsDecompr rc = -11

(DB) INFO: disconnected from DB

/usr/sap/MG2/SYS/exe/run/R3load: job finished with 1 error(s)

Thanks and best regards,

Ana

[nils_buerckel]

Hi,

I assume before posting this you already checked whether PSAPTEMP is large enough ... ?

Best regards,

Nils Buerckel

SAP AG

[markus_doehr2]

> ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

increase PSAPTEMP

> ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

See Note 11369 - ORA-1452 during import after export from other system

> ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPSR3

PSAPSR3 is too small, add a datafile (or more).

I also suggest you use R3load parameters to increase the import speed:

-loadprocedure fast -merge_bck

Markus