PA Data collection Job error

[groverdhairya]

Hi Everyone

I am getting Job Error while collecting the data in Platform Analytics. Do anyone have any idea regarding this error message.
This is the error message:
Unexpected exception occurred: com.glide.sys.TransactionCancelledException: Transaction cancelled: TimeLimitedBGTransaction expired
at com.glide.sys.Transaction.cancelIfRequested0(Transaction.java:1781)
at com.glide.sys.Transaction.cancelIfNecessary(Transaction.java:2183)
at com.glide.db.DBIError.handleException(DBIError.java:42)
at com.glide.db.DBI.executeStatement(DBI.java:1453)
at com.glide.db.DBQueryExecutor.executeStatement(DBQueryExecutor.java:360)
at com.glide.db.DBQueryExecutor.executeStatement(DBQueryExecutor.java:347)
at com.glide.db.DBQueryExecutor.execute(DBQueryExecutor.java:105)
at com.glide.db.DBQuery.executeAsResultSet0(DBQuery.java:750)
at com.glide.db.DBQuery.executeAndReturnTable(DBQuery.java:663)
at com.glide.db.DBAction.executeNormal(DBAction.java:374)
at com.glide.db.DBAction.executeAndReturnException(DBAction.java:328)
at com.glide.db.RDBMSQueryContext.executeQuery(RDBMSQueryContext.java:42)
at com.glide.db.DBQuery.execute(DBQuery.java:3632)
at com.glide.ui.SysMessage.getMessage0(SysMessage.java:338)
at com.glide.ui.SysMessage.getMessage(SysMessage.java:309)
at com.glide.ui.SysMessage.lambda$getMessageLang$0(SysMessage.java:270)
at com.glide.ui.SysLanguage.applyWithFallback(SysLanguage.java:53)
at com.glide.ui.SysLanguage.getTranslationWithFallbackToDefault(SysLanguage.java:38)
at com.glide.ui.SysMessage.getMessageLang(SysMessage.java:269)
at com.glide.ui.SysMessage.getMessage(SysMessage.java:255)
at com.glide.ui.SysMessage.generate(SysMessage.java:153)
at com.glide.ui.SysMessage.generate(SysMessage.java:173)
at com.glide.ui.SysMessage.format(SysMessage.java:77)
at com.glide.ui.SysMessage.format(SysMessage.java:97)
at com.snc.pa.dc.Script.evaluate(Script.java:159)
at com.snc.pa.dc.Script.evaluate(Script.java:126)
at com.snc.pa.dc.hsql.merge.HSQLDataCollector.evaluateScript(HSQLDataCollector.java:874)
at com.snc.pa.dc.hsql.merge.HSQLDataCollector.collect(HSQLDataCollector.java:359)
at com.snc.pa.dc.hsql.merge.HSQLDataCollector.collect(HSQLDataCollector.java:281)
at com.snc.pa.dc.hsql.merge.HSQLDataCollector.collect(HSQLDataCollector.java:180)
at com.snc.pa.dc.DataCollectorJob.collect(DataCollectorJob.java:449)
at com.snc.pa.dc.DataCollectorJob.collectWithMutex(DataCollectorJob.java:314)
at com.snc.pa.dc.DataCollectorJob.execute(DataCollectorJob.java:299)
at com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:169)
at com.snc.db.data_replicate.replicator.DataReplicationAdvisors.runInOriginatorContext(DataReplicationAdvisors.java:73)
at com.glide.schedule.JobExecutor.lambda$inDataReplicationContext$2(JobExecutor.java:199)
at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:172)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:155)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:149)
at com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:449)
at com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$1(SchedulerWorkerThread.java:318)
at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
at com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:318)
at com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:118)
Caused by: com.glide.db.TransactionSQLCancelledException: TimeLimitedBGTransaction expired
at com.glide.db.QueryTimer.<init>(QueryTimer.java:38)
at com.glide.db.pool.PooledDBI.createQueryTimer(PooledDBI.java:295)
at com.glide.db.DBI.executeStatement(DBI.java:1427)

[palanikumar]

Hi,

Please check whether any of these articles helps you:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0866547

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0855451

Thank you,

Palani

[Bert_c1]

post/review the related entries in the PA Data Collection Job log.

[Sumanth16]

Hi @groverdhairya ,

Please refer to below thread:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0855451

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda