WSO2 API Manager Analytics "Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS'WSO2 API Manager - Sharing registryWSO2 APIM 2.0 Clustering deployment issue when deploy sample APIWSO2 API Manager authentication Violation of UNIQUE KEY constraint errorWSO2 API Manager 2.1 Analytics - Fails to Start up while connecting to Oracle DBWSO2 Identity server as key manager 5.3.0 with AM 2.1.0WSO2 APIM Analytics server setup issueChange password in WSO2 AM-Analyticsorg.wso2.carbon.apimgt.gateway.handlers.security.APISecurityException: Error while accessing backend services for API key validationNot able to validate token when using pre-packaged wso2 identity server as key manager for wso2 api managerCannot change credentials for wso2 api manager Analytics

What happens if nobody can form a government in Israel?

Should I complain to HR about being mocked for request I made

Is there any reason nowadays to use a neon indicator lamp instead of an LED?

What is the need of methods like GET and POST in the HTTP protocol?

Does wetting a beer glass change the foam characteristics?

Social leper versus social leopard

How to make interviewee comfortable interviewing in lounge chairs

How to conditionally load a package only if shell-escape (write18) is passed

To what extent is it worthwhile to report check fraud / refund scams?

What do you do if you have developments on your paper during the long peer review process?

Is it a good idea to leave minor world details to the reader's imagination?

How much Damage can be done with "just" heating matter?

The quicker I go up, the sooner I’ll go down - Riddle

If the EU does not offer an extension to UK's Article 50 invocation, is the Benn Bill irrelevant?

Is It Possible to Have Different Sea Levels, Eventually Causing New Landforms to Appear?

As an employer, can I compel my employees to vote?

Did Apollo carry and use WD40?

Do the villains know Batman has no superpowers?

Is it possible to encode a message in such a way that can only be read by someone or something capable of seeing into the very near future?

What is the meaning of "heutig" in this sentence?

Does the Orange League not count as an official Pokemon League, making the Alolan League his first-ever win?

Is it more effective to add yeast before or after kneading?

Why is there is no screening for Ovarian Cancer?

Worms crawling under skin



WSO2 API Manager Analytics "Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS'


WSO2 API Manager - Sharing registryWSO2 APIM 2.0 Clustering deployment issue when deploy sample APIWSO2 API Manager authentication Violation of UNIQUE KEY constraint errorWSO2 API Manager 2.1 Analytics - Fails to Start up while connecting to Oracle DBWSO2 Identity server as key manager 5.3.0 with AM 2.1.0WSO2 APIM Analytics server setup issueChange password in WSO2 AM-Analyticsorg.wso2.carbon.apimgt.gateway.handlers.security.APISecurityException: Error while accessing backend services for API key validationNot able to validate token when using pre-packaged wso2 identity server as key manager for wso2 api managerCannot change credentials for wso2 api manager Analytics






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















We are using WSO2 API Manager Analytics with a clustered API Manager configuration.
We have only a worker and a dashboard (API Manager Analytics).
After some times, we have this error



ERROR org.wso2.siddhi.core.stream.input.source.InputEventHandler - Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY' Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY'
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:438)
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:244)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:212)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:119)
at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:350)
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: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: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor81.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.util.Util.handleNewInstance(Util.java:191)
at com.mysql.cj.util.Util.getInstance(Util.java:166)
at com.mysql.cj.util.Util.getInstance(Util.java:173)
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:870)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:452)
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814)
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:1198)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:435)
... 54 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:849)
... 60 more


We are using MySQL as database.
At the beginning, we have supposed this problem was caused by the gateways. Anyway, even if we turn off one of these two gateways the problem happens again.
Thank you for your support!










