Hi Experts,
We are doing system copy of SCM server 7.0 EHP2. We ran the export as well as SMIGR_CREATE_DDL in source system. Copied SAPDFACT.SQL and SAPDODS.SQL file into <Export_media>\ABAP\DB\ORA\
While importing the system at target, we are getting an issue in IMPORT ABAP phase. SAPDFACT.TSK and SAPDODS.TSK has err entries. Please find the details below.
OS: Windows 2008 R2
Used Kernel: 720 117 patch level (tried with 721 300 level already)
Oracle: 11.2.0.3.0 (applied bundle patch)
BASIS release: 731 SP 10
Please let us know any workaround or SAP note to resolve this issue. Can we follow the note 942540 to resolve the issue? Can we import latest version of SMIGR_CREATE_DDL from SAP note?
Log:
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20141108190517
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 20 2011 02:44:07
patchinfo (patches.h): (0.117) NewDB R3load Correction CREATE VIEW wrong empty string (note 1663153)
process id 4052
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(GSI) INFO: dbname = "APD20141108051144 "
(GSI) INFO: vname = "ORACLE "
(GSI) INFO: hostname = "PIQAS "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "PIQAS"
(GSI) INFO: release = "6.1"
(GSI) INFO: version = "7601 Service Pack 1"
(GSI) INFO: machine = "3x AMD64 Level 6 (Mod 26 Step 5)"
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file G:\ABAP\DB/SQLFiles.LST
(SQL) INFO: G:\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 G:\ABAP\DB/ORA/DFACT.SQL
(SQL) INFO: G:\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 at 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 0000000016K NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL 4 )
DbSlExecute: rc = 99
(SQL error 1408)
error message returned by DbSl:
ORA-01408: such column list already indexed
(DB) INFO: disconnected from DB
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20141108190517
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20141108204058
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 20 2011 02:44:07
patchinfo (patches.h): (0.117) NewDB R3load Correction CREATE VIEW wrong empty string (note 1663153)
process id 3812
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(GSI) INFO: dbname = "APD20141108051144 "
(GSI) INFO: vname = "ORACLE "
(GSI) INFO: hostname = "PIQAS "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "PIQAS"
(GSI) INFO: release = "6.1"
(GSI) INFO: version = "7601 Service Pack 1"
(GSI) INFO: machine = "3x AMD64 Level 6 (Mod 26 Step 5)"
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file G:\ABAP\DB/SQLFiles.LST
(SQL) INFO: found G:\ABAP\DB/SQLFiles.LST
(SQL) INFO: Trying to open G:\ABAP\DB/SQLFiles.LST
(SQL) INFO: G:\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 G:\ABAP\DB/ORA/DFACT.SQL
(SQL) INFO: found G:\ABAP\DB/ORA/DFACT.SQL
(SQL) INFO: Trying to open G:\ABAP\DB/ORA/DFACT.SQL
(SQL) INFO: G:\ABAP\DB/ORA/DFACT.SQL opened
(SQL) ERROR: Invalid entry at line 5 in file G:\ABAP\DB/ORA/DFACT.SQL
(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
(SQL) ERROR: SQL list was not built successfully
(DDL) ERROR: check_sql_list() failed for /BI0/9AEDCBAS~P
(DB) INFO: disconnected from DB
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20141108204101
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20141108204532
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.4 [UNICODE]
Compiled Dec 20 2011 02:44:07
patchinfo (patches.h): (0.117) NewDB R3load Correction CREATE VIEW wrong empty string (note 1663153)
process id 3392
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(GSI) INFO: dbname = "APD20141108051144 "
(GSI) INFO: vname = "ORACLE "
(GSI) INFO: hostname = "PIQAS "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "PIQAS"
(GSI) INFO: release = "6.1"
(GSI) INFO: version = "7601 Service Pack 1"
(GSI) INFO: machine = "3x AMD64 Level 6 (Mod 26 Step 5)"
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file G:\ABAP\DB/SQLFiles.LST
(SQL) INFO: found G:\ABAP\DB/SQLFiles.LST
(SQL) INFO: Trying to open G:\ABAP\DB/SQLFiles.LST
(SQL) INFO: G:\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 G:\ABAP\DB/ORA/DFACT.SQL
(SQL) INFO: found G:\ABAP\DB/ORA/DFACT.SQL
(SQL) INFO: Trying to open G:\ABAP\DB/ORA/DFACT.SQL
(SQL) INFO: G:\ABAP\DB/ORA/DFACT.SQL opened
(SQL) ERROR: Invalid entry at line 5 in file G:\ABAP\DB/ORA/DFACT.SQL
(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
(SQL) ERROR: SQL list was not built successfully
(DDL) ERROR: check_sql_list() failed for /BI0/9AEDCBAS~P
(DB) INFO: disconnected from DB
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
E:\usr\sap\APD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20141108204533
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.