Error at Import ABAP phase with system copy

[Former Member]

Hi Gurus,

am doing system copy of scm ehp1 got struck with error at import ABAP phase.

attacjed log files as below.

may be problem with perticuler index and tried to drop index but am not able to connect database.

when i give connec SAPSR3 /as sysdba it is asking for password and even am entering right password also it is giving error ORA-12560 error.

source is oracle 10g and target db is 11g.

please help me solve this issue.

import monitor log: ERROR: 2012-06-04 16:50:54 com.sap.inst.migmon.LoadTask run Loading of 'SAPDFACT' import package is interrupted with R3load error. Process 'D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error' 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 SAPDFACT.log: D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -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  = "IS320120604030617                                                                                                              " (GSI) INFO: vname    = "ORACLE                          " (GSI) INFO: hostname = "Q4DE3GSY262                                                    " (GSI) INFO: sysname  = "Windows NT" (GSI) INFO: nodename = "Q4DE3GSY262" (GSI) INFO: release  = "6.1" (GSI) INFO: version  = "7601 Service Pack 1" (GSI) INFO: machine  = "2x AMD64 Level 6 (Mod 26 Step 4)" (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file D:\CDs\export4juni\ABAP\DB/SQLFiles.LST (SQL) INFO: D:\CDs\export4juni\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 D:\CDs\export4juni\ABAP\DB/ORA/DFACT.SQL (SQL) INFO: D:\CDs\export4juni\ABAP\DB/ORA/DFACT.SQL not found (DB) ERROR: DDL statement failed (DROP INDEX "/BI0/9AEDCBAS~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 when executing SQL stmt (parse error offset=53) (DB) ERROR: DDL statement failed (CREATE  INDEX "/BI0/9AEDCBAS~P" ON "/BI0/9AEDCBAS" ( "KEY_9ADCBASP" , "KEY_9ADCBAST" , "KEY_9ADCBASU" , "KEY_9ADCBAS1"  ) 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\IS3\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s) D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20120605080837 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20120605085128 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE] Compiled May  7 2010 03:19:51 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -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  = "IS320120604030617                                                                                                              " (GSI) INFO: vname    = "ORACLE                          " (GSI) INFO: hostname = "Q4DE3GSY262                                                    " (GSI) INFO: sysname  = "Windows NT" (GSI) INFO: nodename = "Q4DE3GSY262" (GSI) INFO: release  = "6.1" (GSI) INFO: version  = "7601 Service Pack 1" (GSI) INFO: machine  = "2x AMD64 Level 6 (Mod 26 Step 4)" (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file D:\CDs\export4juni\ABAP\DB/SQLFiles.LST (SQL) INFO: found D:\CDs\export4juni\ABAP\DB/SQLFiles.LST (SQL) INFO: Trying to open D:\CDs\export4juni\ABAP\DB/SQLFiles.LST (SQL) INFO: D:\CDs\export4juni\ABAP\DB/SQLFiles.LST opened (SQL) INFO: Searching for SQL file DFACT.SQL (SQL) INFO: DFACT.SQL not found (SQL) INFO: Searching for SQL file D:\CDs\export4juni\ABAP\DB/ORA/DFACT.SQL (SQL) INFO: D:\CDs\export4juni\ABAP\DB/ORA/DFACT.SQL not found (SQL) ERROR: SQL list was not built successfully (DDL) ERROR: check_sql_list() failed for /BI0/9AEDCBAS~P (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 when executing SQL stmt (parse error offset=53) (DB) ERROR: DDL statement failed (CREATE  INDEX "/BI0/9AEDCBAS~P" ON "/BI0/9AEDCBAS" ( "KEY_9ADCBASP" , "KEY_9ADCBAST" , "KEY_9ADCBASU" , "KEY_9ADCBAS1"  ) 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\IS3\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s) D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20120605085128 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20120605090348 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE] Compiled May  7 2010 03:19:51 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -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  = "IS320120604030617                                                                                                              " (GSI) INFO: vname    = "ORACLE                          " (GSI) INFO: hostname = "Q4DE3GSY262                                                    " (GSI) INFO: sysname  = "Windows NT" (GSI) INFO: nodename = "Q4DE3GSY262" (GSI) INFO: release  = "6.1" (GSI) INFO: version  = "7601 Service Pack 1" (GSI) INFO: machine  = "2x AMD64 Level 6 (Mod 26 Step 4)" (SQL) INFO: Searching for SQL file SQLFiles.LST (SQL) INFO: SQLFiles.LST not found (SQL) INFO: Searching for SQL file D:\CDs\export4juni\ABAP\DB/SQLFiles.LST (SQL) INFO: found D:\CDs\export4juni\ABAP\DB/SQLFiles.LST (SQL) INFO: Trying to open D:\CDs\export4juni\ABAP\DB/SQLFiles.LST (SQL) INFO: D:\CDs\export4juni\ABAP\DB/SQLFiles.LST opened (SQL) INFO: Searching for SQL file DFACT.SQL (SQL) INFO: DFACT.SQL not found (SQL) INFO: Searching for SQL file D:\CDs\export4juni\ABAP\DB/ORA/DFACT.SQL (SQL) INFO: D:\CDs\export4juni\ABAP\DB/ORA/DFACT.SQL not found (SQL) ERROR: SQL list was not built successfully (DDL) ERROR: check_sql_list() failed for /BI0/9AEDCBAS~P (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 when executing SQL stmt (parse error offset=53) (DB) ERROR: DDL statement failed (CREATE  INDEX "/BI0/9AEDCBAS~P" ON "/BI0/9AEDCBAS" ( "KEY_9ADCBASP" , "KEY_9ADCBAST" , "KEY_9ADCBASU" , "KEY_9ADCBAS1"  ) 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\IS3\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s) D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20120605090348 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20120605092104 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE] Compiled May  7 2010 03:19:51 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error DbSl Trace: CONNECT failed with sql error '1034' (DB) ERROR: db_connect rc = 256 DbSl Trace: CONNECT failed with sql error '1034' (DB) ERROR: DbSlErrorMsg rc = 99 D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s) D:\usr\sap\IS3\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20120605092105

Thanks,

Venkat

[former_member189725 · Accepted solution]

Did you generate the <TABART>.SQL files running  report SMIGR_CREATE_DDL in the source system ?

Regards

Ratnajit

[Former Member · Accepted solution]

Hi Ratnajit,

thanks for quick reply.

my collegue has exported it. he has given some SQL file as below.

i hope he has ran report SMIGR_CREATE_DDL.

SQLFiles.LST

DFACT.SQL

APPL1.SQL

DODS.SQL

problem is sap inst not asked about these files and i have places these files in different directory.

please advise me.

Thanks,

Venkat

[Former Member · Accepted solution]

Hi,

i have deleted index /BI0/9AEDCBAS~P from SAPDFACT.tsk then it went next phase. but i have one doubt is it any problem in future?

[Former Member · Accepted solution]

Hello Venkat,

After running  Report SMIGR_CREATE_DDL you have to  copy the results in either install dir of your target server or in case of oracle it should be copied to export_dump/DB/ORA.

Make sure you have done this.

It is also recommended that you should run this report just before starting the export.

First it looks for .SQL files (generated by the report), if it doesnt find then it takes from the standard .tsk file.

Probable reasons:-

1)  Report not run before export

2) Did not put the files generated in the location mentioned by me.

Thanks,

Vishal

[Former Member · Accepted solution]

Hi Vishal,

yes you are right.

i have copied above .sql files into installation directory with tmp folder name. when error came i have copied above files to export_dump/DB/ORA.

now i have completed installation and performed initial checks not found any problem. but if i remove err index from .tsk is it cause any problem in future?

i have one doubt on .sql files when sap instmaster will ask these files?

Thanks,

Venkat

[Former Member · Accepted solution]

Hello Venkat,

These *.SQL files are used by R3load to create non standard DB objects in the target system.

Please find the content from TADM 70:-

In the case of BW non-standard database objects, the ABAP Dictionary contains table and index

definitions that are not sufficient to describe all objects properties. The missing information is held in the BW meta data (i.e. partition information, bit mapped indices, ...). R3LDCTL reads the ABAP Dictionary only. Additional information from BW meta data cannot be inserted into *.STR files. The *.STR file content is enough to export and import BW data via R3LOAD, but is insufficient to create the BW object in the target system.

To overcome the existing limitations of R3LDCTL and R3LOAD, the report SMIGR_CREATE_DDL

was developed, which writes database specific DDL statements into *.SQL files. R3LOAD was

extended to switch between the normal way of creating tables and indexes, and the direct execution of DDL statements from a *.SQL file. Now it is possible to create non-standard database objects and to load data into it using R3LOAD.

I am not sure about the index which you have skipped, it looks like a index for temporary BW table to me.I guess your BI consultant might give you proper answer.

Thanks,

Vishal

[Former Member]

Thanks vishal for detail explanation.

Venkat

[Former Member]

Hello Venkat,

As Vishal suggested, please work with your BI team and get this index recreated if needed.

Thanks,

Siva Kumar