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.
Reports containing a variable field only show the first record and generate a NullPointerException error - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • Reports containing a variable field only show the first record and generate a NullPointerException error
KB0639102

Reports containing a variable field only show the first record and generate a NullPointerException error


3951 Views Last updated : May 23, 2024 public Copy Permalink
KB Summary by Now Assist

Description

When attempting to create reports, if adding a field from a variable, the report will default to only show the first record retrieved from the query.

The instance log will contain the error: SEVERE *** ERROR *** null:301:2353: <g2:list_item_style> java.lang.NullPointerException.

Further, if using group by, it will recognize other records are available but not show them.


Steps to Reproduce

  1. Edit a catalog item such as Submit an IT request.
  2. Add these variables: Incident Number (reference type to incident), Incident description (multi-line text).
  3. Submit the catalog item a few times to generate some records in sc_req_item.
  4. Set the system property glide.ui.optimize.lists to false.
  5. Create a report on the requested item table (sc_req_item), andadd a filter for Item = <catalog item created or Submit an IT Request>.
  6. Run the report. Observe only one record is displayed, even though there are many records.
  7. Remove the filter and run the report again. Observe all records are shown.


Workaround

This issue is fixed in all currently supported versions. Please review the Fixed In section to determine the latest available patch your instance can be upgraded to.

The recommended workaround is to have both properties listed below set to their default value of true:

glide.ui.optimize.lists=true 

glide.ui.list.optimize=true


Also see the workarounds to the behaviour described in PRB573139/KB0529493 - In list view ACLs on referenced dot-walked records are evaluated only against the specific displayed derived fields .
Dot-walked fields in a list report may not load properly if the referenced property glide.ui.list.optimize is set to true as recommended.


Related Problem: PRB1162821

Potentially Seen In

There is no data to report.

Fixed In

Jakarta Patch 10
Jakarta Patch 8a Hot Fix 2
Jakarta Patch 9c Hot Fix 2
Kingston Patch 7
London

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.