2022-06-17 12:07:07,599 INFO [org.acm.hib.orm.pan.BaseDataSvc] (vert.x-eventloop-thread-0) Received request for query with statistics 2022-06-17 12:07:07,607 INFO [org.acm.hib.orm.pan.BaseDataSvc] (vert.x-eventloop-thread-0) SELECT entity FROM CommonAppUsersMdl entity 2022-06-17 12:07:07,631 INFO [org.acm.hib.orm.pan.BaseDataSvc] (vert.x-eventloop-thread-0) Pagination Info: Page Number: 2 2022-06-17 12:07:07,631 INFO [org.acm.hib.orm.pan.BaseDataSvc] (vert.x-eventloop-thread-0) Pagination Info: Records Per Page: 2 2022-06-17 12:07:07,631 INFO [org.acm.hib.orm.pan.BaseDataSvc] (vert.x-eventloop-thread-0) SELECT entity FROM CommonAppUsersMdl entity 2022-06-17 12:07:07,639 INFO [org.acm.hib.orm.pan.BaseDataSvc] (vert.x-eventloop-thread-0) Pagination Info: Page Number: 2 2022-06-17 12:07:07,639 INFO [org.acm.hib.orm.pan.BaseDataSvc] (vert.x-eventloop-thread-0) Pagination Info: Records Per Page: 2 2022-06-17 12:07:07,647 INFO [org.acm.hib.orm.pan.BaseDataSvc] (vert.x-eventloop-thread-0) Executed request for query with statistics Hibernate: select count(*) as col_0_0_ from common.APP_USERS commonappu0_ Hibernate: with query as (select inner_query.*, row_number() over ( order by current_timestamp) as __row__ from ( select commonappu0_.USER_ID as user_id1_0_, commonappu0_.BANK_GROUP_FLAG as bank_gro2_0_, commonappu0_.BANK_ID as bank_id3_0_, commonappu0_.BLOCK_STATUS as block_st4_0_, commonappu0_.BRANCH_ID as branch_i5_0_, commonappu0_.CREATED_TIME as created_6_0_, commonappu0_.FIRST_NAME as first_na7_0_, commonappu0_.FIRST_NAME_LOCAL as first_na8_0_, commonappu0_.IS_OVERRIDE_CHECKER as is_overr9_0_, commonappu0_.LAST_NAME as last_na10_0_, commonappu0_.LAST_NAME_LOCAL as last_na11_0_, commonappu0_.LOGINNAME as loginna12_0_, commonappu0_.LOGINNAME_LOCAL as loginna13_0_, commonappu0_.MODIFIED_TIME as modifie14_0_, commonappu0_.PASSWORD as passwor15_0_ from common.APP_USERS commonappu0_ ) inner_query ) select user_id1_0_, bank_gro2_0_, bank_id3_0_, block_st4_0_, branch_i5_0_, created_6_0_, first_na7_0_, first_na8_0_, is_overr9_0_, last_na10_0_, last_na11_0_, loginna12_0_, loginna13_0_, modifie14_0_, passwor15_0_ from query where __row__ >= ? and __row__ < ? 2022-06-17 12:07:10,347 ERROR [org.hib.rea.errors] (vert.x-eventloop-thread-0) HR000057: Failed to execute statement [$1select commonappu0_.USER_ID as user_id1_0_, commonappu0_.BANK_GROUP_FLAG as bank_gro2_0_, commonappu0_.BANK_ID as bank_id3_0_, commonappu0_.BLOCK_STATUS as block_st4_0_, commonappu0_.BRANCH_ID as branch_i5_0_, commonappu0_.CREATED_TIME as created_6_0_, commonappu0_.FIRST_NAME as first_na7_0_, commonappu0_.FIRST_NAME_LOCAL as first_na8_0_, commonappu0_.IS_OVERRIDE_CHECKER as is_overr9_0_, commonappu0_.LAST_NAME as last_na10_0_, commonappu0_.LAST_NAME_LOCAL as last_na11_0_, commonappu0_.LOGINNAME as loginna12_0_, commonappu0_.LOGINNAME_LOCAL as loginna13_0_, commonappu0_.MODIFIED_TIME as modifie14_0_, commonappu0_.PASSWORD as passwor15_0_ from common.APP_USERS commonappu0_]: $2could not execute query: java.util.concurrent.CompletionException: io.vertx.mssqlclient.MSSQLException: {number=102, state=1, severity=15, message='Incorrect syntax near '?'.', serverName='AVATI-FLASH\IIAB', lineNumber=1, additional=[io.vertx.mssqlclient.MSSQLException: {number=8180, state=1, severity=16, message='Statement(s) could not be prepared.', serverName='AVATI-FLASH\IIAB', lineNumber=1}]} at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314) at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319) at java.base/java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:932) at java.base/java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:907) at java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506) at java.base/java.util.concurrent.CompletableFuture.completeExceptionally(CompletableFuture.java:2088) at io.vertx.core.Future.lambda$toCompletionStage$2(Future.java:362) at io.vertx.core.impl.future.FutureImpl$3.onFailure(FutureImpl.java:153) at io.vertx.core.impl.future.FutureBase.emitFailure(FutureBase.java:75) at io.vertx.core.impl.future.FutureImpl.tryFail(FutureImpl.java:230) at io.vertx.core.impl.future.PromiseImpl.tryFail(PromiseImpl.java:23) at io.vertx.sqlclient.impl.QueryResultBuilder.tryFail(QueryResultBuilder.java:118) at io.vertx.core.Promise.fail(Promise.java:89) at io.vertx.core.Promise.handle(Promise.java:53) at io.vertx.core.Promise.handle(Promise.java:29) at io.vertx.core.impl.future.FutureImpl$3.onFailure(FutureImpl.java:153) at io.vertx.core.impl.future.FutureBase.lambda$emitFailure$1(FutureBase.java:69) at io.vertx.core.impl.EventLoopContext.execute(EventLoopContext.java:81) at io.vertx.core.impl.DuplicatedContext.execute(DuplicatedContext.java:173) at io.vertx.core.impl.future.FutureBase.emitFailure(FutureBase.java:66) at io.vertx.core.impl.future.FutureImpl.tryFail(FutureImpl.java:230) at io.vertx.core.impl.future.PromiseImpl.tryFail(PromiseImpl.java:23) at io.vertx.core.impl.future.PromiseImpl.onFailure(PromiseImpl.java:54) at io.vertx.core.impl.future.PromiseImpl.handle(PromiseImpl.java:43) at io.vertx.core.impl.future.PromiseImpl.handle(PromiseImpl.java:23) at io.vertx.sqlclient.impl.command.CommandResponse.fire(CommandResponse.java:46) at io.vertx.sqlclient.impl.SocketConnectionBase.handleMessage(SocketConnectionBase.java:287) at io.vertx.sqlclient.impl.SocketConnectionBase.lambda$init$0(SocketConnectionBase.java:99) at io.vertx.core.impl.EventLoopContext.emit(EventLoopContext.java:50) at io.vertx.core.impl.ContextImpl.emit(ContextImpl.java:274) at io.vertx.core.impl.EventLoopContext.emit(EventLoopContext.java:22) at io.vertx.core.net.impl.NetSocketImpl.handleMessage(NetSocketImpl.java:394) at io.vertx.core.net.impl.ConnectionBase.read(ConnectionBase.java:156) at io.vertx.core.net.impl.VertxHandler.channelRead(VertxHandler.java:153) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) at io.netty.channel.CombinedChannelDuplexHandler$DelegatingChannelHandlerContext.fireChannelRead(CombinedChannelDuplexHandler.java:436) at io.vertx.mssqlclient.impl.codec.TdsMessageEncoder.lambda$write$0(TdsMessageEncoder.java:63) at io.vertx.mssqlclient.impl.codec.MSSQLCommandCodec.complete(MSSQLCommandCodec.java:199) at io.vertx.mssqlclient.impl.codec.MSSQLCommandCodec.handleDecodingComplete(MSSQLCommandCodec.java:189) at io.vertx.mssqlclient.impl.codec.MSSQLCommandCodec.decode(MSSQLCommandCodec.java:83) at io.vertx.mssqlclient.impl.codec.TdsMessageDecoder.decodeMessage(TdsMessageDecoder.java:65) at io.vertx.mssqlclient.impl.codec.TdsMessageDecoder.channelRead(TdsMessageDecoder.java:43) at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:327) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:299) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:722) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:658) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:584) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:496) at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:986) at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: io.vertx.mssqlclient.MSSQLException: {number=102, state=1, severity=15, message='Incorrect syntax near '?'.', serverName='AVATI-FLASH\IIAB', lineNumber=1, additional=[io.vertx.mssqlclient.MSSQLException: {number=8180, state=1, severity=16, message='Statement(s) could not be prepared.', serverName='AVATI-FLASH\IIAB', lineNumber=1}]} 2022-06-17 12:07:10,363 ERROR [org.acm.hib.orm.pan.FruitResource] (vert.x-eventloop-thread-0) Failed to handle request: io.vertx.mssqlclient.MSSQLException: {number=102, state=1, severity=15, message='Incorrect syntax near '?'.', serverName='AVATI-FLASH\IIAB', lineNumber=1, additional=[io.vertx.mssqlclient.MSSQLException: {number=8180, state=1, severity=16, message='Statement(s) could not be prepared.', serverName='AVATI-FLASH\IIAB', lineNumber=1}]}