Thursday 18 October 2012

Issue starting 10g Forms and reports server



Error:

 Ping URL for proc: 887947305 failed while pinging url:/reports/rwservlet/pingserver?start=auto
12/11/01 08:18:46 [4] [libopmnoc4j] Process Ping Failed: OC4J~OC4J_BI_Forms~default_island~1 (887947305:8511)
12/11/01 08:19:10 [2] [libopmnoc4j] AJP13: Receiving response code: 500 while configured success code is: 200
12/11/01 08:19:10 [2] [libopmnoc4j] Ping URL for proc: 887947305 failed while pinging url:/reports/rwservlet/pingserver?start=auto

Search String

REP-56105

tail –f OC4J~OC4J_BI_Forms~default_island~1

ConfigFileName: /u01/oracle/product/ais10g/forms90/server/forms/server/formsweb.cfg
REP-56105: Engine rwEng-0 died with error

SOLUTION

Bug no: 3557723


Work Around:

Disable pingserver command in $ORACLE_HOME/opmn/conf/opmn.xml

- Take the backup of opmn.xml file
@   cd $ORACLE_HOME/opmn/conf
@  cp opmn.xml opmn.xml.PINGAUTO
@ - Open file opmn.xml
@ - Take out the following lines from opmn.xml
@   < category id="urlping-parameters">
@      < data id="/reports/rwservlet/pingserver?start=auto" value="200"/>
@   < /category>
@ - Bounce the opmn
@   cd $ORACLE_HOME/opmn/bin
@  ./opmnctl stopall     ;        ./opmnctl startall

Error: CACHE mismatching

SOLUTION: 

Also Check for the domain name in /u01/oracle/product/ais10g/webcache
Webcache.xml ----change the domain name.

Tuesday 9 October 2012

Unable to view new responsibilities added to an User.


Issue: unable to view new responsibilities as added to existing users or re-activate end dated responsibilities. 



Recent Changes: Applied a new Patch using adpatch.


Solution:

1. 429852.1 - Reactivated User Does Not See Responsibilities - This step is where we applied patch 6008417.

2. Workaround
2.1. Stop and restart the "Workflow Java Deferred Agent Listener" in OAM
2.2. This will clear the events in Ready status. To verify this, run:

select
decode(state,
0, '0 (Ready)',
1, '1 (Delayed)',
2, '2 (Retained)',
3, '3 (Exception)',
to_char(state|| ' (Other)')) state,
count(*) how_many
from wf_java_deferred
group by state

The number of 'Ready' needs to get to 0 before you continue.
2.3. Login to E-Business as SYSADMIN and navigate to Workflow Administrator Web Application, Business Event
Search for oracle.apps.fnd.wf.ds.userRole.updated.
Then click on clock symbol under the Subscription column.
Disable the AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments subscription
2.4. Stop and restart the Workflow Agent Listener Service

3. Follow the steps on note 464445.1 - specifically the step to Run the Directory Services Validate User/Role concurrent request.