Solved: Re: Exception Analysis/Understanding Required

Babar_Qayyum · ‎09 Feb 2021

Dear All,

There is an exception java.lang.ArrayIndexOutOfBoundsException with the message 'null'.

What is this exception?
What can be the business impact of this exception?
Is this because of the WAS?
Is this because of the Oracle?
Is this because of the driver?

Regards,

Babar

bobby_crumley · ‎09 Feb 2021

Hi Babar-

I don't have a ton of context with this, but all I can tell is that almost all of the contribution time comes from the execution of the statement (which is to be expected) and/or the underlying components you have blocked out. You need to look at the extra contributing factors beyond just this one screenshot, but it does appear to be coming from the prepared statements in the web server.

-Bob C

Babar_Qayyum · ‎10 Feb 2021

Hello @Bob C.

Thank you for your comments. The following is the exception stacktrace for your analysis:

oracle.jdbc.driver.DynamicByteArray.put(DynamicByteArray.java:519)
oracle.jdbc.driver.ByteArray.put(ByteArray.java:234)
oracle.jdbc.driver.T2CPreparedStatement.updateData(T2CPreparedStatement.java:2332)
oracle.jdbc.driver.T2CStatement.t2cDefineExecuteFetch(T2CStatement.java)
oracle.jdbc.driver.T2CPreparedStatement.doDefineExecuteFetch(T2CPreparedStatement.java:1578)
oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:938)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:957)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1221)
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:739)
com.ibm.ws.session.store.db.DatabaseHashMap.isPresent(DatabaseHashMap.java:1886)
com.ibm.ws.session.store.common.BackedStore.isPresentInExternalStore(BackedStore.java:83)
com.ibm.ws.session.store.memory.MemoryStore.idExists(MemoryStore.java:243)
com.ibm.ws.session.SessionManager.createISession(SessionManager.java:243)
com.ibm.ws.session.SessionManager.createSession(SessionManager.java:736)
com.ibm.ws.session.SessionContext.getIHttpSession(SessionContext.java:506)
com.ibm.ws.session.SessionContext.getIHttpSession(SessionContext.java:427)
com.ibm.ws.webcontainer.srt.SRTRequestContext.getSession(SRTRequestContext.java:113)
com.ibm.ws.webcontainer.srt.SRTServletRequest.getSession(SRTServletRequest.java:2212)
com.ibm.ws.webcontainer.srt.SRTServletRequest.getSession(SRTServletRequest.java:2196)
org.springframework.web.util.WebUtils.setSessionAttribute(WebUtils.java:338)
org.springframework.web.servlet.i18n.SessionLocaleResolver.setLocaleContext(SessionLocaleResolver.java:113)
org.springframework.web.servlet.i18n.AbstractLocaleContextResolver.setLocale(AbstractLocaleContextResolver.java:66)
org.springframework.web.servlet.i18n.LocaleChangeInterceptor.preHandle(LocaleChangeInterceptor.java:73)
com.ejada.ecorp.sessionmgmt.ECorpLocaleChangeInterceptor.preHandle(ECorpLocaleChangeInterceptor.java:39)
org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:134)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:954)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1233)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:782)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
com.ejada.ecorp.sessionmgmt.serverrequests.ServerRequestParametersFilter.doFilter(ServerRequestParametersFilter.java:90)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
com.ejada.ecorp.sessionmgmt.DenyJSPAccessFilter.doFilter(DenyJSPAccessFilter.java:72)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
com.ejada.ecorp.sessionmgmt.DenyWebResourcesAccessFilter.doFilter(DenyWebResourcesAccessFilter.java:55)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107)
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:949)
com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:213)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:558)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:608)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:985)
com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1074)
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)

Regards,

Babar

julien_duhamel1 · ‎18 Mar 2021

Hello Babar,

You don't have any exception from the service who call Oracle?

regards

Julien D.