Skip to Content

ERROR in TABLE SPLITTING when using the DISTMON

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 ...

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 12, 2016 at 12:47 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.