automatic transaction discovery not working

book

Article ID: 195771

calendar_today

Updated On:

Products

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

Issue/Introduction

automatic transaction discovery not working. We see the following error messages in the IntroscopeEnterpriseManager.log when running the automatic transaction discovery.

6/28/20 09:22:11.606 PM CST [ERROR] [AutogenProcessingPool.Thread1] [Manager.com.timestock.tess.services.processors.AutogenProcessor] Can't add autogen transaction: /PeTs/images/abcd1.gif
org.postgresql.util.PSQLException: ERROR: null value in column "ts_transet_group_id" violates not-null constraint
  Detail: Failing row contains (700000000000031796, 32468, null, 0, 2020-06-28 21:22:11.564+02, null, f).
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
 at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2174)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610)
 at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 at com.timestock.tess.services.processors.AutogenProcessor.addAutogenTransaction(AutogenProcessor.java:811)
 at com.timestock.tess.services.processors.AutogenProcessor.createAutogenBusinessTransaction(AutogenProcessor.java:446)
 at com.timestock.tess.services.processors.AutogenProcessor._process(AutogenProcessor.java:406)
 at com.timestock.tess.services.processors.AutogenProcessor.process(AutogenProcessor.java:352)
 at com.timestock.tess.services.tim.ProcessingQueueTask.run(ProcessingQueueTask.java:110)
 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)
6/28/20 09:22:11.613 PM CST [ERROR] [AutogenProcessingPool.Thread2] [Manager.com.timestock.tess.services.processors.AutogenProcessor] Can't add autogen transaction: /PeTs/images/abcd1.gif
java.sql.BatchUpdateException: Batch entry 0 insert into ts_transetgroup_transets_map (version_info, ts_create_date, ts_delete_date, ts_soft_delete, ts_transet_id, ts_transet_group_id, ts_transet_incarnation_id) values (0, '2020-06-28 21:22:11.585000 +02:00:00', NULL, '0', 700000000000031797, NULL, 32469) was aborted.  Call getNextException to see the cause.
 at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2746)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1887)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2893)
 at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
 at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
 at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2174)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610)
 at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
 at com.timestock.tess.services.processors.AutogenProcessor.addAutogenTransaction(AutogenProcessor.java:811)
 at com.timestock.tess.services.processors.AutogenProcessor.createAutogenBusinessTransaction(AutogenProcessor.java:446)
 at com.timestock.tess.services.processors.AutogenProcessor._process(AutogenProcessor.java:406)
 at com.timestock.tess.services.processors.AutogenProcessor.process(AutogenProcessor.java:352)
 at com.timestock.tess.services.tim.ProcessingQueueTask.run(ProcessingQueueTask.java:110)
 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)

Cause

We found that in the CEM UI under application "Default Application" is missing, and under business service "Discovered Transactions" with "Default Application" is missing.

We created these two items manually, but continue to see the same issue.

Environment

Release : 10.7.0

Component : APM CEM

Resolution

Restored the APMDB from the backup when the automatic transaction discovery was working in this environment. This resolve the issue of automatic transaction discovery.