Wednesday, July 6, 2011

Workflow notification mailer gets down frequently. An unexpected RuntimeException or Throwable occurred -> java.lang.StackOverflowError

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    Workflow notification mailer gets down frequently. An unexpected RuntimeException or Throwable occurred -> java.lang.StackOverflowError

Symptoms:
The inbound processing is currently disabled and it is working fine. If the inbound processing enabled then it goes down frequently.

Workflow notification getting deactivated periodically.

 Inbound notification is not getting processed.

Log files:
Mailer log file:
---------------------

[May 16, 2009 4:49:41 PM GMT+04:00]:1242478181396:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1::-1:-1:UNEXPECTED:[SVC-GSM-WFMLRSVC-77086-10006 : oracle.apps.fnd.cp.gsc.Processor.run()]:An unexpected RuntimeException or Throwable occurred -> java.lang.StackOverflowError
[May 18, 2009 12:50:40 PM GMT+04:00]:1242636640373:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1::-1:ERROR:[SVC-GSM-WFMLRSVC-77269-10006 : oracle.apps.fnd.cp.gsc.Processor.performError(ProcessorException)]:Maximum number of errors have occurred for this processing thread.

FNDCPGSC73666.txt

## Detail 0 ##
JBO-30003: The application pool (dwcp1576oracle.apps.fnd.wf.worklist.server.WorklistAM) failed to checkout an application module due to the following exception:
oracle.jbo.JboException:JBO-29000:Unexpected exception caught: oracle.apps.fnd.framework.OAException, msg=Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = AppsConnectionManager.appsInitialize(int,int,int,int,Connection):-1,-1,-1,0,oracle.jdbc.driver.OracleConnection@1f11cbf; REASON = java.sql.SQLException: ORA-20001: Oracle error -6508: ORA-04061: existing state of package body "APPS.FND_PROFILE" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.FND_PROFILE"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_PROFILE"
has been detected in FND_GLOBAL.INITIALIZE.
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_GLOBAL", line 101
ORA-06512: at "APPS.FND_GLOBAL", line 1147
ORA-06512: at "APPS.FND_GLOBAL", line 620

Solution:
1.
Make sure the following patches are applied: Patch.6720592. And Patch.4747557 and Patch 6940918 and Patch 6218989 and Patch 6441940
Bug.6720592: NOTIFICATION MAILER TIME OUT MESSAGES,
NEEDS RESTART AND MAILER PERFORMANCE ISSUE AFTER RUP5
Oracle consolidated many workflow performance fixes into this one
patch 6720592 and it includes all the objects required so it can be applied to RUP4 and above.
It is considered kind of a baseline for workflow after RUP4 or RUP5 or RUP6.

Patch 4747557 :11.5.10.CU2: 4725438: STACKOVERFLOWEXCEPTION WHEN PROCESSING NOTIFICATION RESPONSES
Patch 6940918 1OFF:11IRU4:6511028: WORKFLOW CONTAINERS CONSUMING LOT OF TEMP TABLE SPACE
Patch 6218989 1OFF:6032403:ATG RUP5:11.5.10.2.5:SESSION TIMEOUT IN ICX_SESSIONS
Patch 6441940 MAILER WITH NON-NULL CORR ID DOES NOT PROCESS MESSAGES AFTER ATG PF.H RUP 5

2.
1. set the following Mailer parameters as recommended.

Processor Close on Read timeout -- Set it to Y
Inbound thread count -- Set it to 1.

2. Bounce the WF Notification Mailer.
3. Run the following Concurrent request:

Name: "Move messages from Exception to Normal Queue of Workflow Agent"
Parameter Value: WF_NOTIFICATION_OUT as the Agent Name.
4. Re-test the issue.

3. If the instance is not patches to ATG.RUP.5 or 6 then edit the workflow mailer service / click on the advanced button / increase the inbound and outbound threads to 2 / click next to complete and save and re test
References:
Bug.6720592: NOTIFICATION MAILER TIME OUT MESSAGES,
NEEDS RESTART AND MAILER PERFORMANCE ISSUE AFTER RUP5
Article-ID: Note 340402.1
Title: JMAILER java.lang.StackOverflowError - keeps crashing

Article-ID: Note 305574.1
Title: Mailer errors out with JAVA.LANG.STACKOVERFLOWERROR

Article-ID: Note 735812.1
Title: Performance Issues Caused by WF_EVENT_OJMSTEXT_QH.DEQUEUE
Procedure



      
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: