Notifications

523 views

Description

When an index in a TPP hierarchy exists on a secondary partition but not the primary, large table optimization will attempt to ignore the index on the primary partition, resulting in SQL exceptions and empty lists.

Steps to Reproduce

Tested in Kingston and London:
1) Create a new index on the sys_updated_on field using the Index Creator in Tables & Columns module.
2) Add the dictionary attribute "largeTable=true" to cmdb_ci.
3) Open the list view for cmdb_ci and sort the list by the "Updated" column.
4) Observe SQL exception, either in UI or the logs:
SEVERE *** ERROR *** FAILED TRYING TO EXECUTE ON CONNECTION 4: SELECT cmdb0.`sys_id` FROM cmdb cmdb0 ignore index(sys_updated_on) WHERE cmdb0.`sys_class_path` LIKE '/!!/!E/!!/!$/!3%' ORDER BY cmdb0.`sys_updated_on` DESC limit 0,20
Syntax Error or Access Rule Violation detected by database (Key 'sys_updated_on' doesn't exist in table 'cmdb0')

Workaround

Set the system property glide.db.optimize.root_table.cmdb=false. If this alone does not address the problem, you may need to also add the dictionary attribute smallTable=true to the cmdb_ci table's sys_dictionary collection record.

NOTE: This change may present a performance impact. Be sure to test in a sub-prod environment to evaluate the impact of this change.


Related Problem: PRB1321133

Seen In

London
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - Audit Management PA Content - Madrid 2019 Q1
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Policy and Compliance PA Content - Madrid 2019 Q1
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - Risk Management PA Content - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - CMDB CI Class Models - 201908
SR - ITOM - CMDB CI Class Models - 201909
SR - ITOM - Discovery and Service Mapping - 201908
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - ITOM - Fundamentals Istanbul Jakarta Kingston r1 - v5.99.6
SR - SecOps - Configuration Compliance - New York 2019 Q3
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - CrowdStrike Intel Integration - Madrid 2019 Q1
SR - SIR - ElasticSearch Integration - Madrid 2019 Q1
SR - SIR - Palo Alto WildFire Integration - New York 2019 Q3
SR - SIR - RecordedFuture Integration - New York 2019 Q3
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Security Incident Response UI Patch - London 2019 Q2 v.6.2.3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - SIR - Threat intelligence - New York 2019 Q3
SR - SIR - VirusTotal Integration - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Intended Fix Version

New York Patch 9
Paris

Fixed In

Orlando Patch 4

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:2020-05-08 06:50:32
Published:2019-02-22