2021-10-13 12:52:20.057 WARN 7907 --- [pool-4-thread-1] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 257, SQLState: 42000 2021-10-13 12:52:20.057 ERROR 7907 --- [pool-4-thread-1] o.h.engine.jdbc.spi.SqlExceptionHelper : Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the CONVERT function to run this query. 2021-10-13 12:52:20.058 ERROR 7907 --- [pool-4-thread-1] o.j.e.c.e.ProcessAutoAckErrorCommand : Execution error in command ProcessAutoAckErrorCommand javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1575) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.query.Query.getResultList(Query.java:132) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.jbpm.executor.commands.error.ProcessAutoAckErrorCommand.findErrorsToAck(ProcessAutoAckErrorCommand.java:71) ~[jbpm-executor-7.59.0.Final-redhat-00003.jar!/:7.59.0.Final-redhat-00003] at org.jbpm.executor.commands.error.AutoAckErrorCommand.execute(AutoAckErrorCommand.java:85) ~[jbpm-executor-7.59.0.Final-redhat-00003.jar!/:7.59.0.Final-redhat-00003] at org.jbpm.executor.impl.AbstractAvailableJobsExecutor.executeGivenJob(AbstractAvailableJobsExecutor.java:135) ~[jbpm-executor-7.59.0.Final-redhat-00003.jar!/:7.59.0.Final-redhat-00003] at org.jbpm.executor.impl.AvailableJobsExecutor.executeJob(AvailableJobsExecutor.java:33) ~[jbpm-executor-7.59.0.Final-redhat-00003.jar!/:7.59.0.Final-redhat-00003] at org.jbpm.executor.impl.concurrent.PrioritisedRunnable.run(PrioritisedRunnable.java:47) ~[jbpm-executor-7.59.0.Final-redhat-00003.jar!/:7.59.0.Final-redhat-00003] at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) ~[na:na] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na] at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) ~[na:na] at org.jbpm.executor.impl.concurrent.PrioritisedScheduledFutureTask.run(PrioritisedScheduledFutureTask.java:41) ~[jbpm-executor-7.59.0.Final-redhat-00003.jar!/:7.59.0.Final-redhat-00003] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[na:na] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[na:na] at java.base/java.lang.Thread.run(Thread.java:829) ~[na:na] Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.getResultSet(Loader.java:2265) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2028) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1990) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.doQuery(Loader.java:949) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:351) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.doList(Loader.java:2787) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.doList(Loader.java:2770) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2604) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.Loader.list(Loader.java:2599) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:505) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1526) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1598) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1566) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] ... 13 common frames omitted Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the CONVERT function to run this query. at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4003) ~[jconn4.jar:JDK 1.6/jdbcmain/Sun Jan 12 09:45:05 PST 2014] at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3093) ~[jconn4.jar:JDK 1.6/jdbcmain/Sun Jan 12 09:45:05 PST 2014] at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78) ~[jconn4.jar:JDK 1.6/jdbcmain/Sun Jan 12 09:45:05 PST 2014] at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289) ~[jconn4.jar:JDK 1.6/jdbcmain/Sun Jan 12 09:45:05 PST 2014] at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271) ~[jconn4.jar:JDK 1.6/jdbcmain/Sun Jan 12 09:45:05 PST 2014] at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2408) ~[jconn4.jar:JDK 1.6/jdbcmain/Sun Jan 12 09:45:05 PST 2014] at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2394) ~[jconn4.jar:JDK 1.6/jdbcmain/Sun Jan 12 09:45:05 PST 2014] at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:257) ~[jconn4.jar:JDK 1.6/jdbcmain/Sun Jan 12 09:45:05 PST 2014] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:73) ~[commons-dbcp2-2.4.0.jar!/:2.4.0] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:73) ~[commons-dbcp2-2.4.0.jar!/:2.4.0] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60) ~[hibernate-core-5.3.20.Final-redhat-00001.jar!/:5.3.20.Final-redhat-00001] ... 28 common frames omitted