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

                    SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

                    은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현