Exception Analysis/Understanding Required

Babar_Qayyum — Tue, 09 Feb 2021 13:22:59 GMT

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

Re: Exception Analysis/Understanding Required

bobby_crumley — Tue, 09 Feb 2021 16:29:50 GMT

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

Re: Exception Analysis/Understanding Required

Babar_Qayyum — Wed, 10 Feb 2021 06:09:02 GMT

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

Re: Exception Analysis/Understanding Required

julien_duhamel1 — Thu, 18 Mar 2021 10:19:34 GMT

Hello Babar,

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

regards

Julien D.

topic Re: Exception Analysis/Understanding Required in Real User Monitoring

Exception Analysis/Understanding Required

Re: Exception Analysis/Understanding Required

Re: Exception Analysis/Understanding Required

Re: Exception Analysis/Understanding Required