share|improve this question






























    0















    We are using WSO2 API Manager Analytics with a clustered API Manager configuration.
    We have only a worker and a dashboard (API Manager Analytics).
    After some times, we have this error



    ERROR org.wso2.siddhi.core.stream.input.source.InputEventHandler - Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY' Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY'
    at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:438)
    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:244)
    at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:212)
    at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:119)
    at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:350)
    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: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: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
    at sun.reflect.GeneratedConstructorAccessor81.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at com.mysql.cj.util.Util.handleNewInstance(Util.java:191)
    at com.mysql.cj.util.Util.getInstance(Util.java:166)
    at com.mysql.cj.util.Util.getInstance(Util.java:173)
    at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:870)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:452)
    at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814)
    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:1198)
    at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:435)
    ... 54 more
    Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:849)
    ... 60 more


    We are using MySQL as database.
    At the beginning, we have supposed this problem was caused by the gateways. Anyway, even if we turn off one of these two gateways the problem happens again.
    Thank you for your support!










    share|improve this question


























      0












      0








      0








      We are using WSO2 API Manager Analytics with a clustered API Manager configuration.
      We have only a worker and a dashboard (API Manager Analytics).
      After some times, we have this error



      ERROR org.wso2.siddhi.core.stream.input.source.InputEventHandler - Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY' Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY'
      at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:438)
      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:244)
      at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:212)
      at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:119)
      at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:350)
      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: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: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
      at sun.reflect.GeneratedConstructorAccessor81.newInstance(Unknown Source)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      at com.mysql.cj.util.Util.handleNewInstance(Util.java:191)
      at com.mysql.cj.util.Util.getInstance(Util.java:166)
      at com.mysql.cj.util.Util.getInstance(Util.java:173)
      at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:870)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:452)
      at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814)
      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:1198)
      at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:435)
      ... 54 more
      Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
      at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:849)
      ... 60 more


      We are using MySQL as database.
      At the beginning, we have supposed this problem was caused by the gateways. Anyway, even if we turn off one of these two gateways the problem happens again.
      Thank you for your support!










      share|improve this question














      We are using WSO2 API Manager Analytics with a clustered API Manager configuration.
      We have only a worker and a dashboard (API Manager Analytics).
      After some times, we have this error



      ERROR org.wso2.siddhi.core.stream.input.source.InputEventHandler - Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY' Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY'
      at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:438)
      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:244)
      at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:212)
      at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:119)
      at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:350)
      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: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: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
      at sun.reflect.GeneratedConstructorAccessor81.newInstance(Unknown Source)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      at com.mysql.cj.util.Util.handleNewInstance(Util.java:191)
      at com.mysql.cj.util.Util.getInstance(Util.java:166)
      at com.mysql.cj.util.Util.getInstance(Util.java:173)
      at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:870)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:452)
      at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814)
      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:1198)
      at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:435)
      ... 54 more
      Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
      at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
      at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
      at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:849)
      ... 60 more


      We are using MySQL as database.
      At the beginning, we have supposed this problem was caused by the gateways. Anyway, even if we turn off one of these two gateways the problem happens again.
      Thank you for your support!







      wso2 wso2-am






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 28 at 15:34









      FrancescoAzzolaFrancescoAzzola

      2,1382 gold badges11 silver badges21 bronze badges




      2,1382 gold badges11 silver badges21 bronze badges

























          1 Answer
          1






          active

          oldest

          votes


















          0
















          FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.






          share|improve this answer



























            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );














            draft saved

            draft discarded
















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55401515%2fwso2-api-manager-analytics-error-on-apim-access-summary-error-in-adding-even%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0
















            FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.






            share|improve this answer





























              0
















              FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.






              share|improve this answer



























                0














                0










                0









                FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.






                share|improve this answer













                FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Mar 29 at 9:21









                ruksruks

                1371 silver badge5 bronze badges




                1371 silver badge5 bronze badges

































                    draft saved

                    draft discarded















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55401515%2fwso2-api-manager-analytics-error-on-apim-access-summary-error-in-adding-even%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

                    Swift 4 - func physicsWorld not invoked on collision? The Next CEO of Stack OverflowHow to call Objective-C code from Swift#ifdef replacement in the Swift language@selector() in Swift?#pragma mark in Swift?Swift for loop: for index, element in array?dispatch_after - GCD in Swift?Swift Beta performance: sorting arraysSplit a String into an array in Swift?The use of Swift 3 @objc inference in Swift 4 mode is deprecated?How to optimize UITableViewCell, because my UITableView lags

                    Access current req object everywhere in Node.js ExpressWhy are global variables considered bad practice? (node.js)Using req & res across functionsHow do I get the path to the current script with Node.js?What is Node.js' Connect, Express and “middleware”?Node.js w/ express error handling in callbackHow to access the GET parameters after “?” in Express?Modify Node.js req object parametersAccess “app” variable inside of ExpressJS/ConnectJS middleware?Node.js Express app - request objectAngular Http Module considered middleware?Session variables in ExpressJSAdd properties to the req object in expressjs with Typescript