Error during Migration using Dist. Monitor

[Former Member]

Hi Techies,

I am performing Migration fro HP-UX to RHEL using Distribution Monitor.

Our database is of 10TB when performing the PREPARATION PHASE getting the below error. The failed table is of 1.8 TB.

Could you please adivce how to re-execute the particular table successfully.

ERROR: 2014-06-21 11:32:07 com.sap.inst.distmon.TableSplitTool run

Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_TRXXX.STR -table ZMD_TRXXXX%80 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_TRXXXX.WHR -check_utf8 -l tableSplitter.ZMD_TRXXXX.log  failed with return code 1'.

Please check 'tableSplitter.ZMD_TRXXXX.log'.

ERROR: 2014-06-21 11:32:07 com.sap.inst.distmon.TableSplitTool run

Call stack:

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.TableSplitTool.runImpl(Unknown Source)

com.sap.inst.distmon.DistMonTool.run(Unknown Source)

com.sap.inst.distmon.DistMonToolThread.run(Unknown Source)

java.lang.Thread.run(Thread.java:595)

ERROR: 2014-06-21 11:32:07 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splitting -> Thread Table splitter ZMD_TRXXXX -> Table splitter

Distmon thread Table splitter ZMD_TRXXXX stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_TRXXXX.log

INFO: 2014-06-21 11:32:07

Execution of 'Table splitter ZMD_INVDETL_0016' started with: 'R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_INVDETL_0016.STR -table ZMD_INVDETL_0016%80 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_INVDETL_0016.WHR -check_utf8 -l tableSplitter.ZMD_INVDETL_0016.log '.

Regards,

Sandeep Singh

[indrajith_v]

Hello Sandeep,

have you manged to solve this problem ??? please Help.

We are also facing the same issue.

Please look in to this

Thanks in advance.

[former_member182657]

Hi,

Return code 255 relates with R3load.If possible try to upgrade kernel and recheck.

tableSplitter.ZMD_TRXHISTORY.log  failed with return code 255'.

Also enclose distribution_monitor_prepare.log and tableSplitter.ZMD_BIDINF.log for analysis.

Regards,

Gaurav

[Former Member]

shp02cnc:cmpadm 85> cat export_monitor_cmd.properties

### Export Monitor options

## Operating mode

server

net

# Generation of task files

tskFiles=yes

# Inclusion of extent files

extFiles=no

# Additional R3load arguments for TASK phase

taskArgs=

# Additional R3load arguments for LOAD phase

loadArgs=

# Export order

orderBy=packageOrder.properties

# Monitor timeout in seconds

monitorTimeout=30

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

exportDirs=/export/SapMigration/DISTMON/DEEP/shp02cnc_DATA

# Installation direcotry

installDir=/export/SapMigration/DISTMON/DEEP/exportInstallDir

# Optional path to R3load executable

r3loadExe=/sapmnt/CMP/exe/R3load

# Number of parallel export jobs

expJobNum=4

jobNum=4

[Former Member]

Hi Gaurav,

shp02cnc:cmpadm 89> cat tableSplitter.ZMD_TRXHISTORY.log

/usr/sap/CMP/SYS/exe/run/R3ta: START OF LOG: Tue Jun 24 04:27:35 2014

/usr/sap/CMP/SYS/exe/run/R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_TRXHISTORY.STR -table ZMD_TRXHISTORY%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_TRXHISTORY.WHR -check_utf8 -l tableSplitter.ZMD_TRXHISTORY.log

ERROR: could not set DBSL_IMP_FUNS

(rc = 20)

/usr/sap/CMP/SYS/exe/run/R3ta: END OF LOG: Tue Jun 24 04:27:35 2014

/usr/sap/CMP/SYS/exe/run/R3ta: START OF LOG: Tue Jun 24 06:00:56 2014

/usr/sap/CMP/SYS/exe/run/R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_TRXHISTORY.STR -table ZMD_TRXHISTORY%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_TRXHISTORY.WHR -check_utf8 -l tableSplitter.ZMD_TRXHISTORY.log

ERROR: could not set DBSL_IMP_FUNS

(rc = 20)

/usr/sap/CMP/SYS/exe/run/R3ta: END OF LOG: Tue Jun 24 06:00:56 2014

Regards,

Sandeep Singh

[former_member182657]

Hi Sandeep,

ERROR: could not set DBSL_IMP_FUNS

Could you check availability of R3ta under kernel directory ? If not try to upgrade kernel.

Regards,

Gaurav

[divyanshu_srivastava3]

DBSL update is one good option with R3*.exe files.

[Former Member]

Hi,

As suggested above i have added the latest SBP and upgraded the oralce client version.

uodated Rzszchk R3load etc still the same issue with different error.

