Thursday, 12 April 2018

All RDF Reports Running Forever With No Completion

Problem: I face one internal issue that in production instance , concurrent program are running from long time and are not getting completed.

Symptoms:
 All RDF reports like "ACTIVE USER" are running forever with no completion and no error in request/manager/internal manager log.

Submit Active Users with command line: CONCSUB

CONCSUB is a utility to submit the concurrent request from operating system level to run concurrent program, without having to log on to oracle applications.

$CONCSUB apps/<pass> SYSADMIN "System Administrator" SYSADMIN WAIT=Y CONCURRENT FND FNDSCURS PROGRAM_NAME='"Active Users"'

OR

$INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/apps mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132x66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace

Get error:
Environment:Environment java.lang.UnsatisfiedLinkError: Can't find library rwu
(librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin:/devp/oracle/apps
/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/tech_st/10.1.2/lib32:/devp
/oracle/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devp/oracle/apps/tech_st/10.1.2/jdk
/jre/bin:/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/
apps_st/appl/cz/12.0.0/bin:/devp/oracle/apps/tech_st/10.1.2/lib32:/devp/oracle/a
pps/tech_st/10.1.2/lib:/usr/dt/lib:/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin:
/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/apps_st/a
ppl/sht/12.0.0/lib:/usr/lib
Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: Can't find lib
rary rwu (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin:/devp/oracle/apps
/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/tech_st/10.1.2/lib32:/devp
/oracle/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devp/oracle/apps/tech_st/10.1.2/jdk
/jre/bin:/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/
apps_st/appl/cz/12.0.0/bin:/devp/oracle/apps/tech_st/10.1.2/lib32:/devp/oracle/a
pps/tech_st/10.1.2/lib:/usr/dt/lib:/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin:
/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/apps_st/a
ppl/sht/12.0.0/lib:/usr/lib
REP-50125: Caught exception: java.lang.reflect.InvocationTargetException

Error in ddr2.trc:

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-3000: Internal error starting Oracle Toolkit

Solution:

1. Check the E-Business (EBS) server environment DISPLAY as root user with commands: xhost + , xclock , echo $DISPLAY.
2. Change the DISPLAY setting in EBS context file to be value of step 1.
3. Retest the issue.

No comments:

Post a Comment