HTTP Status 500 – Internal Server Error


Type Exception Report

Message org.apache.ibatis.exceptions.PersistenceException:

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

javax.servlet.ServletException: org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECIMAL, DRIVER=4.25.13
### The error may exist in org/xenbase/gene/dto/gene-mapping.xml
### The error may involve org.xenbase.gene.dao.GeneDao.getXenopusChildGeneFeatures-Inline
### The error occurred while setting parameters
### SQL: SELECT f.*, fp.type_id as proptype_id, o.abbreviation organism_name     FROM feature f          JOIN feature_relationship fr ON fr.subject_id = f.feature_id          JOIN organism o ON o.organism_id = f.organism_id       LEFT JOIN featureprop fp ON fp.feature_id = f.feature_id AND fp.type_id IN (68, 69)    WHERE fr.object_id = CAST(? AS INTEGER)      AND fr.type_id = 500      AND f.type_id = 1214      AND f.organism_id IN (SELECT organism_id FROM supported_organism_current_v)    ORDER BY f.SORTABLE_NAME, organism_id
### Cause: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECIMAL, DRIVER=4.25.13
	org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:508)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:415)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1950)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:469)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.xenbase.utility.filters.UmbrellaGeneFilter.doFilter(UmbrellaGeneFilter.java:38)
	org.xenbase.utility.filters.HTTPStoHTTP.doFilter(HTTPStoHTTP.java:171)
	org.xenbase.utility.filters.RetrieveUserFilter.doFilter(RetrieveUserFilter.java:96)

Root Cause

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECIMAL, DRIVER=4.25.13
### The error may exist in org/xenbase/gene/dto/gene-mapping.xml
### The error may involve org.xenbase.gene.dao.GeneDao.getXenopusChildGeneFeatures-Inline
### The error occurred while setting parameters
### SQL: SELECT f.*, fp.type_id as proptype_id, o.abbreviation organism_name     FROM feature f          JOIN feature_relationship fr ON fr.subject_id = f.feature_id          JOIN organism o ON o.organism_id = f.organism_id       LEFT JOIN featureprop fp ON fp.feature_id = f.feature_id AND fp.type_id IN (68, 69)    WHERE fr.object_id = CAST(? AS INTEGER)      AND fr.type_id = 500      AND f.type_id = 1214      AND f.organism_id IN (SELECT organism_id FROM supported_organism_current_v)    ORDER BY f.SORTABLE_NAME, organism_id
### Cause: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECIMAL, DRIVER=4.25.13
	org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
	org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
	org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
	jdk.proxy4/jdk.proxy4.$Proxy38.getXenopusChildGeneFeatures(Unknown Source)
	org.xenbase.gene.dao.XGeneData.getXenopusChildGeneFeatures(XGeneData.java:1051)
	org.xenbase.gene.actions.GoTermAction.display(GoTermAction.java:35)
	jdk.internal.reflect.GeneratedMethodAccessor3034.invoke(Unknown Source)
	java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.base/java.lang.reflect.Method.invoke(Method.java:568)
	org.apache.struts.extras.actions.DispatchAction.dispatchMethod(DispatchAction.java:273)
	org.apache.struts.extras.actions.DispatchAction.execute(DispatchAction.java:173)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:413)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1950)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:469)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.xenbase.utility.filters.UmbrellaGeneFilter.doFilter(UmbrellaGeneFilter.java:38)
	org.xenbase.utility.filters.HTTPStoHTTP.doFilter(HTTPStoHTTP.java:171)
	org.xenbase.utility.filters.RetrieveUserFilter.doFilter(RetrieveUserFilter.java:96)

Root Cause

com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECIMAL, DRIVER=4.25.13
	com.ibm.db2.jcc.am.b6.a(b6.java:802)
	com.ibm.db2.jcc.am.b6.a(b6.java:66)
	com.ibm.db2.jcc.am.b6.a(b6.java:140)
	com.ibm.db2.jcc.am.k3.c(k3.java:2824)
	com.ibm.db2.jcc.am.k3.a(k3.java:2261)
	com.ibm.db2.jcc.t4.ab.r(ab.java:1654)
	com.ibm.db2.jcc.t4.ab.l(ab.java:751)
	com.ibm.db2.jcc.t4.ab.d(ab.java:112)
	com.ibm.db2.jcc.t4.p.c(p.java:44)
	com.ibm.db2.jcc.t4.av.j(av.java:162)
	com.ibm.db2.jcc.am.k3.an(k3.java:2256)
	com.ibm.db2.jcc.am.k4.a(k4.java:4666)
	com.ibm.db2.jcc.am.k4.b(k4.java:4182)
	com.ibm.db2.jcc.am.k4.bg(k4.java:2880)
	com.ibm.db2.jcc.am.k4.execute(k4.java:2855)
	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:93)
	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:93)
	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:93)
	org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
	org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
	org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
	org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
	org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
	org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
	org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:141)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
	jdk.proxy4/jdk.proxy4.$Proxy38.getXenopusChildGeneFeatures(Unknown Source)
	org.xenbase.gene.dao.XGeneData.getXenopusChildGeneFeatures(XGeneData.java:1051)
	org.xenbase.gene.actions.GoTermAction.display(GoTermAction.java:35)
	jdk.internal.reflect.GeneratedMethodAccessor3034.invoke(Unknown Source)
	java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.base/java.lang.reflect.Method.invoke(Method.java:568)
	org.apache.struts.extras.actions.DispatchAction.dispatchMethod(DispatchAction.java:273)
	org.apache.struts.extras.actions.DispatchAction.execute(DispatchAction.java:173)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:413)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:225)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1950)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:469)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.xenbase.utility.filters.UmbrellaGeneFilter.doFilter(UmbrellaGeneFilter.java:38)
	org.xenbase.utility.filters.HTTPStoHTTP.doFilter(HTTPStoHTTP.java:171)
	org.xenbase.utility.filters.RetrieveUserFilter.doFilter(RetrieveUserFilter.java:96)

Note The full stack trace of the root cause is available in the server logs.


Apache Tomcat/9.0.58 (Ubuntu)