PA VSC Daily Data Collection occasionally errors

[bellr]

Hello,

Lately my team has been getting emails that the PA VSC Daily Collection errored out. Looking at the logs, it runs again after the failed attempt and collects everything is needs to and finishes without issue. Here is what the error looks like:

Unexpected exception occurred: com.glide.sys.TransactionCancelledException: Transaction cancelled: TimeLimitedBGTransaction expired

at com.glide.sys.Transaction.cancelIfRequested0(Transaction.java:1846)

at com.glide.sys.Transaction.cancelIfNecessary(Transaction.java:2270)

at com.glide.db.DBIError.handleException(DBIError.java:42)

at com.glide.db.DBI.executeStatement(DBI.java:1553)

at com.glide.db.DBQueryExecutor.executeStatement(DBQueryExecutor.java:362)

at com.glide.db.DBQueryExecutor.executeStatement(DBQueryExecutor.java:349)

at com.glide.db.DBQueryExecutor.execute(DBQueryExecutor.java:107)

at com.glide.db.DBQuery.executeAsResultSet0(DBQuery.java:774)

at com.glide.db.DBQuery.executeAndReturnTable(DBQuery.java:687)

at com.glide.db.DBAction.executeNormal(DBAction.java:382)

at com.glide.db.DBAction.executeAndReturnException(DBAction.java:330)

at com.glide.db.RDBMSQueryContext.executeQuery(RDBMSQueryContext.java:42)

at com.glide.db.DBQuery.execute(DBQuery.java:3714)

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:59)

at com.glide.ui.SysLanguage.getTranslationWithFallbackToDefault(SysLanguage.java:44)

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:875)

at com.snc.pa.dc.hsql.merge.HSQLDataCollector.collect(HSQLDataCollector.java:360)

at com.snc.pa.dc.hsql.merge.HSQLDataCollector.collect(HSQLDataCollector.java:282)

at com.snc.pa.dc.hsql.merge.HSQLDataCollector.collect(HSQLDataCollector.java:181)

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$1(JobExecutor.java:194)

at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:197)

at com.glide.schedule.JobExecutor.execute(JobExecutor.java:177)

at com.glide.schedule.JobExecutor.execute(JobExecutor.java:167)

at com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:577)

at com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$2(SchedulerWorkerThread.java:396)

at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)

at com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:396)

at com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:172)

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:1526)

... 38 more

Any ideas on what can fix this? It looks like it maybe just doesn't finish in time and cancels. This doesn't occur every day, only every once in a while, and started last week.