SQL error 1418 with SAP Sol Man Migration

[former_member196171]

Hi Experts,

I am migrating Sol Man 7.1 from Windows / Oracle   to AIX / Oracle , While exporting with sapinst on target ,  ABAP import ended up with the error as below , please help

(DB) INFO: /BI0/E0CCMARCDH~12 created #20121126113826

(DB) INFO: /BI0/E0CCMARCDH~13 created #20121126113826

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

DbSl Trace: ORA-01408 occurred at SQL stmt (parse error offset=3735552)

(DB) ERROR: DDL statement failed
(CREATE  INDEX "/BI0/E0CCMARCDH~P" ON "/BI0/E0CCMARCDH" ( "KEY_0CCMARCDHP" , "KEY_0CCMARCDHT" , "KEY_0CCMARCDHU" , "KEY_0CCMARCDH1" , "KEY_0CCMARCDH2" , "KEY_0CCMARCDH3" , "KEY_0CCMARCDH4" , "KEY_0CCMARCDH5" , "KEY_0CCMARCDH6" , "KEY_0CCMARCDH7" , "KEY_0CCMARCDH8" , "KEY_0CCMARCDH9" , "KEY_0CCMARCDHB"  ) TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016K 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

/usr/sap/P2L/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/P2L/SYS/exe/run/R3load: END OF LOG: 20121126113827

/usr/sap/P2L/SYS/exe/run/R3load: START OF LOG: 20121126123952

/usr/sap/P2L/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
/usr/sap/P2L/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]
Compiled Dec  1 2011 20:34:30
/usr/sap/P2L/SYS/exe/run/R3load -i SAPDFACT.cmd -dbcodepage 4102 -k 1gageEM50Dk01eqteAEv0Amv -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): UTF16
(GSI) INFO: dbname   = "P2L20121123031159                                                                                                               "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "sbx-P2L                                                         "
(GSI) INFO: sysname  = "AIX"
(GSI) INFO: nodename = "sbx-P2L"
(GSI) INFO: release  = "1"
(GSI) INFO: version  = "6"
(GSI) INFO: machine  = "00F74D1F4C00"
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file /sap_software/SolMan7.1/SMS_Export/ABAP/DB/SQLFiles.LST
(SQL) INFO: /sap_software/SolMan7.1/SMS_Export/ABAP/DB/SQLFiles.LST not found
(SQL) INFO: Searching for SQL file DFACT.SQL
(SQL) INFO: DFACT.SQL not found
(SQL) INFO: Searching for SQL file /sap_software/SolMan7.1/SMS_Export/ABAP/DB/ORA/DFACT.SQL
(SQL) INFO: /sap_software/SolMan7.1/SMS_Export/ABAP/DB/ORA/DFACT.SQL not found
(DB) ERROR: DDL statement failed
(DROP INDEX "/BI0/E0CCMARCDH~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: Error 1408 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-01408 occurred at SQL stmt (parse error offset=3735552)

(DB) ERROR: DDL statement failed
(CREATE  INDEX "/BI0/E0CCMARCDH~P" ON "/BI0/E0CCMARCDH" ( "KEY_0CCMARCDHP" , "KEY_0CCMARCDHT" , "KEY_0CCMARCDHU" , "KEY_0CCMARCDH1" , "KEY_0CCMARCDH2" , "KEY_0CCMARCDH3" , "KEY_0CCMARCDH4" , "KEY_0CCMARCDH5" , "KEY_0CCMARCDH6" , "KEY_0CCMARCDH7" , "KEY_0CCMARCDH8" , "KEY_0CCMARCDH9" , "KEY_0CCMARCDHB"  ) TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016K 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

/usr/sap/P2L/SYS/exe/run/R3load: job finished with 1 error(s)
/usr/sap/P2L/SYS/exe/run/R3load: END OF LOG: 20121126123955

[JPReyes · Accepted solution]

This s most likely a problem with R3load, Download and update R3load to the latest version and resume the import.

Read,

Note 885441 - Common Migration Errors

Regards, Juan

[former_member196171 · Accepted solution]

Hi Juan ,

Thanks for the reply, yes the problem has been solved with the help of the note 885441,

after copying the generated DDL statements by SMIGR_CREATE_DDL in the right folders , migration completed successfully

Thanks

Al Mamun

[Former Member]

Hi,

Check the permission (both read/write/create) for schema user on the tablespace PSAPSR3.

Include sidadm user id as part of dba group ( in /etc/group) file during migration period. After migration you can remove it. As Juan mentioned - please update the R3load, R3ta, R3ldclt and R3szchk to the talest release.

Regards,

Dipam