De-duplication task remediation error

[jayanthiare]

I'm unable to delete the CIs. The error message suggests that a Business Rule or Restricted Cascade Delete Rule on related items may be preventing the deletion.

below is the error 

"Failed to delete these CIs:xxxxxxxxxxxx
Note:'Business Rule' or 'Ristrict Cascade Delete Rule', on one or more tables of 'Related Items', can prevent CI from getting deleted.
Retry remediation after cleaning the references to these CIs manually."

Could you help identify the blocking references or rules, and confirm whether manual cleanup is required before retrying the remediation?

[vaishali231]

hey @jayanthiare 
To identify you can follow these steps:
1. Check for related records
Configuration Items are often referenced by other records such as Incidents, Change Requests, Problems, Tasks, or CI Relationships (cmdb_rel_ci).
Review the Related Lists on the CI form

Pay special attention to CI Relationships (parent/child)

If references exist, they may need to be removed or updated before deletion

2. Review CI Relationships explicitly
Even if not obvious, relationships in cmdb_rel_ci can block deletion.
Open the CI

Use the Relationship Editor

Remove any dependent relationships if appropriate

3. Analyze Business Rules on cmdb_ci
A Before Delete Business Rule can prevent deletion using setAbortAction(true).
Check Business Rules

Filter:

Table = cmdb_ci
When = before
Operation = delete

Review scripts for any blocking logic

4. Check for Restricted Cascade Delete Rules
If a referencing field has the attribute restrict_cascade_delete=true, deletion will be blocked when dependent records exist.
Navigate to System Definition - Dictionary

Identify fields referencing cmdb_ci

Review attributes for cascade restrictions

5. Use Delete Preview
Attempting to delete the CI via the UI can provide more insight:
Right-click the record - Delete

The platform may display dependent records preventing deletion

*************************************************************************************************************************************

If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.
Regards
Vaishali Singh

[jayanthiare]

Thanks for your reply, let me try all the ways and will get back if it works.