BugZero | ServiceNow BugID PRB1864803 - CMDB archive tables cause CMDB deletes to be slow

ServiceNow - Defect ID: PRB1864803

CMDB archive tables cause CMDB deletes to be slow

ServiceNow - Defect ID: PRB1864803

CMDB archive tables cause CMDB deletes to be slow

Last updated on August 2nd, 2025

BugZero Risk Score
5.8 Medium

Overall: 5.8

Severity: 6.4

Community: 3.7

Lifecycle: 9.1

What is the BugZero Risk Score?

ServiceNow Integration

Learn more about where this data comes from

ServiceNow Integration

Learn more

Bug Scrub Advisor

Streamline upgrades with automated vendor bug scrubs

Bug Scrub Advisor

Learn more

BugZero Enterprise

Wish you caught this bug sooner? Get proactive today.

BugZero Enterprise

Learn more

Bug Details

Priority: Sev3
Article Views: 14
Affected Component: Miscellaneous

Description

When a record is deleted, the platform runs a cascade delete. If many CMDB archive tables exist, the CMDB cascade delete can be slow.

Steps to Reproduce

Create and run an Archive rule on the CMDB table. Archive tables are created for each class which can result in hundreds of CMDB archive tables. Each of these has a copy of the duplicate_of column from the base cmdb table, which is a reference to the cmdb_ci table. Delete a CI from the cmdb_ci table and observe a query for each CMDB archive table checking for references.

Workaround

This problem is currently under review and targeted to be fixed in a future release. Subscribe to this Known Error article to receive notifications when more information will be available.

Related Problem

PRB1864803

Change history

2025-08-02 Added: Washington DC Patch 1, Washington DC Patch 1 Hot Fix 2a, Washington DC Patch 10 Hot Fix 2, Washington DC Patch 10 Hot Fix 2a, Washington DC Patch 10 Hot Fix 3b, Washington DC Patch 10 Hot Fix 4, Washington DC Patch 2, Washington DC Patch 2 Hot Fix 1, Washington DC Patch 3, Washington DC Patch 3 Hot Fix 1, Washington DC Patch 5, Washington DC Patch 9, Xanadu Patch 1 Hot Fix 2, Xanadu Patch 1 Hot Fix 2a, Xanadu Patch 1 Hot Fix 3b, Xanadu Patch 2, Xanadu Patch 3, Xanadu Patch 3 Hot Fix 1, Xanadu Patch 4, Xanadu Patch 4a, Xanadu Patch 4b, Xanadu Patch 4b Hot Fix 2, Xanadu Patch 5, Xanadu Patch 6, Xanadu Patch 7, Xanadu Patch 7a, Xanadu Patch 7b Hot Fix 1, Xanadu Patch 8, Xanadu Patch 8 Hot Fix 1, Xanadu Patch 8 Hot Fix 3, Xanadu Patch 9, Xanadu Patch 9 Hot Fix 1, Xanadu Patch 9a, Zurich

Relevant Products

Click on a version to see all relevant bugs

Fixed versions: No known fixed versions

Relevant Products

Click on a version to see all relevant bugs

Fixed versions: No known fixed versions

Top ServiceNow Defects

9.4Defect ID: PRB1954123
Instance access issues due to Mutual TLS (mTLS) enablement on Zurich instances
8.5Defect ID: PRB1611377
CMDB Baseline creation job causing app node out of memory when a CI has a huge number of records referencing it
8.5Defect ID: PRB1788540
AWS Events Driven discovery is overloading Default Semaphores.
8.5Defect ID: PRB1871576
Data visualization can be accessed by anyone with URL to visualization designer
8.5Defect ID: PRB1928008
Upgrade to Yokohama releases can hang for Haraka enabled instance because of contention on kagami query registrar

Ready to prevent the next vendor outage?

Get a demo

Links

Original Vendor Announcement

ServiceNow Integration

Learn more about where this data comes from

ServiceNow Integration

Learn more

Bug Scrub Advisor

Streamline upgrades with automated vendor bug scrubs

Bug Scrub Advisor

Learn more

BugZero Enterprise

Wish you caught this bug sooner? Get proactive today.

BugZero Enterprise

Learn more

ServiceNow - Defect ID: PRB1864803

CMDB archive tables cause CMDB deletes to be slow

ServiceNow - Defect ID: PRB1864803

CMDB archive tables cause CMDB deletes to be slow

Last updated on August 2nd, 2025

BugZero Risk Score5.8 Medium

Bug Details

Description

Steps to Reproduce

Workaround

Related Problem

Top ServiceNow Defects

Ready to prevent the next vendor outage?

Links

BugZero Risk Score
5.8 Medium