[PA Incident SLA] Daily Data Collection job is not completing successfully.


Release or Environment

This plugin is by default active in instances created after Fuji release but if instance was created before Fuji this plugin is inactive.


Reviewed the indicator sources for the collection job:  Incidents.SLA.Resolved, and Incidents.SLA.Open

The Resolved field shown in the OOB indicator sources are shown as a blank condition in the filter.


The errors in the collection are due to the conditions present in the indicator sources Incidents.SLA.Resolved, and Incidents.SLA.Open
The additional conditions of these indicator sources are using a field from incident table 'resolved_at' which is currently not present in your instance and so while running the job you see these errors.

Therefore, the indicator sources in your instance for Incidents.SLA.Resolved , Incidents.SLA.Open and Incidents.OLA.Open has in the filter condition the resolved field which is blanked out.

The resolved_at and resolved_by fields on the incident table are available as part of a plugin 'Incident Resolution Fields' which is currently inactive in your instance.
If you activate this plugin these fields will be available in your incident table and so the collection errors would be resolved too.

Apply the "Incident Resolution fields" plugin to allow indicator sources to build properly.

Article Information

Last Updated:2019-08-28 08:37:58