[PA AppSec] Daily Data Collection completed with error email

[sbh]

For the first time in the over 2 years we've been using ServiceNow, I got an email in my SNow admin email account with subject "[PA AppSec] Daily Data Collection completed with error". I found the PA job log and filtered for Level = error and got the error below. PDFs, screenshots attached. Does anyone have any idea what could have generated this or where I should look to find more information? Thanks in advance for any help!

Error collecting for 20210416. Clearing the flushed snapshots for job run with log sys_id 9b4287ad1b6320108e1821f8bc4bcb9c java.lang.NullPointerException
    at com.snc.pa.dc.Row.getValue(Row.java:204)
    at com.snc.pa.db.PADBUtils.getPrimaryKeyValue(PADBUtils.java:235)
    at com.snc.pa.dc.DataCollector.map(DataCollector.java:1130)
    at com.snc.pa.dc.DataCollector.collect(DataCollector.java:542)
    at com.snc.pa.dc.DataCollector.collect(DataCollector.java:390)
    at com.snc.pa.dc.DataCollector.collect(DataCollector.java:302)
    at com.snc.pa.dc.DataCollectorJob.collect(DataCollectorJob.java:316)
    at com.snc.pa.dc.DataCollectorJob.collectWithMutex(DataCollectorJob.java:229)
    at com.snc.pa.dc.DataCollectorJob.execute(DataCollectorJob.java:214)
    at com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:113)
    at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:116)
    at com.glide.schedule.JobExecutor.execute(JobExecutor.java:100)
    at com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:300)
    at com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:188)
    at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
    at com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:188)
    at com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:102)

[Surabhi7]

Hello,

Did you get any answer on this? We also started seeing this error in Paris.

Thanks,
Surabhi

[sbh]

HI/support created a case from this post and they got back to me asking if we'd gotten the error more than once, and if we'd gotten it on subproduction instances too.

We only got this error once (that I know of) and that was on our production instance the day the Paris patch 7 was applied. Our dev and test instances didn't get this error when the patch was applied to them.

[sbh]

No, not yet. Yesterday I got an email from support that created a case for this issue. That, plus your experience, makes me wonder if a number of other people are experiencing this. If there's any progress on the case I'll post it here.

Thanks very much for writing. I'm sorry you're experiencing this too but it's good to know we're not the only ones.

[Marek Krcma]

Hi, I am also getting the same error for Problem management content pack PA daily job (Paris), sometimes it collects ok, sometimes it ends "Collected with errors". KB article posted here goes to documentation and did not find there how to resolve this issue.

Error collecting for 20210521. Clearing the flushed snapshots for job run with log sys_id 9a91ac95db14b410b79f99fbd3961960 java.lang.IllegalStateException: Sparse storage format has one field, sys_id
at com.glide.db.meta.SparseStorage.getValue(SparseStorage.java:70)
at com.snc.pa.dc.Row.getValue(Row.java:204)
at com.snc.pa.dc.Script.evaluate(Script.java:173)
at com.snc.pa.dc.DataCollector.evaluateScript(DataCollector.java:462)
at com.snc.pa.dc.DataCollector.collect(DataCollector.java:538)
at com.snc.pa.dc.DataCollector.collect(DataCollector.java:390)
at com.snc.pa.dc.DataCollector.collect(DataCollector.java:302)
at com.snc.pa.dc.DataCollectorJob.collect(DataCollectorJob.java:316)
at com.snc.pa.dc.DataCollectorJob.collectWithMutex(DataCollectorJob.java:229)
at com.snc.pa.dc.DataCollectorJob.execute(DataCollectorJob.java:214)
at com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:113)
at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:116)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:100)
at com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:300)
at com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:188)
at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
at com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:188)
at com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:102)