Hi devs,
I often get this kind of errors when EI-640 ESB sends their statistics data to
(remote) EI-640 worker.
I understand that data are not well formatted from the client (esb) to fit into
the analytics DB, right ? How could I correct this ?
Since we plan to later use postgres when going into production mode, will I
have same problem after with postgres DB ot is it specific to H2 ?
[2018-12-20 09:45:16,965] ERROR
{org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on
'EI_Analytics_StatApp'. Cannot execute update/insert operation (update) on
table 'ConfigEntryTable' with SQL query INSERT INTO ConfigEntryTable
(metaTenantId , hashcode , entryName , configData , eventTimestamp ) VALUES
(?, ?, ?, ?, ?) . Error in applying transport property mapping for 'wso2event'
source at 'ConfigEntryEventStream' stream.
org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on
'EI_Analytics_StatApp'. Cannot execute update/insert operation (update) on
table 'ConfigEntryTable' with SQL query INSERT INTO ConfigEntryTable
(metaTenantId , hashcode , entryName , configData , eventTimestamp ) VALUES
(?, ?, ?, ?, ?) .
at
org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:733)
at
org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:622)
at
org.wso2.siddhi.core.table.record.AbstractRecordTable.updateOrAdd(AbstractRecordTable.java:323)
at org.wso2.siddhi.core.table.Table.updateOrAddEvents(Table.java:288)
at
org.wso2.siddhi.core.query.output.callback.UpdateOrInsertTableCallback.send(UpdateOrInsertTableCallback.java:78)
at
org.wso2.siddhi.core.query.output.ratelimit.OutputRateLimiter.sendToCallBacks(OutputRateLimiter.java:88)
at
org.wso2.siddhi.core.query.output.ratelimit.PassThroughOutputRateLimiter.process(PassThroughOutputRateLimiter.java:46)
at
org.wso2.siddhi.core.query.selector.QuerySelector.process(QuerySelector.java:98)
at
org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at
org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at
org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at
org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at
org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at
org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at
org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at
org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at
org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at
org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at
org.wso2.extension.siddhi.map.wso2event.source.WSO2SourceMapper.mapAndProcess(WSO2SourceMapper.java:227)
at
org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at
org.wso2.extension.siddhi.io.wso2event.source.AgentCallbackImpl.receive(AgentCallbackImpl.java:72)
at
org.wso2.carbon.databridge.core.internal.queue.QueueWorker.run(QueueWorker.java:80)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Value too long for column
"CONFIGDATA VARCHAR(6000)":
"'[{""id"":""learning-learningUnits-API@0:learning-learningUnits-API"",""parentId"":null,""group"":null},{""id"":""learning-learningUnits-AP...
(9844)"; SQL statement:
INSERT INTO ConfigEntryTable (metaTenantId , hashcode , entryName , configData
, eventTimestamp ) VALUES (?, ?, ?, ?, ?) [22001-196]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1234)
at
com.zaxxer.hikari.proxy.StatementProxy.executeBatch(StatementProxy.java:127)
at
com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeBatch(HikariPreparedStatementProxy.java)
at
org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729)
... 26 more
Thanks,
Bernard
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
