on 08-10-2016 4:13 PM
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 ...
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello James,
thanks for your reply.
2016-08-12 15:17:07 Step 'Pre splitting' failed.
Reason: 'java.lang.NumberFormatException: For input string: "15 "'.
2016-08-12 15:17:07 Distribution Monitor stopped in operation:
Preparation -> Pre splitting
1 errors and 0 warnings occurred
Please check: distribution_monitor_prepare.log
+ exit 0
+ rm -f /tmp/distMon.11298
no log has been created and WHR files are also not getting created.
Regards,
Indrajith
User | Count |
---|---|
81 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.