Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
PA - Data collector Error: "Fetched too many rows from indicator source <IndicatorSourceName>. Allowed: 50,000 fetched: <NumberGreaterThanAllowed>" but Previewing on the Indicator Source gives a smaller (incorrect) count - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • PA - Data collector Error: "Fetched too many rows from indicator source <IndicatorSourceName>. Allowed: 50,000 fetched: <NumberGreaterThanAllowed>" but Previewing on the Indicator Source gives a smaller (incorrect) count
KB0725638

PA - Data collector Error: "Fetched too many rows from indicator source <IndicatorSourceName>. Allowed: 50,000 fetched: <NumberGreaterThanAllowed>" but Previewing on the Indicator Source gives a smaller (incorrect) count


5216 Views Last updated : Jul 22, 2025 public Copy Permalink
KB Summary by Now Assist

Issue

PA Data collection jobs can error out or provide warnings based on the amount of data that is being collected for an indicator source. Although, if you click the Preview button on the Indicator Source, the count of the rows fetched is lesser than the value of the property "com.snc.pa.dc.max_row_count_indicator_source"

Error Text from the job logs "Performance Analytics > Data Collector > Job Logs":

"Fetched too many rows from indicator source <IndicatorSourceName>. Allowed: <SysPropertyValue> fetched: <NumberGreaterThanAllowed>"

Release

All Releases 

Cause

If there is a read ACL or a Query Business Rule on the Indicator Source table, the count from the Preview button may be different from the actual count. The records fetched by the Data Collection job is not restricted by ACLs or Business Rules.

Resolution

  • Option 1:

- Select the "Admin Overrides" option on any read ACLs on the table.

- Add a condition on the query business rule(s) to not run for admin users by adding "!gs.hasRole('admin')" in the condition field.

After doing these changes, login as admin user, and the Preview option should give the right count for the Indicator Source.

 

  • Option 2:

Replace the <Indicator_Source_Encoded_Query> and <TABLE_NAME> in the below script with the encoded query and table name for the indicator source and run the script from Scripts - Background.

To get the Encoded query from the Indicator source:

- Open the Indicator Source record for which you are getting the error.
- Click the Preview button
- Click on the record count to open the records in a new tab
- Right click on the filter breadcrumb and select the 'Copy query' option.

var gr = new GlideRecord('<TABLE_NAME>'); 
gr.addEncodedQuery('<Indicator_Source_Encoded_Query>');   
gr.setWorkflow(false);
gr.query(); 
gs.info("Indicator source Row Count" gr.getRowCount());

The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.