How to stop cascade deletes in CI relations


Customer was performing a large deletion of Cis in the cmdb. They noticed that when they did this, the action of deleting a CI would also delete, in some instances, some of the CIs related to the CI. The relations are stored in the cmdb_rel_ci table.

For example: A linux server with Oracle databases. You delete the Linux server and as a result the database CIs through their relationship with the main Linux CI are deleted.

This was undesirable for this customer. Normally it makes sense for these cascade deletes to occur. However for this customer they did not want this. 


To stop this cascade delete of the CI relations. The out of the box system property glide.db.record_cascade_delete  should be set to false