cancel
Showing results for 
Search instead for 
Did you mean: 

Error during export/import

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

RolandKramer
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Have a look to the following Blog for possible solutions -

You problem is related to outdated R3* tools, see the Table at the end of the Blog.

Best Regards Roland

Former Member
0 Kudos

Thanks for your answer

In both folders abap/exe and abap/exe_2nd I´ve R3load version 742_101.

There are a migration to unicode during DMO process, I´ve to put the R3load version 111 in both folders?

Regards.

Former Member
0 Kudos

Ruben,

Did you get a chance to look at SAP note .

There as attachment in the note which consists of .SAR file.

Please check

Regards

Anand

Former Member
0 Kudos

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)"

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks Anand,

This Environment variable must to be set to sidam, mustn't?

It will be necessary to logoff the session?

Former Member
0 Kudos

Environment variable for the user who is executing SAPINST(SWPM,DMO)

Yes logoff session would be required.

Regards

Anand

Former Member
0 Kudos

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

Former Member
0 Kudos

Ruben,

It seems you have already opened another thread.

Close this thread if your initial query was answered.

Thanks&Regards

Anand

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Ruben,

Can yu please check following SAP note :-

1900445 - HANA R3load import: (DB) ERROR: DDL statement failed

Regards

Anand