Q: What causes Performance Analytics Indicator Not Collecting Data?

Data collection job not running or failing — Navigate to System Logs > System Log > All and filter for 'pa_data_collector' or check pa_job_run table for recent job execution records. Look for error messages or missing job runs for your indicator. Source table filter returning no records — Check the indicator's Data Source > Filter conditions against the actual source table data. Run a quick count query on the source table with the same filters to verify records exist. Time series configuration excludes current period — Review the indicator's Time Series tab for start date, frequency settings, and breakdown configuration. Verify the time range includes today's date and matches your data collection expectations. Indicator set to manual collection mode — Check the indicator's Collection tab for Collection Type field. If set to 'Manual', the automated collection jobs will skip this indicator entirely. Formula references non-existent fields — Examine the indicator's Formula tab for field references that don't exist in the source table. Check sys_db_object and sys_dictionary tables to verify all referenced fields are valid. Performance Analytics plugin incomplete activation — Navigate to System Definition > Plugins and verify com.snc.pa is Active. Check System Logs for any plugin activation errors or missing dependencies during initial setup.

Question 1

What causes Performance Analytics Indicator Not Collecting Data?

Accepted Answer

Data collection job not running or failinghigh likelihood

Navigate to System Logs > System Log > All and filter for 'pa_data_collector' or check pa_job_run table for recent job execution records. Look for error messages or missing job runs for your indicator.

Source table filter returning no recordshigh likelihood

Check the indicator's Data Source > Filter conditions against the actual source table data. Run a quick count query on the source table with the same filters to verify records exist.

Time series configuration excludes current periodmedium likelihood

Review the indicator's Time Series tab for start date, frequency settings, and breakdown configuration. Verify the time range includes today's date and matches your data collection expectations.

Indicator set to manual collection modemedium likelihood

Check the indicator's Collection tab for Collection Type field. If set to 'Manual', the automated collection jobs will skip this indicator entirely.

Formula references non-existent fieldsmedium likelihood

Examine the indicator's Formula tab for field references that don't exist in the source table. Check sys_db_object and sys_dictionary tables to verify all referenced fields are valid.

Performance Analytics plugin incomplete activationlow likelihood

Navigate to System Definition > Plugins and verify com.snc.pa is Active. Check System Logs for any plugin activation errors or missing dependencies during initial setup.

Question 2

How do you fix Performance Analytics Indicator Not Collecting Data?

Accepted Answer

How to fix it Navigate to Performance Analytics > Administration > Data Collector Jobs to check if collection jobs are running. Look for your indicator name in recent job runs. If no recent jobs exist, go to System Definition > Scheduled Jobs and search for 'PA Data Collector'. Verify the job is active and check the Next Action time. Open your problematic indicator and click the Data Source tab. Note the source table and any filter conditions. Navigate to the source table (e.g., incident, change_request) and apply the same filter conditions from your indicator. Verify records exist that match these criteria. If no records match, adjust the indicator's filter conditions in the Data Source > Conditions section to match your actual data. Check the Time Series tab. Verify the Start date is not in the future and the Frequency matches your expected collection schedule (Daily, Weekly, Monthly). Navigate to the Collection tab and ensure Collection Type is set to Automated, not Manual. Review the Formula tab for any field references. Verify all referenced fields exist in the source table by checking System Definition > Tables and viewing the table's columns. If the indicator was recently created or modified, manually trigger data collection by clicking Collect Now in the indicator's Related Links section. Monitor the collection by navigating to System Logs > System Log > All and filtering by Source = com.snc.pa for real-time collection status. Check the pa_scores table directly by going to System Definition > Tables, opening pa_scores, and filtering by your indicator's sys_id.

Question 3

How do you prevent Performance Analytics Indicator Not Collecting Data?

Accepted Answer

Always test your indicator's source table filters in a list view before activating the indicator to ensure data exists. Set up Performance Analytics data collection monitoring by creating a scheduled report on the pa_job_run table to catch failed collections early. Use the 'Preview' feature in the indicator creation wizard to validate your formula and time series configuration before saving. Document your indicator's expected data sources and collection frequency in the Description field for future troubleshooting reference. Create a simple test indicator first when setting up PA on a new instance to verify the collection framework is working properly.

Performance Analytics Indicator Not Collecting Data

Symptom

Possible Causes

Debugging this in a real instance?

Solution

How to fix it

Prevention Tips

Test Your Knowledge