[PA AppSec] Daily Data Collection completed with error email

sbh
Tera Guru

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)

 

1 ACCEPTED SOLUTION

ServiceNow Tec2
Mega Sage
This has been resolved by ServiceNow Technical Support. Please refer to KB0799486 for more information.

View solution in original post

12 REPLIES 12

We are experiencing this same issue, but the link to the KB article isn't valid. Is there an answer for this? I tried the steps above but the indicator did not have a record under 'Performance Analytics Text Index Configurations '. 

sbh
Tera Guru

A consultant who was working with us fixed this by upping the limit on the system property com.snc.pa.dc.max_records. Thank you, @Ofuoma Ikogho !

You are most welcome @sbh