ERROR in TABLE SPLITTING when using the DISTMON

indrajith_v · ‎08-10-2016

Hello All,

We are facing below error in table splitting (R3TA).

Reason: 'java.lang.Exception: /sapmnt/D01/exe/uc/linuxx86_64/R3ta -f /oracle/D01/commDir/PkgSplit/VRSMODISRC.STR -table VRSMODISRC%15 -o /oracle/D01/commDir/R3ta/VRSMODISRC.WHR -check_utf8 -l tableSplitter.VRSMODISRC.log failed with return code 139'.

Please check 'tableSplitter.VRSMODISRC.log'.

2016-08-10 20:31:15 Distmon thread Table splitter VRSMODISRC stopped in operation:

Preparation -> Parallel table splitting -> Thread Table splitter VRSMODISRC -> Table splitter

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.VRSMODISRC.log

2016-08-10 20:31:15: Starting table splitter for table CWBCIDATAOBJ. This may take several hours, please wait.

2016-08-10 20:31:16 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: /sapmnt/D01/exe/uc/linuxx86_64/R3ta -f /oracle/D01/commDir/PkgSplit/ARFCSDATA.STR -table ARFCSDATA%3 -o /oracle/D01/commDir/R3ta/ARFCSDATA.WHR -check_utf8 -l tableSplitter.ARFCSDATA.log failed with return code 139'.

Please check 'tableSplitter.ARFCSDATA.log'.

2016-08-10 20:31:16 Distmon thread Table splitter ARFCSDATA stopped in operation:

Preparation -> Parallel table splitting -> Thread Table splitter ARFCSDATA -> Table splitter

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ARFCSDATA.log

2016-08-10 20:31:16 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: /sapmnt/D01/exe/uc/linuxx86_64/R3ta -f /oracle/D01/commDir/PkgSplit/EDID4.STR -table EDID4%2 -o /oracle/D01/commDir/R3ta/EDID4.WHR -check_utf8 -l tableSplitter.EDID4.log failed with return code 139'.

Please check 'tableSplitter.EDID4.log'.

2016-08-10 20:31:16 Distmon thread Table splitter EDID4 stopped in operation:

Preparation -> Parallel table splitting -> Thread Table splitter EDID4 -> Table splitter

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.EDID4.log

2016-08-10 20:31:16 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: /sapmnt/D01/exe/uc/linuxx86_64/R3ta -f /oracle/D01/commDir/PkgSplit/CWBCIDATAOBJ.STR -table CWBCIDATAOBJ%4 -o /oracle/D01/commDir/R3ta/CWBCIDATAOBJ.WHR -check_utf8 -l tableSplitter.CWBCIDATAOBJ.log failed with return code 139'.

Please check 'tableSplitter.CWBCIDATAOBJ.log'.

2016-08-10 20:31:16 Distmon thread Table splitter CWBCIDATAOBJ stopped in operation:

Preparation -> Parallel table splitting -> Thread Table splitter CWBCIDATAOBJ -> Table splitter

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.CWBCIDATAOBJ.log

Reason: 'java.lang.Exception: /sapmnt/D01/exe/uc/linuxx86_64/R3ta -f /oracle/D01/commDir/PkgSplit/VRSMODISRC.STR -table VRSMODISRC%15 -o /oracle/D01/commDir/R3ta/VRSMODISRC.WHR -check_utf8 -l tableSplitter.VRSMODISRC.log failed with return code 139'.

Please check 'tableSplitter.VRSMODISRC.log'.

2016-08-10 20:31:15 Distmon thread Table splitter VRSMODISRC stopped in operation:

Preparation -> Parallel table splitting -> Thread Table splitter VRSMODISRC -> Table splitter

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.VRSMODISRC.log

2016-08-10 20:31:15: Starting table splitter for table CWBCIDATAOBJ. This may take several hours, please wait.

