Hello! Pretty descriptive: *Caused by: org.apache.ignite.IgniteChecke**dException: Key is missing from query*
How is your cache key declared? Which fields are supposed to go in it? Regards, -- Ilya Kasnacheev пн, 13 янв. 2020 г. в 13:05, siva <siva.ka...@bizruntime.com>: > Hi, > Thank you for suggestion. > Please find the Server log exception: > ---------------------------------------- > org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to > execute DML statement [stmt=INSERT INTO > > "C091E548-B45A-49B4-B8EC-2CB5E27C7AF6".ENTITIESTABLEINFO(EntityId,EntityInfoJson,EntityName,EntityType,Fabric,SequenceNumber,TenantId,TenantName) > VALUES ('0-pulsar', '{}', 'Testing Topic0 Name', 'testpulsarType', > 'pulsarFabric', 0.0, 'pulsar-123-tenantid', 'pulsar-tenantName'), > params=null] > at > > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunPrepared(IgniteH2Indexing.java:2284) > ~[ignite-indexing-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2209) > ~[ignite-indexing-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2128) > ~[ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2123) > ~[ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > ~[ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2693) > ~[ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2137) > ~[ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:511) > [ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.doHandle(JdbcRequestHandler.java:245) > [ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:208) > [ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:162) > [ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:45) > [ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > [ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > [ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > [ignite-core-2.7.5.jar:2.7.5] > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) > [ignite-core-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > [ignite-core-2.7.5.jar:2.7.5] > at > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > [?:1.8.0_144] > at > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > [?:1.8.0_144] > at java.lang.Thread.run(Thread.java:748) [?:1.8.0_144] > Caused by: org.apache.ignite.IgniteCheckedException: Key is missing from > query > at > > org.apache.ignite.internal.processors.query.h2.dml.UpdatePlanBuilder.createSupplier(UpdatePlanBuilder.java:604) > ~[ignite-indexing-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.h2.dml.UpdatePlanBuilder.planForInsert(UpdatePlanBuilder.java:270) > ~[ignite-indexing-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.h2.dml.UpdatePlanBuilder.planForStatement(UpdatePlanBuilder.java:135) > ~[ignite-indexing-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.getPlanForStatement(DmlStatementsProcessor.java:741) > ~[ignite-indexing-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFields(DmlStatementsProcessor.java:175) > ~[ignite-indexing-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFieldsDistributed(DmlStatementsProcessor.java:358) > ~[ignite-indexing-2.7.5.jar:2.7.5] > at > > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.doRunPrepared(IgniteH2Indexing.java:2263) > ~[ignite-indexing-2.7.5.jar:2.7.5] > ... 19 more > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >