[MSSQL] Errors thrown when enabled APIM Analytics 2.6.0 RC1

[lalaji]

Description: 2018-09-13 13:24:24,396] INFO {org.wso2.extension.siddhi.io.http.source.HttpConnectorPortBindingListener} - HTTP source localhost:8007 has been started [2018-09-13 13:24:24,397] INFO {org.wso2.carbon.stream.processor.core.internal.StreamProcessorService} - Siddhi App GetSCANotAppliedData deployed successfully [2018-09-13 13:24:24,416] INFO {org.wso2.carbon.stream.processor.core.internal.StreamProcessorService} - Siddhi App GetLastSCAAppliedStatus deployed successfully [2018-09-13 13:24:24,427] INFO {org.wso2.carbon.stream.processor.core.internal.StreamProcessorService} - Siddhi App TransactionsDataApp deployed successfully [2018-09-13 13:24:24,437] INFO {org.wso2.carbon.stream.processor.core.internal.StreamProcessorService} - Siddhi App ViewAccountsDataApp deployed successfully [2018-09-13 13:24:24,447] INFO {org.wso2.carbon.stream.processor.core.internal.StreamProcessorService} - Siddhi App SCADataForAccountsApp deployed successfully [2018-09-13 13:24:24,450] INFO {org.wso2.carbon.kernel.internal.CarbonStartupHandler} - WSO2 API Manager Analytics Server started in 10.719 sec [2018-09-13 13:24:40,929] INFO {org.wso2.carbon.databridge.core.DataBridge} - user admin@wso2.com@carbon.super connected [2018-09-13 13:24:41,320] ERROR {org.wso2.extension.siddhi.execution.geo.internal.impl.RDBMSGeoLocationResolver} - Cannot retrieve the location from database com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'IP_LOCATION'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285) at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:52) at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeQuery(HikariPreparedStatementProxy.java) at org.wso2.extension.siddhi.execution.geo.internal.impl.RDBMSGeoLocationResolver.loadLocation(RDBMSGeoLocationResolver.java:220) at org.wso2.extension.siddhi.execution.geo.internal.impl.RDBMSGeoLocationResolver.getLocation(RDBMSGeoLocationResolver.java:102) at org.wso2.extension.siddhi.execution.geo.internal.impl.DefaultDBBasedGeoLocationResolver.getGeoLocationInfo(DefaultDBBasedGeoLocationResolver.java:43) at org.wso2.extension.siddhi.execution.geo.GetCountryResolverFunction.execute(GetCountryResolverFunction.java:138) at org.wso2.siddhi.core.executor.function.FunctionExecutor.execute(FunctionExecutor.java:103) at org.wso2.siddhi.core.query.selector.attribute.processor.AttributeProcessor.process(AttributeProcessor.java:41) at org.wso2.siddhi.core.query.selector.QuerySelector.processNoGroupBy(QuerySelector.java:136) at org.wso2.siddhi.core.query.selector.QuerySelector.process(QuerySelector.java:94) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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)

[2018-09-13 13:24:41,474] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:24:41,562] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:24:41,591] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:24:41,617] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:24:41,645] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:24:41,671] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:24:41,696] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:24:41,721] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:24:42,021] ERROR {org.wso2.siddhi.core.util.Scheduler} - org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error in adding events to 'APIM_ReqCountAgg_SECONDS' store: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. [2018-09-13 13:24:47,856] INFO {org.wso2.carbon.databridge.core.DataBridge} - user admin@wso2.com@carbon.super connected [2018-09-13 13:25:16,461] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:25:16,469] ERROR {org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor} - Error on 'APIM_THROTTLED_OUT_SUMMARY'. Error in adding events to 'APIM_ReqCountAgg_SECONDS' store: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. Dropping event chunk EventChunk{first=null}, error in processing org.wso2.siddhi.core.query.processor.stream.window.LengthWindowProcessor. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_THROTTLED_OUT_SUMMARY'. Error in adding events to 'APIM_ReqCountAgg_SECONDS' store: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:434) at org.wso2.siddhi.core.table.record.AbstractRecordTable.add(AbstractRecordTable.java:98) at org.wso2.siddhi.core.table.Table.addEvents(Table.java:139) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchEvents(IncrementalExecutor.java:228) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:196) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:117) at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:335) at org.wso2.siddhi.core.aggregation.IncrementalAggregationProcessor.process(IncrementalAggregationProcessor.java:91) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.stream.join.JoinProcessor.process(JoinProcessor.java:110) at org.wso2.siddhi.core.query.processor.stream.window.LengthWindowProcessor.process(LengthWindowProcessor.java:137) at org.wso2.siddhi.core.query.processor.stream.window.WindowProcessor.processEventChunk(WindowProcessor.java:66) at org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor.process(AbstractStreamProcessor.java:125) at org.wso2.siddhi.core.query.input.stream.join.JoinProcessor.process(JoinProcessor.java:118) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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.batchExecuteQueriesWithRecords(RDBMSEventTable.java:1182) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:431) ... 68 more

