ORA-00001: unique constraint (APMDB.AT_EVIDENCES_PK) violated

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

The following erro ris being reportd in the IntrscopeEnterprisemanager.log file on the MOM

3/04/19 11:23:18.924 PM CET [ERROR] [pool-23-thread-1] [Manager.AT]
java.util.concurrent.ExecutionException: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into at_evidences(story_id, vertex_id, start_time, end_time, fork, type, occ_index, latest, statements) values(?, ?, ?, ?, ?, ?, ?, ?, ?)]; ORA-00001: unique constraint (APMDB.AT_EVIDENCES_PK) violated
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APMDB.AT_EVIDENCES_PK) violated

at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at com.wily.introscope.appmap.triage.entity.service.impl.LatestEvidenceCache.flushBuffer(LatestEvidenceCache.java:221)
at com.wily.introscope.appmap.triage.entity.service.impl.EvidenceServiceImpl.flushWriteBuffer(EvidenceServiceImpl.java:132)
at sun.reflect.GeneratedMethodAccessor938.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [insert into at_evidences(story_id, vertex_id, start_time, end_time, fork, type, occ_index, latest, statements) values(?, ?, ?, ?, ?, ?, ?, ?, ?)]; ORA-00001: unique constraint (APMDB.AT_EVIDENCES_PK) violated
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (APMDB.AT_EVIDENCES_PK) violated
 

Environment

Release:
Component: APMISP

Resolution

The error is resolved in 10.7 SP3