Error while system copy

[Former Member]

Hello! While system copy I got an error:

TRACE: 2016-01-27 13:35:31 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SAPDFACT' starting import package into database:
/usr/sap/ER1/SYS/exe/uc/linuxx86_64/R3load -i SAPDFACT.cmd -dbcodepage 4103 -k 1gagfeM50D401eqte1Ev0Qa5 -l SAPDFACT.log -stop_on_error -loadprocedure fast

TRACE: 2016-01-27 13:35:31 com.sap.inst.migmon.LoadTask processPackage
Loading of 'SAPDDIM' starting import package into database:
/usr/sap/ER1/SYS/exe/uc/linuxx86_64/R3load -i SAPDDIM.cmd -dbcodepage 4103 -k 1gagfeM50D401eqte1Ev0Qa5 -l SAPDDIM.log -stop_on_error -loadprocedure fast

INFO: 2016-01-27 13:35:31 com.sap.inst.migmon.LoadTask run_report
Monitor jobs: running 2, waiting 4, completed 60, failed 1, total 67  error processing of package SAPDFACT

ERROR: 2016-01-27 13:35:31 com.sap.inst.migmon.LoadTask run
Loading of 'SAPDFACT' import package is interrupted with R3load error.
Process '/usr/sap/ER1/SYS/exe/uc/linuxx86_64/R3load -i SAPDFACT.cmd -dbcodepage 4103 -k 1gagfeM50D401eqte1Ev0Qa5 -l SAPDFACT.log -stop_on_error -loadprocedure fast' exited with return code 2.
For mode details see 'SAPDFACT.log' file.
Standard error output:
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
sh: module: line 1: syntax error: unexpected end of file
sh: error importing function definition for `BASH_FUNC_module'
sh: module: line 1: syntax error: unexpected end of file

sh: error importing function definition for `BASH_FUNC_module'

SAPDFACT.log :

(DB) ERROR: DDL statement failed
(DROP INDEX "/BI0/E0PPM_VC1~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=55)

(DB) ERROR: DDL statement failed
(CREATE  INDEX "/BI0/E0PPM_VC1~P" ON "/BI0/E0PPM_VC1" ( "KEY_0PPM_VC1P" , "KEY_0PPM_VC1T" , "KEY_0PPM_VC1U" , "KEY_0PPM_VC11"  ) TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016K NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING PARA$
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/ER1/SYS/exe/uc/linuxx86_64/R3load: job finished with 1 error(s)

It is test system copy and I didn't use SMIGR_CREATE_DDL. Can I continue somehow ?

[Former Member · Accepted solution]

check SAP note 2216671 - Error ORA-01408 when creating index

[Former Member · Accepted solution]

Thanks Sunil again!

I dropped the indexes which marked in SAPDFACT.log file.

[former_member185239]

Dear Igor,

Follow the below steps

- Logon to the database

- Run the below command

CREATE  INDEX "/BI0/E0PPM_VC1~P" ON "/BI0/E0PPM_VC1" ( "KEY_0PPM_VC1P" , "KEY_0PPM_VC1T" , "KEY_0PPM_VC1U" , "KEY_0PPM_VC11"  ) TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016K NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING PARA$

If the table and index exist at the database level then open the SAPDFACT.TSK file. Edit the file and in place of err make it ok and retry the SWPM.

if the table and index does not exist then rebuild the TSK file by firing the below command

R3laod -make_only SAPDFACT.TSK

You should have run the SMIGR_CREATE_DDL report.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

R3laod -make_only SAPDFACT.TSK  - not working: R3load: unknown option "-make_only"

[former_member185239]

Dear Igor,

Please try the below command

R3load -merge_only SAPDFACT.TSK. 

Can you please paste me the content of SAPDFACT.TSK file.

With Regards

Ashutosh Chaturvedi