cmdb_software_product_model deleting data

[Ashwin27]

Hi 

i am deleting some records from cmdb_software_product_model and got following error,

Background message, type:error, message: SoftwareModelName is not allowed because it is referenced in record SoftwareModelName within the Base Configuration Item table

i have deleted data from CMDB table and it data got deleted from cmdb_software_product_model and CMDB table

but just want to confirm best practice on deleting data , will it fine to delete from CMDB itself or any other way?

will it delete all reference data from other tables too?

Regards

Ashwin

[Fabian Kunzke]

Hey,

generally speaking, data within the CMDB should only be deleted through a remediative process (e.g. when resolving duplicates). Outside of that, I would personally recommend to retire entries instead.

The issue you are encountering is a check, which runs ootb. It looks in the CMDB if any CIs reference the model you are deleting (this is also the case whenever you try to delete a hardware model). If an entry is found, it will prevent anyone from deleting the product model.

To address this, you will need to first look for any CIs referencing the Model (easiest way is to do this on the cmdb_ci level) and change that reference to the model they should link to. Only then can you delete the product model.

Regards

Fabian