2016-08-10 20:31:16 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: /sapmnt/D01/exe/uc/linuxx86_64/R3ta -f /oracle/D01/commDir/PkgSplit/ARFCSDATA.STR -table ARFCSDATA%3 -o /oracle/D01/commDir/R3ta/ARFCSDATA.WHR -check_utf8 -l tableSplitter.ARFCSDATA.log failed with return code 139'.

Please check 'tableSplitter.ARFCSDATA.log'.

2016-08-10 20:31:16 Distmon thread Table splitter ARFCSDATA stopped in operation:

Preparation -> Parallel table splitting -> Thread Table splitter ARFCSDATA -> Table splitter

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ARFCSDATA.log

2016-08-10 20:31:16 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: /sapmnt/D01/exe/uc/linuxx86_64/R3ta -f /oracle/D01/commDir/PkgSplit/EDID4.STR -table EDID4%2 -o /oracle/D01/commDir/R3ta/EDID4.WHR -check_utf8 -l tableSplitter.EDID4.log failed with return code 139'.

Please check 'tableSplitter.EDID4.log'.

2016-08-10 20:31:16 Distmon thread Table splitter EDID4 stopped in operation:

Preparation -> Parallel table splitting -> Thread Table splitter EDID4 -> Table splitter

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.EDID4.log

2016-08-10 20:31:16 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: /sapmnt/D01/exe/uc/linuxx86_64/R3ta -f /oracle/D01/commDir/PkgSplit/CWBCIDATAOBJ.STR -table CWBCIDATAOBJ%4 -o /oracle/D01/commDir/R3ta/CWBCIDATAOBJ.WHR -check_utf8 -l tableSplitter.CWBCIDATAOBJ.log failed with return code 139'.

Please check 'tableSplitter.CWBCIDATAOBJ.log'.

2016-08-10 20:31:16 Distmon thread Table splitter CWBCIDATAOBJ stopped in operation:

Preparation -> Parallel table splitting -> Thread Table splitter CWBCIDATAOBJ -> Table splitter

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.CWBCIDATAOBJ.log

Below are our input files:

table_splitter_tables.txt :

VRSMODISRC%15

PCL2%4

DOKTL%3

ARFCSDATA%3

WBCROSSGT%3

EDID4%2

E071K%3

CWBCIDATAOBJ%4

package_splitter.cmd.properties

#

# Package Splitter options

#

# Largest N tables are extracted from packages

top=9

# Table size limit in MB

tableLimit=1000

# Package size limit in MB

#packageLimit=2000

tableFile=table_splitter_tables.txt

distribution_monitor_cmd.properties

# Distribution Monitor options

#

# Main Options

#

# Communication directory shared between all hosts

commDir=/oracle/D01/commDir

# List of involved machines, separator on Windows ; on UNIX :

hostNames=pocmigpro1:pocmigpro2:pocmigpro3

# R3szchk arguments

# -s DB -t <dbType> <sid> <rel>

# -l and -p are set automatically

# use <dbType> and <sid> of the source system

# <dbType> is one of: ada, db2, db4, db6, inf, mss, ora

# for DB2 z/OS: r3szchkArgs=-s DB -q <commDir>/R3ldctl

r3szchkArgs= -s DB -t ora D01 11204

#

# Machine specific information

#

# local directory to store R3load data dump

#<hostname>.dataDirs=pocmigpro2./oracle/pocmigpro2_export

#--------------------------------------------------------------------------------------------

# Server 1

#Data Dir for Server 1

pocmigpro2.dataDirs=/oracle/pocmigpro2_export

# Installation Dir for Export on Server 1

pocmigpro2.exportInstallDir=/usr/sap/tmp/Distmon/export

# Installation Dir for Import on Server 1

pocmigpro2.importInstallDir=/usr/sap/tmp/Distmon/import

#pocmigpro2.exportR3loadExe=C:\Tools\nonUnicode\R3load\620\R3load.exe

pocmigpro2.exportR3loadExe=/sapmnt/D01/exe/uc/linuxx86_64/R3load

