Workflow Mailer Stops Inbound Processing java.sql.SQLRecoverableException: IO Error: Connection reset

(Doc ID 1588126.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Oracle Workflow - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Mailer stops processing the response email in the IMAP inbox after the below error appears in the mailer log file and mails just sits in the inbox without processing.
When the mailer is bounced (stop/start),  the mail starts processing normally until the below error appears again the mailer log file:

GMT-04:00]:-1:-1:1:20420:SYSADMIN(0):374788987:Thread[outboundThreadGroup1,5,outboundThreadGroup]::88418:1359315158860:14:ERROR:[fnd.common.ErrorStack]:java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1025)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.fnd.security.AppsConnectionManager.appsInitialize(AppsConnectionManager.java:519)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:370)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1721)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2316)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2253)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2110)
at oracle.apps.fnd.common.AppsContext.getLocalJDBCConnection(AppsContext.java:2492)
at oracle.apps.fnd.common.AppsContext.getLocalJDBCConnection(AppsContext.java:2427)
at oracle.apps.fnd.common.AppsContext.getLocalJDBCConnection(AppsContext.java:2408)
at oracle.apps.fnd.common.WebAppsContext.decryptSessionCookie(WebAppsContext.java:4403)
at oracle.apps.fnd.common.WebAppsContext.disableUserSession(WebAppsContext.java:1923)
at oracle.apps.fnd.wf.common.WebSession.verifySession(WebSession.java:265)
at oracle.apps.fnd.wf.common.GenericHTMLContentParser.parse(GenericHTMLContentParser.java:894)
at oracle.apps.fnd.wf.mailer.NotificationFormatter.handleResEndTag(NotificationFormatter.java:3299)
at oracle.apps.fnd.wf.mailer.NotificationFormatter.endElement(NotificationFormatter.java:578)
at oracle.xml.parser.v2.XMLContentHandler.endElement(XMLContentHandler.java:210)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1318)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:336)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:303)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:319)
at oracle.apps.fnd.wf.mailer.NotificationFormatter.getFormattedMessages(NotificationFormatter.java:354)
at oracle.apps.fnd.wf.mailer.SMTPMessageHandler.prepareMessages(SMTPMessageHandler.java:77)
at oracle.apps.fnd.wf.mailer.SMTPOutboundProcessor.read(SMTPOutboundProcessor.java:796)
at oracle.apps.fnd.cp.gsc.SvcComponentProcessor.process(SvcComponentProcessor.java:604)
at oracle.apps.fnd.cp.gsc.Processor.run(Processor.java:283)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.net.SocketException: Connection reset


The same error is also seen in the oacorestd.err file:

java.sql.SQLRecoverableException: IO Error: Connection reset
       at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:650)
       at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3716)

 

Changes

 OS Install/Upgarde

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms