09 Feb 2021 01:22 PM
Dear All,
There is an exception java.lang.ArrayIndexOutOfBoundsException with the message 'null'.
Regards,
Babar
Solved! Go to Solution.
09 Feb 2021 04:29 PM
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
10 Feb 2021 06:09 AM
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
18 Mar 2021 10:19 AM
Hello Babar,
You don't have any exception from the service who call Oracle?
regards
Julien D.