#pocmigpro2.importR3loadExe=C:\Tools\Unicode\R3load\620\R3load.exe

pocmigpro2.importR3loadExe=/sapmnt/D01/exe/uc/linuxx86_64/R3load

#Export Job Number on Server 1

pocmigpro2.exportJobNum=5

#Import Job Number on Server 1

pocmigpro2.importJobNum=5

#----------------------------------------------------------------------------------------------

#Server 2

pocmigpro3.dataDirs=/oracle/pocmigpro3_export

#pocmigpro3.exportInstallDir=E:\SAPData\log

# Installation Dir for Export on Server 1

pocmigpro3.exportInstallDir=/usr/sap/tmp/Distmon/export

# Installation Dir for Import on Server 1

pocmigpro3.importInstallDir=/usr/sap/tmp/Distmon/import

#pocmigpro3.exportR3loadExe=E:\CDs\620_NUC\R3load\R3load.exe

pocmigpro3.exportR3loadExe=/sapmnt/D01/exe/uc/linuxx86_64/R3load

#pocmigpro3.importR3loadExe=E:\CDs\620_UC\R3load\R3load.exe

pocmigpro3.importR3loadExe=/sapmnt/D01/exe/uc/linuxx86_64/R3load

#pocmigpro2.exportJobNum=5

pocmigpro2.importOmit=

# number of jobs for R3load export

#----------------------------------------------------------------------------------------------

pocmigpro1.dataDirs=/oracle/pocmigpro1_export

#pocmigpro3.exportInstallDir=E:\SAPData\log

# Installation Dir for Export on Server 1

pocmigpro1.exportInstallDir=/usr/sap/tmp/Distmon/export

# Installation Dir for Import on Server 1

pocmigpro1.importInstallDir=/usr/sap/tmp/Distmon/import

#pocmigpro3.exportR3loadExe=E:\CDs\620_NUC\R3load\R3load.exe

pocmigpro1.exportR3loadExe=/sapmnt/D01/exe/uc/linuxx86_64/R3load

#pocmigpro3.importR3loadExe=E:\CDs\620_UC\R3load\R3load.exe

pocmigpro1.importR3loadExe=/sapmnt/D01/exe/uc/linuxx86_64/R3load

#pocmigpro2.exportJobNum=5

pocmigpro1.importOmit=

# number of jobs for R3load export

# typical is 2 to 4 per CPU

#<hostname>.exportJobNum=4

#pocmigpro2.exportJobNum=5

pocmigpro1.exportJobNum=5

# number of jobs for R3load import

# typical is 1 to 4 per CPU

#<hostname>.importJobNum=4

pocmigpro1.importJobNum=5

r3taExe=/sapmnt/D01/exe/uc/linuxx86_64/R3ta

parallelR3ta=5

#

# steps to skip

# set when the results of these steps are already available and shall not be repeated

#

# Skip R3ldctl execution; specify path containing STR and TPL files if it

# is different from <commDir>/R3ldctl

skipR3ldctl=

# Skip R3szchk execution; specify path containing EXT files if it

# is different from <commDir>/R3szchk

skipR3szchk=

# Skip Package Split execution; specify path containing STR and EXT files

# if it is different from <commDir>/PkgSplit

#skipPkgSplit=

# Skipping Where files

skipWhrChk=

please Help.

Thanks in advance ...

JamesZ · ‎08-12-2016

Hi Indrajith,

This does not look like a database error, however please attach log Splitter.VRSMODISRC.log for an example to review.

Best regards,
James

ERROR in TABLE SPLITTING when using the DISTMON

Accepted Solutions (0)

Answers (1)

Answers (1)

Re: Connecting SAP CAP with SAP Cloud ALM

Re: How can assign in Identity Authentication Serv...

Re: Are there plans to update the Spring framework...

Vendor Invoice Screen 'Payment' tab screen field '...

I have data like Date, Net, Gross. I want to deriv...