How to resolve slow business rule loading caused by the Related Slow Patterns related list - Known Error

How to resolve slow business rule loading caused by the Related Slow Patterns related list Description Resolve slow business rule loading caused by the Related Slow Patterns related list in the Application Insights application.

When the Application Insights application is installed, the Related Slow Patterns related list causes business rules to load slowly. This appears in performance logs as the slow script SlowPatternToScriptsMappingCreator ( SSI_cd86ed7a530030102e10ddeeff7b1258 ).

Steps to Reproduce

Install the Application Insights application. Go to any business rule on an instance with many slow patterns recorded. Expected result: The business rule loads quickly.

Observed result: The business rule takes up to 20 seconds to load.

Workaround Three options are available depending on how broadly you want to remove the Related Slow Patterns related list. Select the option that best fits your requirements.

Note: Options 1 and 2 require changes to the private scope of the Application Insights application. Contact ServiceNow Technical Support to apply these changes, as elevated access is required.

Option 1: Disable the script that generates the related list (all forms)

Use this option if you do not use the Related Slow Patterns related list anywhere on your instance. This option disables the source of the related list and has no other impact. It can be reverted if needed.

Go to the Virtual Table [sys_script_vtable] table. Open the record sys_script_vtable_96ca48f7537320102e10ddeeff7b1292 . Set the record status to Inactive. Option 2: Remove the related list from specific tables (all forms for those tables)

Use this option if you do not use the Related Slow Patterns related list on any form and want to remove it from all related tables.

Go to /sys_ui_related_list_list.do . Filter the list by Application = Application Insights. For each record where the Table field is one of the following, either delete the record or set the Table field to --None--: sys_query_pattern sys_script sys_script_client sys_script_pattern sys_trigger sys_ui_action Option 3: Remove the related list from a single form only

Use this option if you want to remove the Related Slow Patterns related list from a specific form — for example, business rules — but keep it on other forms such as script includes.

Go to any business rule form. Select the form context menu (the stacked icon in the form header). Select Configure > Related Lists. Remove Related Slow Patterns from the related lists for this form. Related Problem: PRB1764110