Not able to delete record ?

[sukran]

We have duplicate test record in model names and we need to delete on that, but not able to doing this

Below error we get it

Delete of   Test record not allowed because of a reference in record 5czczb within the Base Configuration Item file

Delete of Test record not allowed because of a reference in record 4888BY within the Base Configuration Item file

How to delete this without lose any other file

[staceybailey]

It sounds as if there is a Reference Cascade Rule that is preventing the deletion (See Configure cascade delete rules).

Restrict

Deleting a record is restricted unless there are no references to the record. For example, prevent the user record from being deleted if any incident includes a reference to the user. This option has no effect for tables with m2m relationships, meaning that in this example, if the tables have an m2m relationship, the user record is deleted.

To resolve, you will need to go to your records 5czczb and 4888BY within the Base Configuration Items and remove the reference to the record you are trying to delete.   Once that reference to your record has been removed from ALL locations, you should be able to delete.

Hope that helps.

[sukran]

how to remove the reference field

[staceybailey]

Likely this is just a communication glitch, but I'd rather be safe than sorry here.   🙂

- You should not remove the reference field or change the dictionary entry for the reference field.  

- You should just change the value of the field in the record.   Either clear the value or select another record instead.

So, if I get something like this:

I would go to the asset record P1000123 - Asus G Series.   Then, I would change the reference to the stockroom.   I would either change the reference field value to point to another record or clear it (if it's not a required field).  

After removing all references to the record, you should be able to delete it.

[Alikutty A]

Hi Sukran,

You need to remove the references of the deleted record from 5czczb and 4888BY .

Once you remove it, you can delete the parent record.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response