Notifications

15 views

Description

When on database views, tables involved may be a mix of domain separated and non-separated. The system then calculates domain spooling rather than domain path, generating the query against the [sys_domain] table, which may impact performance.

Steps to Reproduce

1. Install the plugins Domain Separation - Domain Support - Domain Extensions Installer [com.glide.domain.msp_extensions.installer].
2. Domain separate the kb_knowledge table (Ref.: Add a domain field to a table).
3. Create a new Database view (my_db_view).
4. Add two tables in the view: kb_knowledge (domain separated), sys_properties (not separated).
5. Add the [sys_id] fields to both tables.
6. Add the [sys_domain] and [sys_domain_path] fields to the kb_knowledge table.
7. Go to background scripts and run following command:
gs.print(GlideDomainSupport.getProvider('my_db_view'));

The output result is: *** Script: Domain Spool. This means the query runs against [sys_domain] instead of [sys_domain_path], so impacting performance.

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.

As a workaround to prevent Domain spooling, keep all tables in Database view as Domain separated and make sure sys_domain is always set to Global. 

 


Related Problem: PRB1321137

Seen In

There is no data to report.

Intended Fix Version

Orlando

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:2019-07-25 03:12:36
Published:2019-07-25