SYSTEM_COPY : IMPORT_PHASE Error

[Former Member]

Dear All,

While doing SAP system copy Migration , Following Error Observed.

Loading of 'SAPCLUST_6' import package: ERROR

Import Monitor jobs: running 2, waiting 14, completed 102, failed 1, total 119.

Loading of 'SAPCLUST_2' import package: ERROR

Import Monitor jobs: running 1, waiting 14, completed 102, failed 2, total 119.

Loading of 'SAPCLUST_4' import package: ERROR

Import Monitor jobs: running 0, waiting 14, completed 102, failed 3, total 119.

Import Monitor jobs: running 1, waiting 13, completed 102, failed 3, total 119.

Import Monitor jobs: running 2, waiting 12, completed 102, failed 3, total 119.

Import Monitor jobs: running 3, waiting 11, completed 102, failed 3, total 119.

Loading of 'SAPSSEXC_4' import package: ERROR

Import Monitor jobs: running 2, waiting 11, completed 102, failed 4, total 119.

Loading of 'SAPSSEXC_10' import package: ERROR

Import Monitor jobs: running 1, waiting 11, completed 102, failed 5, total 119.

Loading of 'SAPSSEXC_6' import package: ERROR

Import Monitor jobs: running 0, waiting 11, completed 102, failed 6, total 119.

Import Monitor jobs: running 1, waiting 10, completed 102, failed 6, total 119.

Import Monitor jobs: running 2, waiting 9, completed 102, failed 6, total 119.

Import Monitor jobs: running 3, waiting 8, completed 102, failed 6, total 119.

Loading of 'SAPPOOL' import package: ERROR

Loading of 'SAPSSEXC_7' import package: ERROR

Import Monitor jobs: running 1, waiting 8, completed 102, failed 8, total 119.

Import Monitor jobs: running 1, waiting 8, completed 102, failed 8, total 119.

Loading of 'SAPSSEXC_5' import package: ERROR

Import Monitor jobs: running 0, waiting 8, completed 102, failed 9, total 119.

Import Monitor jobs: running 1, waiting 7, completed 102, failed 9, total 119.

Import Monitor jobs: running 2, waiting 6, completed 102, failed 9, total 119.

Import Monitor jobs: running 3, waiting 5, completed 102, failed 9, total 119.

Loading of 'SAPCLUST_5' import package: ERROR

Import Monitor jobs: running 2, waiting 5, completed 102, failed 10, total 119.

Loading of 'SAPSSEXC_3' import package: ERROR

Import Monitor jobs: running 1, waiting 5, completed 102, failed 11, total 119.

Loading of 'SAPCLUST_1' import package: ERROR

Import Monitor jobs: running 0, waiting 5, completed 102, failed 12, total 119.

Import Monitor jobs: running 1, waiting 4, completed 102, failed 12, total 119.

Import Monitor jobs: running 2, waiting 3, completed 102, failed 12, total 119.

Import Monitor jobs: running 3, waiting 2, completed 102, failed 12, total 119.

Loading of 'SAPCLUST_7' import package: ERROR

Import Monitor jobs: running 2, waiting 2, completed 102, failed 13, total 119.

Loading of 'SAPDFACT' import package: ERROR

Import Monitor jobs: running 1, waiting 2, completed 102, failed 14, total 119.

Loading of 'SAPCLUST_3' import package: ERROR

Import Monitor jobs: running 0, waiting 2, completed 102, failed 15, total 119.

Import Monitor jobs: running 1, waiting 1, completed 102, failed 15, total 119.

Loading of 'SAP0000' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 102, failed 16, total 119.

-

---

sap0000.log : After doing Autoextend ON following error also observed. :

bSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP TABLE "REPOLOAD")

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: ORA-1658 occurred when executing SQL statement (parse error offset=0)

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD" ( "PROGNAME" VARCHAR2(120) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "MACH" NUMBER(5) DEFAULT 0 NOT NULL , "UNAM" VARCHAR2(36) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(18) DEFAULT '000000' NOT NULL , "L_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "Q_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "SDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(18) DEFAULT '000000' NOT NULL , "MINOR_VERS" NUMBER(5) DEFAULT 0 NOT NULL , "MAJOR_VERS" NUMBER(10) DEFAULT 0 NOT NULL , "LDATA" BLOB , "QDATA" BLOB ) TABLESPACE PSAPSR3700 LOB ("LDATA", "QDATA") STORE AS (CACHE) STORAGE (INITIAL 909492224 NEXT 0000040960K 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 PSAPSR3700

(DB) INFO: disconnected from DB

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090918111232

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090918114525

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#20 $ SAP

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Aug 23 2009 23:42:38

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe

Please reply how to resolve the same.

Regards,

Santosh

[Former Member · Accepted solution]

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

Add space to tablespace PSAPSR3700 and retry

Pravin

[Former Member · Accepted solution]

Dear Pravin,

Thanks for reply , my second problem is solved to resize the datafile.

But my First problem still is there.

import_monitor.log

mport Monitor jobs: running 1, waiting 16, completed 102, failed 0, total 119.

Import Monitor jobs: running 2, waiting 15, completed 102, failed 0, total 119.

Import Monitor jobs: running 3, waiting 14, completed 102, failed 0, total 119.

Loading of 'SAPCLUST_6' import package: ERROR

Import Monitor jobs: running 2, waiting 14, completed 102, failed 1, total 119.

Loading of 'SAPCLUST_2' import package: ERROR

Import Monitor jobs: running 1, waiting 14, completed 102, failed 2, total 119.

Loading of 'SAPCLUST_4' import package: ERROR

Import Monitor jobs: running 0, waiting 14, completed 102, failed 3, total 119.

Import Monitor jobs: running 1, waiting 13, completed 102, failed 3, total 119.

Import Monitor jobs: running 2, waiting 12, completed 102, failed 3, total 119.

Import Monitor jobs: running 3, waiting 11, completed 102, failed 3, total 119.

Loading of 'SAPSSEXC_4' import package: ERROR

Import Monitor jobs: running 2, waiting 11, completed 102, failed 4, total 119.

Loading of 'SAPSSEXC_10' import package: ERROR

Import Monitor jobs: running 1, waiting 11, completed 102, failed 5, total 119.

Loading of 'SAPSSEXC_6' import package: ERROR

Import Monitor jobs: running 0, waiting 11, completed 102, failed 6, total 119.

Import Monitor jobs: running 1, waiting 10, completed 102, failed 6, total 119.

Import Monitor jobs: running 2, waiting 9, completed 102, failed 6, total 119.

Import Monitor jobs: running 3, waiting 8, completed 102, failed 6, total 119.

Loading of 'SAPPOOL' import package: ERROR

Loading of 'SAPSSEXC_7' import package: ERROR

Import Monitor jobs: running 1, waiting 8, completed 102, failed 8, total 119.

Import Monitor jobs: running 1, waiting 8, completed 102, failed 8, total 119.

Loading of 'SAPSSEXC_5' import package: ERROR

Import Monitor jobs: running 0, waiting 8, completed 102, failed 9, total 119.

Import Monitor jobs: running 1, waiting 7, completed 102, failed 9, total 119.

Import Monitor jobs: running 2, waiting 6, completed 102, failed 9, total 119.

Import Monitor jobs: running 3, waiting 5, completed 102, failed 9, total 119.

Loading of 'SAPCLUST_5' import package: ERROR

Import Monitor jobs: running 2, waiting 5, completed 102, failed 10, total 119.

Loading of 'SAPSSEXC_3' import package: ERROR

Import Monitor jobs: running 1, waiting 5, completed 102, failed 11, total 119.

Loading of 'SAPCLUST_1' import package: ERROR

Import Monitor jobs: running 0, waiting 5, completed 102, failed 12, total 119.

Import Monitor jobs: running 1, waiting 4, completed 102, failed 12, total 119.

Import Monitor jobs: running 2, waiting 3, completed 102, failed 12, total 119.

Import Monitor jobs: running 3, waiting 2, completed 102, failed 12, total 119.

Loading of 'SAPCLUST_7' import package: ERROR

Import Monitor jobs: running 2, waiting 2, completed 102, failed 13, total 119.

Loading of 'SAPDFACT' import package: ERROR

Import Monitor jobs: running 1, waiting 2, completed 102, failed 14, total 119.

Loading of 'SAPCLUST_3' import package: ERROR

Import Monitor jobs: running 0, waiting 2, completed 102, failed 15, total 119.

Import Monitor jobs: running 1, waiting 1, completed 102, failed 15, total 119.

Loading of 'SAP0000' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 102, failed 16, total 119.

Please reply the same,

Reagrds,

Santosh

[markus_doehr2 · Accepted solution]

> Loading of 'SAPCLUST_6' import package: ERROR

Read the corresponding logfile SAPCLUST_6.log

(and all the others).

Markus

[Former Member · Accepted solution]

Post the log for SAPCLUST_6

Pravin

[Former Member · Accepted solution]

Loading of 'SAPCLUST_6' import package: ERROR

Read the corresponding logfile SAPCLUST_6.log

Markus

Dear Makrkus ,

After Resize the tablespace and reboot the server ,'SAPCLUST_6' import package: ERROR resolved.

Now we get the follwoign Error :

java version "1.6.0_16"

Java(TM) SE Runtime Environment (build 1.6.0_16-b01)

Java HotSpot(TM) 64-Bit Server VM (build 14.2-b01, mixed mode)

Import Monitor jobs: running 1, waiting 10, completed 108, failed 0, total 119.

Import Monitor jobs: running 2, waiting 9, completed 108, failed 0, total 119.

Import Monitor jobs: running 3, waiting 8, completed 108, failed 0, total 119.

Loading of 'SAPSSEXC_6' import package: ERROR

Import Monitor jobs: running 2, waiting 8, completed 108, failed 1, total 119.

Loading of 'SAPSSEXC_4' import package: OK

Import Monitor jobs: running 1, waiting 8, completed 109, failed 1, total 119.

Loading of 'SAPSSEXC_10' import package: ERROR

Import Monitor jobs: running 0, waiting 8, completed 109, failed 2, total 119.

Import Monitor jobs: running 1, waiting 7, completed 109, failed 2, total 119.

Import Monitor jobs: running 2, waiting 6, completed 109, failed 2, total 119.

Import Monitor jobs: running 3, waiting 5, completed 109, failed 2, total 119.

Loading of 'SAPSSEXC_5' import package: ERROR

Import Monitor jobs: running 2, waiting 5, completed 109, failed 3, total 119.

Loading of 'SAPPOOL' import package: ERROR

Import Monitor jobs: running 1, waiting 5, completed 109, failed 4, total 119.

Import Monitor jobs: running 2, waiting 4, completed 109, failed 4, total 119.

Import Monitor jobs: running 3, waiting 3, completed 109, failed 4, total 119.

Loading of 'SAPSSEXC_3' import package: ERROR

Import Monitor jobs: running 2, waiting 3, completed 109, failed 5, total 119.

Loading of 'SAPCLUST_3' import package: ERROR

Import Monitor jobs: running 1, waiting 3, completed 109, failed 6, total 119.

Import Monitor jobs: running 2, waiting 2, completed 109, failed 6, total 119.

Import Monitor jobs: running 3, waiting 1, completed 109, failed 6, total 119.

Loading of 'SAP0000' import package: OK

Import Monitor jobs: running 2, waiting 1, completed 110, failed 6, total 119.

Loading of 'SAPDFACT' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 110, failed 7, total 119.

Loading of 'SAPSSEXC_7' import package: OK

Import Monitor jobs: running 0, waiting 1, completed 111, failed 7, total 119.

[Former Member · Accepted solution]

Post the log for any of the errored Packages

Pravin

[former_member204746 · Accepted solution]

show SAPDFACT*.log

[Former Member · Accepted solution]

SAPDFACT.log

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090911080930

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:36:46

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe -ctf I D:\BKP\export\ABAP\DATA\SAPDFACT.STR C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\DDLORA.TPL SAPDFACT.TSK ORA -l SAPDFACT.log

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: job completed

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090911080930

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090911080930

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:36:46

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -k 1G5fdEM50TIIrBzjt6TE5Pae -l SAPDFACT.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 = "Z0120090910050937 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "SAPTEST "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "SAPTEST"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 1"

(GSI) INFO: machine = "2x AMD64 Level 6 (Mod 15 Step 2)"

(DB) INFO: /BI0/E0RSTT_C01 created #20090911080931

(IMP) INFO: import of /BI0/E0RSTT_C01 completed (0 rows) #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~0 created #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~01 created #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~02 created #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~04 created #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~05 created #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~06 created #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~07 created #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~08 created #20090911080931

(DB) INFO: /BI0/E0RSTT_C01~09 created #20090911080932

(DB) INFO: /BI0/E0RSTT_C01~10 created #20090911080932

(DB) INFO: /BI0/E0RSTT_C01~11 created #20090911080932

(DB) INFO: /BI0/E0RSTT_C01~12 created #20090911080932

(DB) INFO: /BI0/E0RSTT_C01~13 created #20090911080932

DbSl Trace: ORA-1408 occurred when executing SQL statement (parse error offset=57)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0RSTT_C01~P" ON "/BI0/E0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1408)

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090911080932

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090911091006

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:36:46

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -k 1G5fdEM50TIIrBzjt6TE5Pae -l SAPDFACT.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 = "Z0120090910050937 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "SAPTEST "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "SAPTEST"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 1"

