oracle.apps.fnd.security.LeakedConnectionException When Trying To Access csfw.jsp And Other Wireless Field Service Pages

(Doc ID 2121105.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

When trying to access the csfw.jsp [Wireless Field Service pages], there are many leaked Connection Exceptions getting recorded in the OACore and after some time the OACore is crashing.

A small snippet of the exception details are as below:

oracle.apps.fnd.security.LeakedConnectionException 211, 0x7ee5d0, 2016-02-22+10:16:38.610+0300, Thread[AJPRequestHandler-HTTPThreadGroup-217,5,HTTPThreadGroup]
at _csfwSaveNote._jspService(_csfwSaveNote.java:950)
at oracle.apps.csf.wireless.server.MCSProcessor.process(MCSProcessor.java:137)
at _csfw._jspService(_csfw.java:200)

oracle.apps.fnd.security.LeakedConnectionException 228, 0x14f3509, 2016-02-22+10:24:22.237+0300, Thread[AJPRequestHandler-HTTPThreadGroup-217,5,HTTPThreadGroup]
at oracle.apps.csf.wireless.sql.CSFDescriptiveFlexfield.setWhereBlock(CSFDescriptiveFlexfield.java:380)
at _csfwResUpd._jspService(_csfwResUpd.java:2418)
at oracle.apps.csf.wireless.server.MCSProcessor.process(MCSProcessor.java:137)
at _csfw._jspService(_csfw.java:200)

oracle.apps.fnd.security.LeakedConnectionException 6, 0x1e64d34, 2016-02-19+12:30:25.718+0300, Thread[AJPRequestHandler-HTTPThreadGroup-17,5,HTTPThreadGroup]
at _csfwmenu._jspService(_csfwmenu.java:948)
at oracle.apps.csf.wireless.server.MCSProcessor.process(MCSProcessor.java:137)
at _csfw._jspService(_csfw.java:200)

oracle.apps.fnd.security.LeakedConnectionException 248, 0xf21093, 2016-02-22+10:27:27.781+0300, Thread[AJPRequestHandler-HTTPThreadGroup-197,5,HTTPThreadGroup]
at _csfwtinf._jspService(_csfwtinf.java:2912)

oracle.apps.fnd.security.LeakedConnectionException 6, 0x156f055, 2016-02-19+11:47:01.002+0300, Thread[AJPRequestHandler-HTTPThreadGroup-8,5,HTTPThreadGroup]
at _jtfwcerr._jspService(_jtfwcerr.java:352)
at _csfwTodayCache._jspService(_csfwTodayCache.java:3966)

oracle.apps.fnd.security.LeakedConnectionException 185, 0xdc7261, 2016-02-21+19:31:02.346+0300, Thread[AJPRequestHandler-HTTPThreadGroup-219,5,HTTPThreadGroup]
at oracle.apps.csf.wireless.sql.CSFSegment.setValue(CSFSegment.java:269)
at _csfwUpdateDFF._jspService(_csfwUpdateDFF.java:2016)
at _csfw._jspService(_csfw.java:200)

oracle.apps.fnd.security.LeakedConnectionException 207, 0x195708c, 2016-02-21+15:04:35.072+0300, Thread[AJPRequestHandler-HTTPThreadGroup-162,5,HTTPThreadGroup]
at oracle.apps.fnd.security.CallStack.getInstance(CallStack.java:123)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:997)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:977)

oracle.apps.fnd.security.LeakedConnectionException 63, 0x6d9ce9, 2016-02-21+05:47:38.058+0300, Thread[AJPRequestHandler-HTTPThreadGroup-122,5,HTTPThreadGroup]
at _OA._jspService(_OA.java:212)
at _RF._jspService(_RF.java:225)
....

 

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