2014-06-23 17:52:18 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_TRXHISTORY.STR -table ZMD_TRXHISTORY%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_TRXHISTORY.WHR -check_utf8 -l tableSplitter.ZMD_TRXHISTORY.log  failed with return code 255'.

Please check 'tableSplitter.ZMD_TRXHISTORY.log'.

2014-06-23 17:52:18 Distmon thread Table splitter ZMD_TRXHISTORY stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_TRXHISTORY.log

2014-06-23 17:52:18 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_BIDINF.STR -table ZMD_BIDINF%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_BIDINF.WHR -check_utf8 -l tableSplitter.ZMD_BIDINF.log  failed with return code 255'.

Please check 'tableSplitter.ZMD_BIDINF.log'.

2014-06-23 17:52:18 Distmon thread Table splitter ZMD_BIDINF stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_BIDINF.log

2014-06-23 17:52:18 Execution of 2 threads aborted with error.

2014-06-23 17:52:18 Distribution Monitor stopped in operation:

Preparation -> Parallel table splitting

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

distribution_monitor_prepare.log

INFO: 2014-06-23 17:52:18

stderr output of Table splitter ZMD_TRXHISTORY:

Could not open the ICU common library.

   The following files must be in the path described by

   the environment variable "LD_LIBRARY_PATH":

   libicuuc.sl.34, libicudata.sl.34, libicui18n.sl.34 [nlsui0.c 1544] pid = 18831

LD_LIBRARY_PATH is currently set to <not set>  [nlsui0.c 1550] pid = 18831

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.TableSplitTool run

Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_TRXHISTORY.STR STMON/DEEP/COMMON/R3ta/ZMD_TRXHISTORY.WHR -check_utf8 -l tableSplitter.ZMD_TRXHISTORY.log  failed with retu

Please check 'tableSplitter.ZMD_TRXHISTORY.log'.

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.TableSplitTool run

Call stack:

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.TableSplitTool.runImpl(Unknown Source)

com.sap.inst.distmon.DistMonTool.run(Unknown Source)

com.sap.inst.distmon.DistMonToolThread.run(Unknown Source)

java.lang.Thread.run(Thread.java:595)

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splittingplitter

Distmon thread Table splitter ZMD_TRXHISTORY stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_TRXHISTORY.log

INFO: 2014-06-23 17:52:18

Execution of process 'Table splitter ZMD_BIDINF' finished.

INFO: 2014-06-23 17:52:18

stderr output of Table splitter ZMD_BIDINF:

Could not open the ICU common library.

   The following files must be in the path described by

   the environment variable "LD_LIBRARY_PATH":

   libicuuc.sl.34, libicudata.sl.34, libicui18n.sl.34 [nlsui0.c 1544] pid = 18830

LD_LIBRARY_PATH is currently set to <not set>  [nlsui0.c 1550] pid = 18830

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.TableSplitTool run

Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_BIDINF.STR -tabEP/COMMON/R3ta/ZMD_BIDINF.WHR -check_utf8 -l tableSplitter.ZMD_BIDINF.log  failed with return code 255'.

Please check 'tableSplitter.ZMD_BIDINF.log'.

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.TableSplitTool run

Call stack:

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.TableSplitTool.runImpl(Unknown Source)

com.sap.inst.distmon.DistMonTool.run(Unknown Source)

com.sap.inst.distmon.DistMonToolThread.run(Unknown Source)

java.lang.Thread.run(Thread.java:595)

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splittingter

Distmon thread Table splitter ZMD_BIDINF stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_BIDINF.log

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.DistributionMonitor Parallel table splitting run

Execution of 2 threads aborted with error.

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splitting

Distribution Monitor stopped in operation:

Preparation -> Parallel table splitting

1 errors and 0 warnings occured

Regards,

Sandeep singh

[divyanshu_srivastava3]

Hi Sandeep,

Can you check the value of env var LD_LIBRARY_PATH from the terminal you are running the tool.

Place these libicuuc.sl.34, libicudata.sl.34, libicui18n.sl.34 files at LD_LIBRARY_PATH.

Regards,

Divyanshu

[former_member182657]

Hi,

Kindly share the value for environment variable LD_LIBRARY_PATH.

Regards,

Gaurav

[Former Member]

Hi Diyanshu,

I have set the env...still the same erro on tables.

INFO: 2014-06-24 04:27:35

Execution of 'Table splitter ZMD_BIDINF' started with: 'R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_BIDINF.STR -table ZMD_BIDINF%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_BIDINF.WHR -check_utf8 -l tableSplitter.ZMD_BIDINF.log '.

INFO: 2014-06-24 04:27:35

Execution of process 'Table splitter ZMD_TRXHISTORY' finished.

ERROR: 2014-06-24 04:27:35 com.sap.inst.distmon.TableSplitTool run

Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_TRXHISTORY.STR -table ZMD_TRXHISTORY%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_TRXHISTORY.WHR -check_utf8 -l tableSplitter.ZMD_TRXHISTORY.log  failed with return code 1'.

Please check 'tableSplitter.ZMD_TRXHISTORY.log'.

ERROR: 2014-06-24 04:27:35 com.sap.inst.distmon.TableSplitTool run

Call stack:

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.TableSplitTool.runImpl(Unknown Source)

com.sap.inst.distmon.DistMonTool.run(Unknown Source)

com.sap.inst.distmon.DistMonToolThread.run(Unknown Source)

java.lang.Thread.run(Thread.java:595)

ERROR: 2014-06-24 04:27:35 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splitting -> Thread Table splitter ZMD_TRXHISTORY -> Table splitter

Distmon thread Table splitter ZMD_TRXHISTORY stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_TRXHISTORY.log

INFO: 2014-06-24 04:27:35

Execution of process 'Table splitter ZMD_BIDINF' finished.

ERROR: 2014-06-24 04:27:35 com.sap.inst.distmon.TableSplitTool run

Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_BIDINF.STR -table ZMD_BIDINF%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_BIDINF.WHR -check_utf8 -l tableSplitter.ZMD_BIDINF.log  failed with return code 1'.

Please check 'tableSplitter.ZMD_BIDINF.log'.

ERROR: 2014-06-24 04:27:35 com.sap.inst.distmon.TableSplitTool run

Call stack:

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.TableSplitTool.runImpl(Unknown Source)

com.sap.inst.distmon.DistMonTool.run(Unknown Source)

com.sap.inst.distmon.DistMonToolThread.run(Unknown Source)

java.lang.Thread.run(Thread.java:595)

ERROR: 2014-06-24 04:27:35 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splitting -> Thread Table splitter ZMD_BIDINF -> Table splitter

Distmon thread Table splitter ZMD_BIDINF stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_BIDINF.log

ERROR: 2014-06-24 04:27:35 com.sap.inst.distmon.DistributionMonitor Parallel table splitting run

Execution of 2 threads aborted with error.

ERROR: 2014-06-24 04:27:35 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splitting

Distribution Monitor stopped in operation:

Preparation -> Parallel table splitting

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Regards,

Sandeep Singh

[Former Member]

Hi Gaurav

echo $LD_LIBRARY_PATH

/sapmnt/CMP/exe/

Regards,

Sandeep Singh

[divyanshu_srivastava3]

Hi Sandeep,

What is the JRE/JVM version that this tool is using ?

Regards,

Divyanshu

[divyanshu_srivastava3]

Also, Can you share 'export_monitor_cmd.properties'

[Former Member]

Hi Divyanshu,

#stribution Monitor options

#

#

#

# Main Options

#

#

# Communication directory shared between all hosts

commDir=/export/SapMigration/DISTMON/DEEP/COMMON

Regards,

Sandeep

[former_member182657]

Hi Sandeep,

Could you please share the oracle client version as i suggested you try to upgrade it up to the latest patch available.

After that retry the procedure.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

The client version is 11.2.

Regards,

Sandeep Singh

[Former Member]

Hi,

As suggested above i have added the latest SBP and upgraded the oralce client version.

uodated Rzszchk R3load etc still the same issue with different error.

2014-06-23 17:52:18 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_TRXHISTORY.STR -table ZMD_TRXHISTORY%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_TRXHISTORY.WHR -check_utf8 -l tableSplitter.ZMD_TRXHISTORY.log  failed with return code 255'.

Please check 'tableSplitter.ZMD_TRXHISTORY.log'.

2014-06-23 17:52:18 Distmon thread Table splitter ZMD_TRXHISTORY stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_TRXHISTORY.log

2014-06-23 17:52:18 Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_BIDINF.STR -table ZMD_BIDINF%50 -o /export/SapMigration/DISTMON/DEEP/COMMON/R3ta/ZMD_BIDINF.WHR -check_utf8 -l tableSplitter.ZMD_BIDINF.log  failed with return code 255'.

Please check 'tableSplitter.ZMD_BIDINF.log'.

2014-06-23 17:52:18 Distmon thread Table splitter ZMD_BIDINF stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_BIDINF.log

2014-06-23 17:52:18 Execution of 2 threads aborted with error.

2014-06-23 17:52:18 Distribution Monitor stopped in operation:

Preparation -> Parallel table splitting

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

distribution_monitor_prepare.log

INFO: 2014-06-23 17:52:18

stderr output of Table splitter ZMD_TRXHISTORY:

Could not open the ICU common library.

   The following files must be in the path described by

   the environment variable "LD_LIBRARY_PATH":

   libicuuc.sl.34, libicudata.sl.34, libicui18n.sl.34 [nlsui0.c 1544] pid = 18831