(GSI) INFO: machine = "2x AMD64 Level 6 (Mod 15 Step 2)"

(DB) ERROR: DDL statement failed

(DROP INDEX "/BI0/E0RSTT_C01~P")

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: ORA-1408 occurred when executing SQL statement (parse error offset=57)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0RSTT_C01~P" ON "/BI0/E0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1408)

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090911091006

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090911092111

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:36:46

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -k 1G5fdEM50TIIrBzjt6TE5Pae -l SAPDFACT.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 = "Z0120090910050937 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "SAPTEST "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "SAPTEST"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 1"

(GSI) INFO: machine = "2x AMD64 Level 6 (Mod 15 Step 2)"

(DB) ERROR: DDL statement failed

(DROP INDEX "/BI0/E0RSTT_C01~P")

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: ORA-1408 occurred when executing SQL statement (parse error offset=57)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0RSTT_C01~P" ON "/BI0/E0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1408)

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090911092112

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090911113422

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:36:46

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -k 1G5fdEM50TIIrBzjt6TE5Pae -l SAPDFACT.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090911113422

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090911113726

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Sep 1 2006 00:36:46

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -k 1G5fdEM50TIIrBzjt6TE5Pae -l SAPDFACT.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090911113726

[Former Member · Accepted solution]

Did you run the program SMIGR_CREATE_DDL generates DDL statements and incude that output ??

