Notifications

857 views

Description

1. Large numbers of orphan CI relationships can lead to slowdowns when rendering the relationship formatter for a CI. Orphans may be present from Discovery or other CMDB population events. Additionally an instance may be using the relationship exclusion filters to remove many relationships. The exact details are instance and deployment specific.

2. PRB1390753/KB0824597 in Orlando Patch 3 / New York Patch 9 fixed an issue where an incomplete list of L2 relationships were displaying on the relationship formatter, but may be causing excess database transactions to fetch all relationships at levels 2 and above.

Steps to Reproduce

There are no known steps to reproduce as this is a complex instance specific problem.

Workaround

This problem is under review and targeted to be fixed in a future release. To receive notifications when more information becomes available, subscribe to this Known Error article by clicking the Subscribe button at the top right of this form.

1. Disable Filtering “Excluded Relations” from Relationship Formatter: By default, Relationship Formatter excludes all the relationships specified in “cmdb_rel_filter” table. However, this can in some cases result in more DB queries being done to fetch the data for Relationship Formatter, impacting performance. In order to disable this, system property glide.cmdb.relation.filter can be set to false.

2. Another workaround to prevent the issue is to set the system property glide.ui.max_relations to 100 or 200, changing its default higher value 1000, and to set the default relation levels to 1 or 2.

  1. Create a new “User Preference” record to manage the default number of relationship levels fetched.
  2. Go to left nav -> User Preference -> New
  3. Fill out the form per the attached screenshot
  4. Set the depth value to 1 or 2 as needed
  5. Save
  6. Example:


If there is a large number of orphan relationships, contact Technical Support for them to be found and removed from the database via an internal script.



Related Problem: PRB1412232

Seen In

SR - IRM - Audit Management - New York 2019 Q3
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 - Risk Management - New York 2019 Q3
SR - IRM - Risk Management PA Content - Madrid 2019 Q1
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITBM - Essential SAFe Dashboards v1.0
SR - ITBM - Scrum Dashboards Common v1.0.2
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 - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
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 - VR - Rapid7 - London 2019 Q2 v.6.2.1
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Intended Fix Version

Orlando Patch 9
Quebec

Fixed In

New York Patch 11
Paris Patch 2

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-10-26 12:08:58
Published:2020-08-21