16 views

Description

Exporting a report that includes many variables to Excel causes SQL Exception "Unknown column 'sc_item_option.value' in 'field list'".

Steps to Reproduce

 

  1. Navigate to Reports > Create New.

  2. Select the Data table "Requested Item [sc_req_item]".

  3. Customize the columns by selecting Variables in the Columns Available.

  4. Click the + sign that appears above the < and > arrows.

  5. In the Catalog Items window, search for and select 'DG - Data Quality Issue Form'.

  6. Select and add all the variables for DG - Data Quality Issue Form (approximately 75 variables).

    https://hfhsdev.service-now.com/item_option_new_list.do?sysparm_query=cat_item!%3DNULL%5EGOTOcat_item.nameLIKEDG%5Ecat_item%3Dcce6f898ac327100aca2265fc8d82cdf%5Eactive%3Dtrue

  7. Add a condition so fewer records are retrieved, for example, opened by 'Guest'.

  8. Run the report.

    The report runs successfully and the data is displayed correctly on the UI.

  9. Right-click on the header and select Export to Excel.

    The resulting Excel export contains only the headers and no data, and the following error is seen in the logs:

    "Syntax Error or Access Rule Violation detected by database (Unknown column 'sc_item_option.value' in 'field list')".

Workaround

Create multiple reports rather than a single report so that fewer variables need to be exported.


Related Problem: PRB675410

Seen In

Fuji Patch 13
Fuji Patch 9 Hot Fix 1
Geneva Patch 4
Geneva Patch 5
Geneva Patch 6
Geneva Patch 6 Hot Fix 2
Geneva Patch 9
Helsinki Patch 3

Intended Fix Version

Madrid

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-04-26 01:37:47
Published:2018-04-26