[2018-09-13 13:26:28,468] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:26:28,477] ERROR {org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor} - Error on 'APIM_THROTTLED_OUT_SUMMARY'. Error in adding events to 'APIM_ReqCountAgg_SECONDS' store: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. Dropping event chunk EventChunk{first=null}, error in processing org.wso2.siddhi.core.query.processor.stream.window.LengthWindowProcessor. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_THROTTLED_OUT_SUMMARY'. Error in adding events to 'APIM_ReqCountAgg_SECONDS' store: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:434) at org.wso2.siddhi.core.table.record.AbstractRecordTable.add(AbstractRecordTable.java:98) at org.wso2.siddhi.core.table.Table.addEvents(Table.java:139) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchEvents(IncrementalExecutor.java:228) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:196) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:117) at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:335) at org.wso2.siddhi.core.aggregation.IncrementalAggregationProcessor.process(IncrementalAggregationProcessor.java:91) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.stream.join.JoinProcessor.process(JoinProcessor.java:110) at org.wso2.siddhi.core.query.processor.stream.window.LengthWindowProcessor.process(LengthWindowProcessor.java:137) at org.wso2.siddhi.core.query.processor.stream.window.WindowProcessor.processEventChunk(WindowProcessor.java:66) at org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor.process(AbstractStreamProcessor.java:125) at org.wso2.siddhi.core.query.input.stream.join.JoinProcessor.process(JoinProcessor.java:118) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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.batchExecuteQueriesWithRecords(RDBMSEventTable.java:1182) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:431) ... 68 more

[2018-09-13 13:30:33,051] ERROR {org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_UNUSUAL_IP_ACCESS_ALERT'. Cannot execute update/insert operation (update) on table 'ApimIPAccessSummary' with SQL query INSERT INTO ApimIPAccessSummary (username , applicationConsumerKey , ip , lastAccessedDate ) VALUES (?, ?, ?, ?) . at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:729) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:618) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.processor.filter.FilterProcessor.process(FilterProcessor.java:60) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationConsumerKey', table 'openbank_analytics_processed_data_store.dbo.ApimIPAccessSummary'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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:725) ... 64 more

[2018-09-13 13:30:33,062] ERROR {org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor} - Error on 'APIM_THROTTLED_OUT_SUMMARY'. Error in adding events to 'APIM_ReqCountAgg_SECONDS' store: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. Dropping event chunk EventChunk{first=null}, error in processing org.wso2.siddhi.core.query.processor.stream.window.LengthWindowProcessor. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_THROTTLED_OUT_SUMMARY'. Error in adding events to 'APIM_ReqCountAgg_SECONDS' store: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:434) at org.wso2.siddhi.core.table.record.AbstractRecordTable.add(AbstractRecordTable.java:98) at org.wso2.siddhi.core.table.Table.addEvents(Table.java:139) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchEvents(IncrementalExecutor.java:228) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:196) at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:117) at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:335) at org.wso2.siddhi.core.aggregation.IncrementalAggregationProcessor.process(IncrementalAggregationProcessor.java:91) 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:121) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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.stream.join.JoinProcessor.process(JoinProcessor.java:110) at org.wso2.siddhi.core.query.processor.stream.window.LengthWindowProcessor.process(LengthWindowProcessor.java:137) at org.wso2.siddhi.core.query.processor.stream.window.WindowProcessor.processEventChunk(WindowProcessor.java:66) at org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor.process(AbstractStreamProcessor.java:125) at org.wso2.siddhi.core.query.input.stream.join.JoinProcessor.process(JoinProcessor.java:118) 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.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66) at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136) at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110) at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117) at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41) at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95) at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135) at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74) at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165) at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54) at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72) at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156) at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375) at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56) 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: java.sql.BatchUpdateException: Cannot insert the value NULL into column 'applicationName', table 'openbank_analytics_processed_data_store.dbo.APIM_ReqCountAgg_SECONDS'; column does not allow nulls. INSERT fails. at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1178) 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.batchExecuteQueriesWithRecords(RDBMSEventTable.java:1182) at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:431) ... 68 more

Suggested Labels:

Suggested Assignees:

Affected Product Version:

OS, DB, other environment details and versions:

Steps to reproduce:

Related Issues:

[chamilaadhi]

fixed with APIM RC3 and APIM Analytics RC3