Notifications

220 views

Description

Running a report that includes many variables on many tables (60 or more) 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.

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

Workaround

Create multiple reports, each of which have joins from less than 60 tables. These will export successfully.

Note: 1 variable = 1 join

This issue is under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In and Intended Fix Version fields to determine whether any versions have or are planned to have a permanent fix.

 


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

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-09-07 09:39:18
Published:2018-08-10