My Oracle Support Banner

Intermittent "HTTP/1.1 500" errors along with "java.lang.NullPointerException: null Connection" errors when consuming web services (Doc ID 2791269.1)

Last updated on JULY 13, 2021

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Navigate to the Integrated SOA Gateway Responsibility >> Search >>  query up any Web Service >> Deploy the Web Service >> Assign Grants

The Web Service is initially consumed successfully but then after 'some' time it will fail with the following:

From the access.log

10.20.224.254 - - [17/Jun/2021:21:08:13 -0400] "POST /webservices/TransportAgentServer HTTP/1.0" 200 271
10.20.224.254 - - [17/Jun/2021:21:34:03 -0400] "POST /webservices/TransportAgentServer HTTP/1.0" 200 271
10.20.224.254 - - [17/Jun/2021:21:42:15 -0400] "POST /webservices/rest/regn.emp.transaction/get_transaction_ids/ HTTP/1.1" 500 833
10.20.224.254 - - [17/Jun/2021:21:42:29 -0400] "POST /webservices/rest/regn.emp.transaction/get_transaction_ids/ HTTP/1.1" 500 833

 

From the oafm_server log

[2021-06-18T09:46:45.776-04:00] [oafm_server2] [NOTIFICATION] [DFW-40101] [oracle.dfw.incident] [tid: [STANDBY].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <WLS Kernel>] [ecid: ] An incident has been signalled with the incident facts: [problemKey=DFW-99998 [java.lang.NullPointerException][oracle.apps.fnd.security.SessionManager.validateIcxLogin][oafm] incidentSource=SYSTEM incidentTime=Fri Jun 18 09:46:45 EDT 2021 errorMessage=DFW-99998 executionContextId= ]
[2021-06-18T09:46:47.220-04:00] [oafm_server2] [INCIDENT_ERROR] [DFW-40104] [oracle.dfw.incident] [tid: [STANDBY].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <WLS Kernel>] [errid: 11] [detailLoc: /xxx/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/oafm_server2/adr/diag/ofm/EBS_domain/oafm_server2/incident/incdir_11] [probKey: DFW-99998 [java.lang.NullPointerException][oracle.apps.fnd.security.SessionManager.validateIcxLogin][oafm]] incident 11 created with problem key "DFW-99998 [java.lang.NullPointerException][oracle.apps.fnd.security.SessionManager.validateIcxLogin][oafm]"
[2021-06-18T09:48:38.527-04:00] [oafm_server2] [ERROR] [] [com.xxxxx.impl.application.WebApplicationImpl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: ,0:1] [APP: oafm#1.0.0] The RuntimeException could not be mapped to a response, re-throwing to the HTTP container[[
oracle.apps.fnd.common.AppsException: java.lang.NullPointerException: null Connection
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1513)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:366)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(Unknown Source)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(Unknown Source)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(Unknown Source)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:611)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:588)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:542)
at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:980)
at oracle.apps.fnd.common.WebRequestUtil.createWebAppsContext(WebRequestUtil.java:978)
at oracle.apps.fnd.isg.app.ebs.rt.rest.provider.IsgRestFilter.initializeContext(IsgRestFilter.java:191)
at oracle.apps.fnd.isg.app.ebs.rt.rest.provider.IsgRestFilter.filter(IsgRestFilter.java:100)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:975)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:941)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:932)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:384)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:451)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:632)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

Changes

 New Installation using a firewall.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.