After update from 7507 to 7508 view request crash
Dears,
Some one have sucessful update process from 7507 to 7508 update. After we did it some request view result in the following:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: java.sql.SQLException: Error during query: Unexpected Exception: java.lang.ArrayIndexOutOfBoundsException message given: 13616 Nested Stack Trace: ** BEGIN NESTED EXCEPTION ** java.lang.ArrayIndexOutOfBoundsException MESSAGE: 13616 STACKTRACE: java.lang.ArrayIndexOutOfBoundsException: 13616 at com.mysql.jdbc.Field.<init>(Field.java:144) at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:447) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:277) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1247) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161) at com.mysql.jdbc.Connection.execSQL(Connection.java:2084) at com.mysql.jdbc.Connection.execSQL(Connection.java:2046) at com.mysql.jdbc.Connection.execSQL(Connection.java:2027) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:519) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:425) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:766) at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:145) at com.adventnet.db.api.RelationalAPI.createStatement(RelationalAPI.java:952) at com.adventnet.db.api.RelationalAPI.createStatement(RelationalAPI.java:947) at com.adventnet.db.api.RelationalAPI.executeQuery(RelationalAPI.java:750) at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:89) at com.adventnet.persistence.DataAccess.get(DataAccess.java:1154) at com.adventnet.persistence.DataAccess.get(DataAccess.java:1144) at com.adventnet.servicedesk.utils.DataAccessUtil.get(DataAccessUtil.java:172) at com.adventnet.servicedesk.utils.ResourcesUtil.getUserLocale(ResourcesUtil.java:205) at com.adventnet.servicedesk.utils.ResourcesUtil.getLocaleFromDB(ResourcesUtil.java:423) at com.adventnet.servicedesk.utils.ResourcesUtil.getLocale(ResourcesUtil.java:225) at com.adventnet.servicedesk.utils.ResourcesUtil.getResourceBundle(ResourcesUtil.java:238) at com.adventnet.servicedesk.utils.SDResourceBundle.<init>(SDResourceBundle.java:30) at org.apache.jsp.workorder.WorkOrder_jsp._jspService(WorkOrder_jsp.java:250) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at com.adventnet.authentication.CredentialAssociation.invoke(CredentialAssociation.java:75) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at com.adventnet.client.util.LoginParameters.invoke(LoginParameters.java:53) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at com.adventnet.servicedesk.tools.AuthenticateNtlm.invoke(AuthenticateNtlm.java:284) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:444) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758) org.apache.jsp.workorder.WorkOrder_jsp._jspService(WorkOrder_jsp.java:4955) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) javax.servlet.http.HttpServlet.service(HttpServlet.java:697) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:90) com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
com.adventnet.persistence.DataAccessException: java.sql.SQLException: Error during query: Unexpected Exception: java.lang.ArrayIndexOutOfBoundsException message given: 13616 Nested Stack Trace: ** BEGIN NESTED EXCEPTION ** java.lang.ArrayIndexOutOfBoundsException MESSAGE: 13616 STACKTRACE: java.lang.ArrayIndexOutOfBoundsException: 13616 at com.mysql.jdbc.Field.<init>(Field.java:144) at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:447) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:277) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1247) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1161) at com.mysql.jdbc.Connection.execSQL(Connection.java:2084) at com.mysql.jdbc.Connection.execSQL(Connection.java:2046) at com.mysql.jdbc.Connection.execSQL(Connection.java:2027) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:519) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:425) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:766) at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:145) at com.adventnet.db.api.RelationalAPI.createStatement(RelationalAPI.java:952) at com.adventnet.db.api.RelationalAPI.createStatement(RelationalAPI.java:947) at com.adventnet.db.api.RelationalAPI.executeQuery(RelationalAPI.java:750) at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:89) at com.adventnet.persistence.DataAccess.get(DataAccess.java:1154) at com.adventnet.persistence.DataAccess.get(DataAccess.java:1144) at com.adventnet.servicedesk.utils.DataAccessUtil.get(DataAccessUtil.java:172) at com.adventnet.servicedesk.utils.ResourcesUtil.getUserLocale(ResourcesUtil.java:205) at com.adventnet.servicedesk.utils.ResourcesUtil.getLocaleFromDB(ResourcesUtil.java:423) at com.adventnet.servicedesk.utils.ResourcesUtil.getLocale(ResourcesUtil.java:225) at com.adventnet.servicedesk.utils.ResourcesUtil.getResourceBundle(ResourcesUtil.java:238) at com.adventnet.servicedesk.utils.SDResourceBundle.<init>(SDResourceBundle.java:30) at org.apache.jsp.workorder.WorkOrder_jsp._jspService(WorkOrder_jsp.java:250) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at com.adventnet.authentication.CredentialAssociation.invoke(CredentialAssociation.java:75) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at com.adventnet.client.util.LoginParameters.invoke(LoginParameters.java:53) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at com.adventnet.servicedesk.tools.AuthenticateNtlm.invoke(AuthenticateNtlm.java:284) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:444) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:102) com.adventnet.persistence.DataAccess.get(DataAccess.java:1154) com.adventnet.persistence.DataAccess.get(DataAccess.java:1144) com.adventnet.servicedesk.utils.DataAccessUtil.get(DataAccessUtil.java:172) com.adventnet.servicedesk.utils.ResourcesUtil.getUserLocale(ResourcesUtil.java:205) com.adventnet.servicedesk.utils.ResourcesUtil.getLocaleFromDB(ResourcesUtil.java:423) com.adventnet.servicedesk.utils.ResourcesUtil.getLocale(ResourcesUtil.java:225) com.adventnet.servicedesk.utils.ResourcesUtil.getResourceBundle(ResourcesUtil.java:238) com.adventnet.servicedesk.utils.SDResourceBundle.<init>(SDResourceBundle.java:30) org.apache.jsp.workorder.WorkOrder_jsp._jspService(WorkOrder_jsp.java:250) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069) org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) javax.servlet.http.HttpServlet.service(HttpServlet.java:697) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:90) com.adventnet.authentication.ContextChangeDetector.doFilter(ContextChangeDetector.java:112) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.