kie-server application failing to start with DB2
sandesh.jp Mar 9, 2017 7:29 AMAfter deploying kie-server.war into JBoss EAP 6.4.10.GA it keeps throwing error continuously till undeployed, business central and dash builder started without any issues.
This issue happening when i connect to DB2 database.No issues when tried with Mysql as Database.
I am attaching the log file.
Error:
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.getResultSet(Loader.java:2062) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.doQuery(Loader.java:906) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.doList(Loader.java:2550) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.doList(Loader.java:2536) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.Loader.list(Loader.java:2361) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1230) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:287) [hibernate-entitymanager-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
... 69 more
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-511, SQLSTATE=42829, SQLERRMC=null, DRIVER=4.22.29
at com.ibm.db2.jcc.am.ld.a(ld.java:810)
at com.ibm.db2.jcc.am.ld.a(ld.java:66)
at com.ibm.db2.jcc.am.ld.a(ld.java:140)
at com.ibm.db2.jcc.am.up.c(up.java:2796)
at com.ibm.db2.jcc.am.up.d(up.java:2784)
at com.ibm.db2.jcc.am.up.a(up.java:2212)
at com.ibm.db2.jcc.am.vp.a(vp.java:8077)
at com.ibm.db2.jcc.t4.bb.i(bb.java:148)
at com.ibm.db2.jcc.t4.bb.b(bb.java:41)
at com.ibm.db2.jcc.t4.p.a(p.java:32)
at com.ibm.db2.jcc.t4.vb.i(vb.java:145)
at com.ibm.db2.jcc.am.up.lb(up.java:2181)
at com.ibm.db2.jcc.am.vp.zc(vp.java:3699)
at com.ibm.db2.jcc.am.vp.a(vp.java:4578)
at com.ibm.db2.jcc.am.vp.b(vp.java:4151)
at com.ibm.db2.jcc.am.vp.mc(vp.java:771)
at com.ibm.db2.jcc.am.vp.executeQuery(vp.java:736)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79) [hibernate-core-4.2.22.Final-redhat-1.jar:4.2.22.Final-redhat-1]
... 84 more
Thanks,
Sandesh
-
server.log.zip 3.7 KB