0 Replies Latest reply on Mar 9, 2017 7:29 AM by Sandesh jayaprakash

    kie-server application failing to start with DB2

    Sandesh jayaprakash Newbie

      After 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