Issues with Performance Analytics Automated Indicators - Number of Resolved Incidents does not return any data.

salil1 · ‎06-16-2015

I am using a trial version of Performance Analytics & trying to collect the data under Dashboards using the Automatic Indicators. I have also scheduled a job [PA Trial Incident] Daily Data Collection to be run daily. The job is running successfully with no errors / warnings & fetches data for all indicators (Open Incidents / Backlog Incidents) however doesn't fetch any data for job indicator No of Resolved Incidents (It is not fetching data for any indicator related to Resolved incidents). The data was fine till yesterday but not sure what is the problem today.

The job is scheduled to run daily & is running at scheduled time. Data for all other Indicators & breakdown is fine. I am new to using ServiceNow & have admin role.

Job logs below:

Any suggestions?

Vincent Loffel1 · ‎06-16-2015

Hi Salil,

As you can see at log ID 7 is the query that's been used for the indicator Incidents.Resolved. On id 8 it says 0 rows are fetched. This means you query returned no data.

This could have two reasons; either there is no data or there is a problem with your query. Is it possible to show a job log from the last day it worked like it should? That might help solving the issue.

salil1 · ‎06-16-2015

Hello Vincent,

Thank you for your reply. It was populating results till yesterday. The data is available for sure as I tried to pull it manually by going through Reports.

Also the indicator source is showing the data.

Previous Successful Job Log.

Any thoughts?

Vincent Loffel1 · ‎06-16-2015

Hi Salil,

If you open the job and hover over the indicators with a incidents.resolved indicator source. Do they have the box Collect indicator ticked? If it doesn't that might be the problem.

Another option is when you go to the indicator source, it shows 38 records matching. Click on the double yellow arrows behind it, does the number change? And if you click on the 38 matching records, do they show up in the list?

Vincent Loffel1 · ‎06-16-2015

There could also be something else. If you go to the indicator, does the source look like this?

Collect records must be ticked.