Performance Analytics - job error

Community Alums · ‎05-17-2016

Hello everyone,

We're trying to figure out why we are getting the following error in one of our job logs (see below). Any ideas?

The message is super vague.

Thanks!!

Error collecting for 20160516 java.lang.NullPointerException

at com.snc.pa.dc.Script.getStringResult(Script.java:90)

at com.snc.pa.dc.Script.getStringListResult(Script.java:98)

at com.snc.pa.dc.Breakdown.getValues(Breakdown.java:54)

at com.snc.pa.dc.Breakdown.getElements(Breakdown.java:46)

at com.snc.pa.dc.DataCollector.map(DataCollector.java:307)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:175)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:127)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:83)

at com.snc.pa.dc.DataCollectorJob.collect(DataCollectorJob.java:138)

at com.snc.pa.dc.DataCollectorJob.collectWithMutex(DataCollectorJob.java:85)

at com.snc.pa.dc.DataCollectorJob.execute(DataCollectorJob.java:71)

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

at com.glide.schedule.GlideScheduleWorker.executeJob(GlideScheduleWorker.java:191)

at com.glide.schedule.GlideScheduleWorker.process(GlideScheduleWorker.java:135)

at com.glide.schedule.GlideScheduleWorker.run(GlideScheduleWorker.java:57)

Vincent Loffel1 · ‎05-20-2016

Hi veronica,

Could you please copy more lines of the job log? Without this information i can only say that a null pointer exception has occurred, but that doesn't help either. 🙂

Please start with the info line that says "collecting for {date}" and the last line should be "Stored collected results".

Cheers,

Vincent

Slawek_Radziewi · ‎09-13-2017

Hi Vincent

I have similar errors when running jobs with com.snc.pa.domain_support plugin enabled.

- Processing Indicator Source Incidents.SLA.Resolved

- Starting collection

- Applying map/reduce function for indicator source Incidents.SLA.Resolved

- Fetching "taskslatable_business_percentage,inc_priority,inc_u_business_services,taskslatable_sla.sys_domain,taskslatable_sla,inc_sys_id,inc_assignment_group,inc_category" from "incident_sla"

- Stored collected results

- Stored 'Value when nil': 0.0 as score for indicator: Number of incidents resolved in time

- Fetching "taskslatable_business_percentage,inc_priority,inc_u_business_services,taskslatable_sla.sys_domain,taskslatable_sla,inc_sys_id,inc_assignment_group,inc_category" from "incident_sla"

- Collecting for 20170912 finished

- Applying map/reduce function for indicator source Incidents.SLA.Resolved

- Error collecting for 20170910 java.lang.NullPointerException

at java.util.ArrayList.addAll(ArrayList.java:577)

at com.snc.pa.domain.dc.DomainConfig.getDomainsToEmit(DomainConfig.java:97)

at com.snc.pa.dc.DataCollector.map(DataCollector.java:450)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:272)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:214)

at com.snc.pa.dc.DataCollector.collect(DataCollector.java:172)

at com.snc.pa.dc.DataCollectorJob.collect(DataCollectorJob.java:246)

at com.snc.pa.dc.DataCollectorJob.collectWithMutex(DataCollectorJob.java:162)

at com.snc.pa.dc.DataCollectorJob.execute(DataCollectorJob.java:147)

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

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

at com.glide.schedule.GlideScheduleWorker.executeJob(GlideScheduleWorker.java:219)

at com.glide.schedule.GlideScheduleWorker.lambda$process$48(GlideScheduleWorker.java:161)

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

at com.glide.schedule.GlideScheduleWorker.process(GlideScheduleWorker.java:161)

at com.glide.schedule.GlideScheduleWorker.run(GlideScheduleWorker.java:72)

- Select query running here.

- Fetched 407 rows from incident_sla

- Starting to analyze table pa_scores

Here some data has been fetched and added to pa_scores but in other cases (jobs) nothing is added.

Vincent Loffel1 · ‎09-14-2017

Hi Slawomir,

Please look at which indictors are using the indicator source Incident.SLA.Resolved. For every indicator, check whether it uses a script to calculate the result OR if it has a breakdown that uses a scripted breakdown mapping.

Most likely one of the scripts are causing the issue.

Another scenario is that one indicator (that uses the indicator source Incident.SLA.Resolved) contains additional conditions that are either incorrect or corrupt (for this you would need to check the xml of the indicator)

Cheers,

Vincent

Slawek_Radziewi · ‎09-14-2017

Hi Vincent

Indicator does not have any scripts.

Breakdowns are rather standard without scripts as well.

I have checked xml and I don't see the problem.

<conditions table="incident_sla">taskslatable_business_percentage<100^EQ<item goto="false" or="false" field="taskslatable_business_percentage" endquery="false" value="100" operator="<" newquery="false"/>

</conditions>