Pravin

[Former Member · Accepted solution]

No , We are not run the run the program SMIGR_CREATE_DDL generates DDL , If required hen Please tell me Where / How this Pogram run ?

Reagrds,

Santosh

[Former Member · Accepted solution]

This report must be run prior to the export and it creates an output which you need to copy over and during the import it takes care of the issues like you are facing.

It is mentioned in the system copy document and the notes

At this point

You have to create the index manually - whcih you cant do as it will give the same error

Modify the TSK file to set the Indexes to ignore but not sure how many times you will have to restart

as there will be a lot of them

"I /BIC/E<Cubename>_{<index> C err" to "I /BIC/E<Cubename>}<index> C ign"

Afterwards, the indexes can be generated manually by runing program SAP_INFOCUBE_INDEXES_REPAIR

Pravin

[Former Member · Accepted solution]

Actually would suggest the you run the report in the source system

Read the documentation and then palce the file in the correct location

Redo the import from beggining, This is the only way to ensure you havent missed anything

Pravin

[Former Member · Accepted solution]

Check Note 771209

Explains the procedure in detail.

Pravin

[markus_doehr2 · Accepted solution]

> D:\usr\sap\Z01\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

> Compiled Sep 1 2006 00:36:46

...and as additional info: I would highly recommend updating your and the system copy tools (R3load, R3ldctl, R3szchk) before you do the next run. Your tools are three years old.

Markus

[Former Member · Accepted solution]

Hi,

Please open the respective .TSK file and change OK to err for the object starts with T just before the err object.

for example,

T /BI0/IDATE C ok

D /BI0/IDATE I ok

P /BI0/IDATE~0 C ok

I /BI0/IDATE~001 C err

If you see the object I is 'err' status . You change the status of 'T' /BI0.IDATE C from 'ok' to 'err' . Like this ,

T /BI0/IDATE C err

D /BI0/IDATE I ok

P /BI0/IDATE~0 C ok

I /BI0/IDATE~001 C err

Then retry the installation , It will work. Pleaes upgrade r3load to latest version.

regards

Vagesan

[Former Member · Accepted solution]

Dear All,

We copy the (1)new R3load, R3ldctl, R3szchk tools and

(2) extend the size of the PSAPSR3700 tablespace from 10gto 15g ,

(3) open the respective .TSK file and change OK to err for the object starts with T just before the err object.

After run sapinst,following error are observed.

java version "1.6.0_16"

Java(TM) SE Runtime Environment (build 1.6.0_16-b01)

Java HotSpot(TM) 64-Bit Server VM (build 14.2-b01, mixed mode)

Import Monitor jobs: running 1, waiting 6, completed 112, failed 0, total 119.

Import Monitor jobs: running 2, waiting 5, completed 112, failed 0, total 119.

Import Monitor jobs: running 3, waiting 4, completed 112, failed 0, total 119.

Loading of 'SAPPOOL' import package: ERROR

Import Monitor jobs: running 2, waiting 4, completed 112, failed 1, total 119.

Loading of 'SAPSSEXC_11' import package: ERROR

Loading of 'SAPSSEXC_5' import package: ERROR

Import Monitor jobs: running 0, waiting 4, completed 112, failed 3, total 119.

Import Monitor jobs: running 0, waiting 4, completed 112, failed 3, total 119.

Import Monitor jobs: running 1, waiting 3, completed 112, failed 3, total 119.

Import Monitor jobs: running 2, waiting 2, completed 112, failed 3, total 119.

Import Monitor jobs: running 3, waiting 1, completed 112, failed 3, total 119.

Loading of 'SAPDFACT' import package: ERROR

Import Monitor jobs: running 2, waiting 1, completed 112, failed 4, total 119.

Loading of 'SAPCLUST_3' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 112, failed 5, total 119.

Loading of 'SAPSSEXC_3' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 112, failed 6, total 119.

Regards,

Santosh

[Former Member · Accepted solution]

Thanks Markus,

After updateing the (R3load, R3ldctl, R3szchk) files , Server stop and start then resolve the Import_phase issue.

Reagrds,

Santosh Warke

[former_member351769]

Thanks a lot friends, i've face the same issue and it has been solved with your supportive suggestion.