11i:- Issues after applying ATG RUP7 -- Part 2

• Issue:- After applying ATG RUP7 Users were not able to approve/reject workflows via email response.


• Cause:- Inbound mailer was unable to process user mails. The ATG RUP7 version of Workflow Mailer module has been having several issues concerning to the email responses. There were found multiple problems. I checked workflow logs to check as what is the cause behind it. Error i found in workflow log was:-

"[Apr 2, 2011 8:58:07 AM BST]:1301731087867:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1:XXXX:-1:-1:UNEXPECTED:[SVC-GSM-WFMLRSVC-109454-10004 : oracle.apps.fnd.wf.mailer.IMAPInboundProcessor.open()]:Unable to connect to mail store"

Error somewhat suggested as connectivity issue between mailer node and IMAP server. We checked the connectivity but their was no . Then we enabled workflow logs at STATEMENT level to reach error stack:- use below steps for doing same:-

1. Enable debug for Mailer Service Component :In OAM : Site Map / Notification Mailer / Edit / Advanced / Go to Step 2 / Change "Log Level" to "Statement"Apply change.


2. Bounce Mailer Container to force generation of a fresh log :In OAM : Site Map / Notification Mailer / Click on "Workflow Mailer Service" in "Container" columnOnce in containers page, select the "Workflow Mailer Service", then Stop. Refresh page until status becomes Deactivated. Then Start. Refresh page until status becomes Activated.


3. Use below script to identify log file name/path.:-

SELECT fcp.logfile_nameFROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp, fnd_lookups flkupWHERE concurrent_queue_name in ('WFMLRSVC')AND fcq.concurrent_queue_id = fcp.concurrent_queue_idAND fcq.application_id = fcp.queue_application_idAND flkup.lookup_code=fcp.process_status_codeAND lookup_type ='CP_PROCESS_STATUS_CODE'AND meaning='Active';.

On close investigation of log file we saw error like :- " [Apr 2, 2011 1:52:51 PM BST]:1301748771561:Thread[inboundThreadGroup1,5,inboundThreadGroup]:0:-1::XXXXX:-1:-1:UNEXPECTED:[SVC-GSM-WFMLRSVC-109510-10004 : oracle.apps.fnd.wf.mailer.IMAPResponseHandler.handleUnsolicited(EmailParser)]:Problem encounted when handling an unsolicited email -> java.io.IOException: Error in encoded stream, got 1".

• Resolution:- Searched error code on metalink and got a hit for noteid:- 974088.1 and their i found refrence for patch 9383048. Issue has been resolved by above patch.