R3load import of SAPVIEW failed with return code 2

[Former Member]

Hi,

I am using the distribution monitor 1.9.1 (DISTMON.SAR) downloaded from SAP note 855772. All other packages both exported and imported successfully, but when the final node attempts to import SAPVIEW, I receive an error from the distribution monitor (see below).:

DISTRIBUTION MONITOR OUTPUT:

2011-03-08 10:43:26: Starting R3load for SAPVIEW import. This will take some minutes.

2011-03-08 10:43:26 Execution of 'R3load Sapview' failed.

Reason: 'java.lang.Exception: /UCstage/binaries/exe_uc/R3load -ctf I /UCstage/ACUXSAPDB-C/DATA/SAPVIEW.STR /UCstage/ACUXSAPDB-C/importInstallDir/DDLORA.TPL /UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.TSK ORA -l /UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.log -o D -loadprocedure fast failed with return code 2'.

Please check '/UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.log'.

2011-03-08 10:43:26 Distribution Monitor stopped in operation:

import -> importSapview

1 errors and 1 warnings occured

Please check: distribution_monitor_import.log

Please check: /UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.log

exit 0

rm -f /tmp/distMon.24536

I have attempted to import multiple times, but continue to have same error. The file SAPVIEW.log file (referenced in the error) in the local importInstallDir does not exist (I double-checked that the filesystem exists, has adequate space, and that sidadm has read write privileges on the directory).

My java version is "1.5.0_28".

Perhaps the most telling error message comes from the distribution_monitor_import.log:

distribution_monitor_import.log:

ERROR: 2011-03-08 10:43:26 com.sap.inst.distmon.ImportTask checkSapview

Execution of 'R3load Sapview' failed.

Reason: 'java.lang.Exception: /UCstage/binaries/exe_uc/R3load -ctf I /UCstage/ACUXSAPDB-C/DATA/SAPVIEW.STR /UCstage/ACUXSAPDB-C/importInstallDir/DDLORA.TPL /UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.TSK ORA -l /UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.log -o D -loadprocedure fast failed with return code 2'.

Please check '/UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.log'.

ERROR: 2011-03-08 10:43:26 com.sap.inst.distmon.ImportTask checkSapview

Call stack:

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

com.sap.inst.distmon.ImportTask.importSapview(Unknown Source)

com.sap.inst.distmon.ImportTask.access$100(Unknown Source)

com.sap.inst.distmon.ImportTask$FinalImportTask.run(Unknown Source)

com.sap.inst.distmon.SignalFileListener.runIfLast(Unknown Source)

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

com.sap.inst.distmon.DistributionMonitor.startImportProcess(Unknown Source)

com.sap.inst.distmon.DistributionMonitor.startAppJob(Unknown Source)

com.sap.inst.lib.app.CommandLineApp.doMain(Unknown Source)

com.sap.inst.distmon.DistributionMonitor.main(Unknown Source)

ERROR: 2011-03-08 10:43:26 com.sap.inst.distmon.ImportTask import -> importSapview

Distribution Monitor stopped in operation:

import -> importSapview

1 errors and 1 warnings occured

Please check: distribution_monitor_import.log

Please check: /UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.log

Here is my R3load version (which was recently downloaded from R3load):

acuxsapdb-c:secadm 151% R3load -version

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

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

This is R3load version R7.00/V1.4 [UNICODE]

Compiled Oct 30 2010 01:51:01

Here is my environment:

USER=secadm

LOGNAME=secadm

HOME=/usr/sap/secadm

PATH=/usr/jdk/instances/jdk1.5.0/bin:/UCstage/binaries/exe_uc:/usr/bin:.:/usr/ccs/bin:/usr/ucb:/usr/local/bin

MAIL=/var/mail//secadm

SHELL=/bin/csh

TZ=US/Central

LC_CTYPE=en_US.ISO8859-1

LC_COLLATE=en_US.ISO8859-1

LC_TIME=en_US.ISO8859-1

LC_NUMERIC=en_US.ISO8859-1

LC_MONETARY=en_US.ISO8859-1

LC_MESSAGES=C

SSH_CLIENT=10.218.196.210 1363 22

SSH_CONNECTION=10.218.196.210 1363 10.78.58.241 22

SSH_TTY=/dev/pts/2

TERM=xterm

DISPLAY=localhost:11.0

PWD=/UCstage/ACUXSAPDB-C/distmon

SAPSYSTEMNAME=SEC

DIR_LIBRARY=/UCstage/binaries/exe_uc

LD_LIBRARY_PATH=/UCstage/binaries/exe_uc:/oracle/client/10x_64/instantclient

JAVA_HOME=/usr/jdk/instances/jdk1.5.0

THREAD=NOPS

dbms_type=ora

dbs_ora_tnsname=SEC_UC

dbs_ora_schema=SAPSR3

ORACLE_SID=SEC

DB_SID=SEC

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/trans

ORACLE_HOME=/oracle/SEC/112_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/SEC

Can you please help me identify the issue to get these views created in the target system?

Thanks,

Nick

[former_member709110]

Please check '/UCstage/ACUXSAPDB-C/importInstallDir/SAPVIEW.log'.

Check the log file for error message ...

Regards,

Neel

[Former Member]

Unfortunately, a SAPVIEW.log file is never generated. Please see above where I wrote: The file SAPVIEW.log file (referenced in the error) in the local importInstallDir does not exist (I double-checked that the filesystem exists, has adequate space, and that sidadm has read write privileges on the directory).

[nils_buerckel]

Hi Nick,

try the following work-around:

- Comment out (with #) the line "taskArgs= " in file "import_monitor_cmd.properties"

- Restart distmon Import

Best regards,

Nils Buerckel

SAP AG

[Former Member]

Your absolutely correct. Discovered the answer yesterday. Had the following parameter set in distribution_monitor_cmd.properties:

r3load.import.taskArgs=-loadprocedure fast

That parameter should only be set for 'r3load.import.loadArgs'. I commented out r3load.import.taskArgs and everything worked like a charm!

Thanks.