on 07-06-2015 10:52 AM
Hello,
I'm getting errors during EU_CLONE_MIG_DT_RUN phase on downtime.
2EETQ109 Found 14 errors in logs.
2EETQ106 14 processes failed.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00015_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00015_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00019_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00019_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00020_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00020_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00022_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00022_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00026_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00026_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00047_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00047_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00049_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00049_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00050_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00050_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00051_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00051_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00054_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00054_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00056_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00056_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00059_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00059_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00060_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00060_IMP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00061_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00061_IMP.LOG'
But this error changes if I put more or less R3Load process during import. If I put a low value the error is less:
Into migrate_dt\MIGRATE_DT_00015_IMP.TSK appears some objetcs with status err, but I don't know how
D/BIC/DSCM_LES9 I ok
M /BIC/DSCM_LES9 C ok
P /BIC/DSCM_LES9~0 C ok
I/BIC/DSCM_LES9~000 C err
I /BIC/DSCM_LES9~010 C ok
I /BIC/DSCM_LES9~020 C ok
I/BIC/DSCM_LES9~030 C ok
I/BIC/DSCM_LES9~040 C ok
I/BIC/DSCM_LES9~050 C ok
I/BIC/DSCM_LES9~060 C ok
I/BIC/DSCM_LES9~070 C ok
I/BIC/DSCM_LES9~080 C ok
(RDI) INFO: H:\\SUM\abap\migrate_dt\MIGRATE_DT_00015_IMP.STR has format version 2
(DDL) ERROR: no DDL for /BIC/DSCM_LES9
(build_ddl_stmt).
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: /BIC/DSCM_LES9 merged #20150705215352
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: found SQLFiles.LST
(SQL) INFO: Trying to open SQLFiles.LST
(SQL) INFO: SQLFiles.LST opened
(SQL) INFO: Searching for SQL file DDIM.SQL
(SQL) INFO: found DDIM.SQL
(SQL) INFO: Trying to open DDIM.SQL
(SQL) INFO: DDIM.SQL opened
DbSl Trace: execute(), rc=1, rcSQL=257
DbSl Trace: EXECUTE on connection 0, rc=257
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(DROP INDEX "/BIC/DSCM_LES9~000" drpfulltext: DROP INDEX "/BIC/DSCM_LES9~000")
DbSlExecute: rc = 99
(SQL error 257)
error message returned by DbSl:
sql syntax error: incorrect syntax near "drpfulltext": line 1 col 33 (at pos 33)
(IMP) INFO: a failed DROP attempt is not necessarily a problem
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE INDEX "/BIC/DSCM_LES9~000" ON "/BIC/DSCM_LES9" ( "DIMID" ) )
DbSlExecute: rc = 103
(SQL error 261)
error message returned by DbSl:
invalid index name: column list already indexed
(DDL) ERROR: no DDL for /BIC/DSCM_LES9
(build_ddl_stmt).
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: /BIC/DSCM_LES9 unloaded #20150705215352
How can I resolve it?
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Anand,
I´ve solved the error of index but now I'm getting this error:
2EETQ106 1 processes failed.
1EETQ399 Export task 'migrate_dt\MIGRATE_DT_00168_EXP.CMD' has errors, exit code -1073741819. Check 'migrate_dt\MIGRATE_DT_00168_EXP.LOG'.
1EETQ399 Import task 'migrate_dt\MIGRATE_DT_00168_IMP.CMD' has errors, exit code 2. Check 'migrate_dt\MIGRATE_DT_00168_IMP.LOG'.
Into export log appears this entry
H:\SUM\abap\exe\R3load.EXE: START OF LOG: 20150706184516
(BLD) INFO: sccsid "@(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP"
(BLD) INFO: kernel release 742 [NON-UNICODE]
(BLD) INFO: data format 1.8
(BLD) INFO: patch number 111
(BLD) INFO: compiled on "Mar 31 2015 19:17:35"
(PRC) INFO: working directory "H:\SUM\abap\tmp"
(PRC) INFO: called "H:\SUM\abap\exe\R3load.EXE -pipe -e H:\SUM\abap\migrate_dt\MIGRATE_DT_00168_EXP.CMD -merge_bck -datacodepage 4103 -l H:\SUM\abap\migrate_dt\MIGRATE_DT_00168_EXP.LOG"
(PRC) INFO: process id 6728
(DB) INFO: connected to DB
(EXP) INFO: check NameTab widths: Ok.
(DB) INFO: Export without hintfile
(CNV) INFO: set R3LOAD_CODEPAGES_BUILTIN=1
(RSCP) INFO: UMGCOMCHAR read check, OK.
(RSCP) INFO: environment variable "I18N_POOL_WIDTH" is not set. Checks are active.
(GSI) INFO: dbname = "BWDSAPBW "
(GSI) INFO: vname = "MSSQL "
(GSI) INFO: hostname = "SAPBW "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "SAPBW"
(GSI) INFO: release = "6.1"
(GSI) INFO: version = "7601 Service Pack 1"
(GSI) INFO: machine = "16x AMD64 Level 6 (Mod 44 Step 2)"
Ruben,
Please check the following SAP note :-
978244 - CU&UC and NameTab errors for pools or clusters
try to set environment variable I18N_POOL_WIDTH to IGNORE and continue.
Regards
Anand
Hello Anand,
(RSCP) INFO: environment variable I18N_POOL_WIDTH is not set.
This is the log of the MIGRATE_DT_RUN
#!--------------------------------------------------------------
#!---- MASKING file "MIGRATE_DT_00168_EXP.LOG" from "H: \SUM\abap\migrate_dt"
#!---- TIME: 20150706195239 PHASE: MAIN_SWITCH/SUBMOD_MIG_SWITCH_ORG/SUBMOD_MIG_DOWNTIME_RUN/EU_CLONE_MIG_DT_RUN
#!--------------------------------------------------------------
H: \SUM\abap\exe\R3load.EXE: START OF LOG: 20150706194906
(BLD) INFO: sccsid "@(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP"
(BLD) INFO: kernel release 742 [NON-UNICODE]
(BLD) INFO: data format 1.8
(BLD) INFO: patch number 111
(BLD) INFO: compiled on "Mar 31 2015 19:17:35"
(PRC) INFO: working directory "H: \SUM\abap\tmp"
(PRC) INFO: called "H: \SUM\abap\exe\R3load.EXE -pipe -e H: \SUM\abap\migrate_dt\MIGRATE_DT_00168_EXP.CMD -merge_bck -datacodepage 4103 -l H: \SUM\abap\migrate_dt\MIGRATE_DT_00168_EXP.LOG"
(PRC) INFO: process id 5216
(DB) INFO: connected to DB
(EXP) INFO: check NameTab widths: Ok.
(DB) INFO: Export without hintfile
(CNV) INFO: set R3LOAD_CODEPAGES_BUILTIN=1
(RSCP) INFO: UMGCOMCHAR read check, OK.
(RSCP) INFO: environment variable "I18N_POOL_WIDTH" is not set. Checks are active.
(GSI) INFO: dbname = "BWDSAPBW "
(GSI) INFO: vname = "MSSQL "
(GSI) INFO: hostname = "SAPBW "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "SAPBW"
(GSI) INFO: release = "6.1"
(GSI) INFO: version = "7601 Service Pack 1"
(GSI) INFO: machine = "16x AMD64 Level 6 (Mod 44 Step 2)"
#!--------------------------------------------------------------
#!---- MASKING file "MIGRATE_DT_00168_IMP.LOG" from "H: \SUM\abap\migrate_dt"
#!---- TIME: 20150706195239 PHASE: MAIN_SWITCH/SUBMOD_MIG_SWITCH_ORG/SUBMOD_MIG_DOWNTIME_RUN/EU_CLONE_MIG_DT_RUN
#!--------------------------------------------------------------
H: \SUM\abap\exe_2nd\R3load.EXE: START OF LOG: 20150706194908
(BLD) INFO: sccsid "@(#) $Id: //bas/742_REL/src/R3ld/R3load/R3ldmain.c#8 $ SAP"
(BLD) INFO: kernel release 742 [UNICODE]
(BLD) INFO: data format 1.8
(BLD) INFO: patch number 111
(BLD) INFO: compiled on "Mar 31 2015 19:15:09"
(PRC) INFO: working directory "H: \SUM\abap\tmp"
(PRC) INFO: called "H: \SUM\abap\exe_2nd\R3load.EXE -pipe -i H: \SUM\abap\migrate_dt\MIGRATE_DT_00168_IMP.CMD -datacodepage 4103 -dbcodepage 4103 -l H: \SUM\abap\migrate_dt\MIGRATE_DT_00168_IMP.LOG -loadprocedure fast -table_suffix ~ -nametab DDNTT~ DDNTF~ -k 1WUfdEM50D801eqtd15x0a57"
(PRC) INFO: process id 7244
(DB) INFO: connected to DB
(DB) INFO: NewDB Kernel version 1.00.85.04.401020
SQLDBC 1.00.85.04.0401020
(GSI) INFO: dbname = "H00/00 "
(GSI) INFO: vname = "HDB "
(GSI) INFO: hostname = "saphana "
(GSI) INFO: sysname = "Windows NT"
(GSI) INFO: nodename = "SAPBW"
(GSI) INFO: release = "6.1"
(GSI) INFO: version = "7601 Service Pack 1"
(GSI) INFO: machine = "16x AMD64 Level 6 (Mod 44 Step 2)"
(RTF) ########## WARNING ###########
Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases
(RDI) INFO: H: \SUM\abap\migrate_dt\MIGRATE_DT_00168_IMP.STR has format version 2
(DB) INFO: loading data in table "RSD99" with mass loader for LOBs #20150706194909
(IMP) INFO: starting import for object "RSD99" of type "table" #20150706194909
(DB) INFO: RSD99 deleted/truncated
ERROR read_from_pipe: Cannot read data from pipe off=0 len=20: The pipe has been ended.
(IMP) INFO: starting create for object "RSD99" of type "merge" #20150706194909
(DDL) ERROR: no DDL for RSD99
(build_ddl_stmt).
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: RSD99 merged #20150706194909
(IMP) INFO: finished create for object "RSD99" of type "merge" in 0 sec #20150706194909
(IMP) INFO: starting create for object "RSD99" of type "unload" #20150706194909
(DDL) ERROR: no DDL for RSD99
(build_ddl_stmt).
(IMP) INFO: a failed DROP attempt is not necessarily a problem
(DB) INFO: RSD99 unloaded #20150706194909
(IMP) INFO: finished create for object "RSD99" of type "unload" in 0 sec #20150706194909
(DB) INFO: loading data in table "ECSCR_XML_STR_WD" with mass loader for LOBs #20150706194909
(IMP) INFO: starting import for object "ECSCR_XML_STR_WD" of type "table" #20150706194909
(DB) INFO: ECSCR_XML_STR_WD deleted/truncated
ERROR read_from_pipe: Cannot read data from pipe off=0 len=20: The pipe has been ended.
(DB) INFO: disconnected from DB
H: \SUM\abap\exe_2nd\R3load.EXE: job finished with 2 error(s)
H: \SUM\abap\exe_2nd\R3load.EXE: END OF LOG: 20150706194909
Hello Ruben,
Can yu please check following SAP note :-
1900445 - HANA R3load import: (DB) ERROR: DDL statement failed
Regards
Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.