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 Collection job fails with error like: Invalid configuration. Unable to process indicator com.snc.pa.dc.InvalidConditionException: Invalid query conditions for indicator INC: Number of incidents resolved in time: taskslatable_business_percenta<=1 - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • PA Data Collection job fails with error like: Invalid configuration. Unable to process indicator com.snc.pa.dc.InvalidConditionException: Invalid query conditions for indicator INC: Number of incidents resolved in time: taskslatable_business_percenta<=1
KB0622241

PA Data Collection job fails with error like: Invalid configuration. Unable to process indicator com.snc.pa.dc.InvalidConditionException: Invalid query conditions for indicator INC: Number of incidents resolved in time: taskslatable_business_percenta<=1


3740 Views Last updated : Apr 7, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

PA Data Collection job fails with error like:  Invalid configuration. Unable to process indicator com.snc.pa.dc.InvalidConditionException: Invalid query conditions for indicator INC: Number of incidents resolved in time:taskslatable_business_percenta<=1

Symptoms


A Performance Analytics Data Collection job fails every time it runs and the log contains an error message similar to this example:

Invalid configuration. Unable to process indicator com.snc.pa.dc.InvalidConditionException:
Invalid query conditions for indicator INC: Number of incidents resolved in time: taskslatable_business_percenta<=100^EQ
at com.snc.pa.dc.Indicator.<init>(Indicator.java:91)
at com.snc.pa.dc.DataCollector.loadDefinitions(DataCollector.java:646)
at com.snc.pa.dc.DataCollector.<init>(DataCollector.java:74)
at com.snc.pa.dc.DataCollector.<init>(DataCollector.java:78)
at com.snc.pa.dc.DataCollectorJob.collect(DataCollectorJob.java:158)
at com.snc.pa.dc.DataCollectorJob.collectWithMutex(DataCollectorJob.java:94)
at com.snc.pa.dc.DataCollectorJob.execute(DataCollectorJob.java:80)
at com.glide.schedule.JobExecutor.execute(JobExecutor.java:83)
at com.glide.schedule.GlideScheduleWorker.executeJob(GlideScheduleWorker.java:204)
at com.glide.schedule.GlideScheduleWorker.process(GlideScheduleWorker.java:142)
at com.glide.schedule.GlideScheduleWorker.run(GlideScheduleWorker.java:59)

Similar errors can occur for different indicators, depending on their definition.

Cause
This issue occurs only in instances that at some point were upgraded from the Dublin release. It happens for indicators that are based on an indicator source that uses a database view as the facts table (for example, incident_metric). During the upgrade from Dublin, condition references to columns were truncated to 30 characters. The column name used in the indicator conditions would consist of the table alias in the view definition (tasklatable in the example message) followed by an underscore and then the field name (business_percentage in the example message). The full name was originally taskslatable_business_percentage but was truncated to taskslatable_business_percenta, which is not valid to use in a filter because the field business_percenta does not exist.

Resolution


Manually fix the conditions on the affected indicators.

  1. Navigate to Performance Analytics > Indicators > Automated Indicators.

  2. Find the indicator mentioned in the error and open it.

    Note that any condition affected by this issue will NOT be displayed in the form because it is not valid, although it can be seen in the raw data.

  3. Click the Additional Actions (hamburger) icon in the header and select Show XML.

  4. In the XML window, find the '<conditions>' tag, which shows the original conditions that were entered, including the one that causes the error.

    For the example message, the conditions include "taskslatable_business_percenta<=100". That condition does not appear on the form, so it needs to be re-entered.

  5. Go to the Additional Conditions tab and add a condition in the form by selecting the appropriate field (label) and the appropriate predicate.

    For the example message, for example, you would enter [Business elapsed percentage] [less than or is] [100].

  6. Repeat this process for all indicators that have the error.

  7. Save all changes.

  8. Run the daily job (execute now).

    Confirm that it now runs successfully.

 


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.