LD_LIBRARY_PATH is currently set to <not set>  [nlsui0.c 1550] pid = 18831

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.TableSplitTool run

Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_TRXHISTORY.STR STMON/DEEP/COMMON/R3ta/ZMD_TRXHISTORY.WHR -check_utf8 -l tableSplitter.ZMD_TRXHISTORY.log  failed with retu

Please check 'tableSplitter.ZMD_TRXHISTORY.log'.

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.TableSplitTool run

Call stack:

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.TableSplitTool.runImpl(Unknown Source)

com.sap.inst.distmon.DistMonTool.run(Unknown Source)

com.sap.inst.distmon.DistMonToolThread.run(Unknown Source)

java.lang.Thread.run(Thread.java:595)

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splittingplitter

Distmon thread Table splitter ZMD_TRXHISTORY stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_TRXHISTORY.log

INFO: 2014-06-23 17:52:18

Execution of process 'Table splitter ZMD_BIDINF' finished.

INFO: 2014-06-23 17:52:18

stderr output of Table splitter ZMD_BIDINF:

Could not open the ICU common library.

   The following files must be in the path described by

   the environment variable "LD_LIBRARY_PATH":

   libicuuc.sl.34, libicudata.sl.34, libicui18n.sl.34 [nlsui0.c 1544] pid = 18830

LD_LIBRARY_PATH is currently set to <not set>  [nlsui0.c 1550] pid = 18830

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.TableSplitTool run

Execution of 'Table splitter' failed.

Reason: 'java.lang.Exception: R3ta -f /export/SapMigration/DISTMON/DEEP/COMMON/PkgSplit/ZMD_BIDINF.STR -tabEP/COMMON/R3ta/ZMD_BIDINF.WHR -check_utf8 -l tableSplitter.ZMD_BIDINF.log  failed with return code 255'.

Please check 'tableSplitter.ZMD_BIDINF.log'.

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.TableSplitTool run

Call stack:

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.DistMonUtil.startProcess(Unknown Source)

com.sap.inst.distmon.TableSplitTool.runImpl(Unknown Source)

com.sap.inst.distmon.DistMonTool.run(Unknown Source)

com.sap.inst.distmon.DistMonToolThread.run(Unknown Source)

java.lang.Thread.run(Thread.java:595)

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splittingter

Distmon thread Table splitter ZMD_BIDINF stopped in operation:

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

1 errors and 0 warnings occured

Please check: distribution_monitor_prepare.log

Please check: tableSplitter.ZMD_BIDINF.log

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.DistributionMonitor Parallel table splitting run

Execution of 2 threads aborted with error.

ERROR: 2014-06-23 17:52:18 com.sap.inst.distmon.DistributionMonitor Preparation -> Parallel table splitting

Distribution Monitor stopped in operation:

Preparation -> Parallel table splitting

1 errors and 0 warnings occured

Regards,

Sandeep singh

[indrajith_v]

Hello Rana,

please help with

thanks in advance.

[former_member188883]

Hi Sandeep,

Please attach TableSplitter.ZMD_TRXXXX.log

Regards,

Deepak Kori

[Former Member]

Hi Deepak

Please find the log

root@shp2cn:DISTMON/DEEP> cat tableSplitter.ZMD_TRXXXXX.log

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

DbSl Trace: Error 1455 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1455 occurred when executing SQL stmt (parse error offset=0)

Regards,

Sandeep Singh

[former_member182657]

Hi Sandeep,

Kindly follow SAP note  1609745 - SMIGR_CREATE_DDL: Termination with very large tables

Also please confirm oracle client version,if possible try to upgrade client version.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

Its not a BW system.

Regards,

Sandeep Singh

[Sriram2009]

Hi Sandeep

For System migration , Are you using SAPINST or SWPM ? and also you current SAP system version details?

BR

SS

[Former Member]

Hi Sriram,

NW 701...using SWPM.

Regards,

Sandeep Singh

[Sriram2009]

Hi Sandeep

Could you update the latest version R3trans , R3load  or is it possible to do the latest kernel upgrade and then check

BR

SS

[former_member188883]

Hi Sandeep,

Please share the following

1) Oracle database version on source

2) SAP kernel version on source

3) SAP basis level on source

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

The please find the below information as suggested.

1) Oracle database version on source  -> 11.2.0.2

2) SAP kernel version on source  -> 701_REL(158) . i have applied latest version of R3ctl , R3ta, R3load etc

3) SAP basis level on source -> 03.

Regards,

Sandeep Singh

[indrajith_v]

Helllo Deepak,

please suggest anything with the thread -->
ERROR in TABLE SPLITTING&amp;nbsp; when using the D... | SCN

Thanks in advance.