Errors/Workarounds-Applications

ERROR

All the concurrent managers are down with a status message: system hold, fix manager.

The administer Concurrent manager screen has Actual: 0 and Target: 1 for all managers.

SOLUTION

1. Make sure all application services are down.

2.Now, check the system profile Concurrent: GSM Enabled. This should be set to ‘Y’

3. Execute Sql Script given below by APPS User

• $FND_TOP/patch/115/sql/afdcm037.sql

4. Relink the below mentioned executables:

 adrelink.sh force=y “fnd FNDLIBR”

                                           adrelink.sh force=y “fnd FNDSM”

                                           adrelink.sh force=y “fnd FNDFS”

                                           adrelink.sh force=y “fnd FNDCRM”

5. Execute cmclean.sql to clean out the Concurrent Manager tables.

6. Start all the application services and restest the issue.

ERROR

RC-50221: Warning: Port pool not free in R12 while running adcfgclone.pl

I was getting the error below while running adcfgclone in R12.2 for run file system. While selecting the port pool value, i was getting the error saying one of the port pool is not free. upon checking the logs i found out OACORE (port no – 7214) is used by some processes which is causing this issue.

Error from the log :

Checking  WLS Admin Server Port on ahqtest:  Port Value = 7013
   WLS Admin Server Port available:  Port Value = 7013
 Checking  WLS OACORE Application Port on ahqtest:  Port Value = 7214
RC-50204: Error: – WLS OACORE Application Port in use: Port Value = 7214

SOLUTION

1.Find out the process using your port through the below given scripts. You need to supply port value as an input while executing the script.

• For Example#
• $./get_port_pid.sh 7214

Create Script As get_port_pid.sh:

#!/bin/bash

# Get the process which listens on port

# $1 is the port we are looking for

if [ $# -lt 1 ]
then
echo “Please provide a port number parameter for this script”
echo “e.g. $0 22”
exit
fi

echo “Greping for your port, please be patient (CTRL+C breaks) … “

for i in `ls /proc`
do
pfiles $i | grep AF_INET | grep $1
if [ $? -eq 0 ]
then
echo Is owned by pid $i
fi

2.Get the Process ID through above script and KILL it at OS level

3.Now, run adcfgclone.pl script.

ERROR

REP-50125: Caught exception: java.lang.reflect.InvocationTargetException

$ rwdiag.sh -findAll
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=/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/u01/apps/apps/tech_st/10.1.2/jdk/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/cz/12.0.0/bin:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/sht/12.0.0/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
Environment:getEnvironmentStrings 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=/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/u01/apps/apps/tech_st/10.1.2/jdk/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/cz/12.0.0/bin:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/sht/12.0.0/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
java.lang.reflect.InvocationTargetException
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

Broadcast mechanism used to locate servers
——————————————
Channel address = 228.5.6.7
Channel port = 14021

REP-50503 No server found in the network

$ rwrun help=yes
JVMCI200 – ERROR: User register saving is not enabled, Garbage Collection could be incorrect.
JVMCI200 – ERROR: because of this the JVM library is explicitly aborting the process
JVMCI200 – ERROR: You must either rebuild the executable using “-bM:UR”
JVMCI200 – ERROR: or run with “export LDR_CNTRL=USERREGS”
IOT/Abort trap(coredump)

$ $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=132×66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace
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=/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/cz/12.0.0/bin:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/sht/12.0.0/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
Environment:getEnvironmentStrings 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=/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/cz/12.0.0/bin:/u01/apps/apps/tech_st/10.1.2/lib32:/u01/apps/apps/tech_st/10.1.2/lib:/usr/dt/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/classic:/u01/apps/apps/apps_st/appl/sht/12.0.0/lib:/u01/apps/apps/tech_st/10.1.2/jdk/jre/lib/ppc:/u01/apps/apps/tech_st/10.1.2/jdk/jre/bin/sovvm:/usr/lib
REP-50125: Caught exception: java.lang.reflect.InvocationTargetException

SOLUTION 1

1. Take a backup and remove rwnetwork.conf from $ORACLE_HOME/reports/conf

• $ mv rwnetwork.conf rwnetwork.conf_orig

2. Stop/restart Applications tier.

3. You need to ensure rwnetwork.conf is created on its own. As rwnetwork.conf is removed , the system should generate new file automatically after the reports are run.

4.Reproduce the issue and check the following commands work fine to ensure the issue is resolved.

1. rwdiag.sh -findAll 
2. rwrun help=yes 
3. 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.outdesformat=$FND_TOP/reports/HPL pagesize=132×66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace

5.Run the Concurrent Request 

[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “0.5” entry_duration= “0.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]
Reference : Concurrent Processing – R12 Concurrent Requests Run Forever, rwrun Errors with REP-50125 (Doc ID 737445.1)

[edsanimate_end]

SOLUTION 2

If not resolved Follow below steps.

1. Relink the reports executables:

• cd $ORACLE_HOME/reports/lib32
• make -f ins_reports.mk install

[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “0.5” entry_duration= “0.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]

Reference : Concurrent Reports UnsatisfiedLinkError (Doc ID 849369.1)

[edsanimate_end]

ERROR

Running autoconfig on a cloned instance , the below mentioned error occurred:

PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 32

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
adadmprf.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.

AutoConfig could not successfully execute the following scripts:
    Directory: /u01/ebs/oracle/inst/apps/test_mine/admin/install
      adadmprf.sh             INSTE8_PRF         1 

SOLUTION

1.RUN the Following given Query with APPS user and notedown the SID from Output:

• select applications_system_name from applsys.fnd_product_groups; 

2.Update the entry with target instance name:

•  update applsys.fnd_product_groups set applications_system_name = ‘<target instance>’; 

3.Run autoconfig again.