Import of splitted tables failed using distribution monitor

[juergen_lanvers]

Hi All!

We have an issue performing a migration from HP-UX 11.31 MaxDB to Linux MaxDB. During the import of splitted tables we get some errors like this

(DB) INFO: connected to DB

(DB) INFO: The MaxDB logwriter is switched off#20141024031819

(DB) INFO: Maxdb Kernel version 7.9.08.025

                         SQLDBC 7.8.2.035

(DB) INFO: Loading Data with MaxDB Fastloader Api

(DB) INFO:            SDBLoader 7.8.2 .

(GSI) INFO: dbname   = "PUG                                                                                                                             "

(GSI) INFO: vname    = "ADABAS D                        "

(GSI) INFO: hostname = "vm-l-pugprod                                                    "

(GSI) INFO: sysname  = "HP-UX"

(GSI) INFO: nodename = "sappu2"

(GSI) INFO: release  = "B.11.31"

(GSI) INFO: version  = "U"

(GSI) INFO: machine  = "ia64"

adaExeFastload (executeFastLoader): -25304:Attempt to insert single record after key sequence error failed with error -10210 = 'Invalid command state (No prepared SQL command)'

-25303 = Key sequence error

last inserted key: '..9.0.0..0.0.5.0.0.5.6.0.6.5..1.9.9.9..0.0.0.1' (binary: '01003900300030010030003000350030003000350036003000360035010031003900390039010030003000300031')

new key:           '..9.0.0..0.0.4.0.1.0.0.0.0.0..2.0.0.8..0.0.0.1' (binary: '01003900300030010030003000340030003100300030003000300030010032003000300038010030003000300031').

(IMP) ERROR: ExeFastload: rc = 2

We assume that this error is resulting in performing multiple R3load-processes for import. Hence we configured groups for importing one table with a single R3load. (content of split_tab_seq_imp.txt:)

~

SAPAPPL0_6

SAPAPPL2_2

SAPCLUST

#Beginning of Package Groups definition

#Package group 1

[ COSS ]

jobNum = 1

COSS-1

COSS-2

COSS-3

COSS-4

COSS-5

COSS-6

COSS-7

COSS-8

COSS-9

COSS-10

COSS-11

COSS-12

#Package group 2

[ MSEG ]

jobNum = 1

MSEG-1

MSEG-2

MSEG-3

MSEG-4

MSEG-5

MSEG-6

MSEG-7

#Package group 3

[ ZBBSEG_H ]

jobNum = 1

ZBBSEG_H-1

ZBBSEG_H-2

ZBBSEG_H-3

ZBBSEG_H-4

~

Content of import_monitor_cmd.properties

## Import Monitor options

# Generation of task files

tskFiles=yes

# Additional R3load arguments for TASK phase

taskArgs=

# Additional R3load arguments for LOAD phase

loadArgs=

# Inclusion of extent files

extFiles=no

# Import order

orderBy=split_tab_seq_imp.txt

# Monitor timeout in seconds

monitorTimeout=30

# List of import directories, separator on Windows ; on UNIX :

importDirs=/export/SAP/sappu2

# Installation direcotry

installDir=

# Optional path to R3load executable

r3loadExe=/export/SAP/users/pugadm_imp/exe/R3load

# Number of parallel export jobs

impJobNum=5

jobNum=5

import_monitor.log

INFO: 2014-10-23 17:11:02

Import Monitor is started.

CONFIG: 2014-10-23 17:11:02

Application options:

dbCodepage=4102

dbType=ADA

ddlMap=/export/SAP/commDir/SAPPU2/ddl_mapping_import.txt

exchangeDir=/export/SAP/commDir/SAPPU2/netExchangeDir

extFiles=no

impJobNum=5

importDirs=/export/SAP/sappu2

installDir=/export/SAP/sappu2/importInstallDir/

jobNum=5

loadArgs=

monitorTimeout=30

orderBy=/export/SAP/commDir/SAPPU2/split_tab_seq_imp.txt

r3loadExe=/export/SAP/users/pugadm_imp/exe/R3load

taskArgs=

trace=all

tskFiles=yes

But we still see several R3loads for import of the same table and the errors still occur.

Please help. Thanks.

[ACE-SAP]

Hi

You should get more (some) answers if posing in the appropriate area.

Regards