Unable to Delete Fields

sheikhassan
Tera Expert

I need to delete some of the dictionary entries but couldn't. I am getting the below highligted message in those entries. But the worst part is, when I click to open the editable first element it shows "Record not found". Now i need a way to delete this kind of dictionary entries. This issue happened in cmdb_ci_appl table. When a custom field is created in Application table, the system creates more than 200 entries i.e. to child tables also I guess. Is this is normal?

Message:

"This cloned descendant element is read-only, Click here to open editable first element in a new window."

Any help is appreciated.

Thanks

 

 

8 REPLIES 8

Kamal17
Kilo Sage

Hi,

 

It's normal that on creating a field in parent table, the same will be replicated to all its child tables. Though 200 is bit high in your case, I would suggest not to delete the dictionary entries as they are autocreated by system.

 

Mark Correct if this solves your issue. Hit Like/Helpful based on the impact.

Regards,

Udhay

Thanks for replying.

But the problem is, I need to create the same field in Application table but the system is not allowing to create and throwing error. 

For understanding,

1. Created field "u_test" in cmdb_ci_appl table, the same field got created in multiple cmdb tables (may be child tables of application).

2. Somehow the "u_test" field got deleted from cmdb_ci_appl but not in child tables.

3. I need to create the same "u_test" field in cmdb_ci_appl again, but i cannot do that. 

 

I hope you understand the issue.

 

So, what probably happened is someone went to delete the field, and the transaction timed out, stopping it before it deleted all of those child entries.

 

Is this on a Production instance?  If not, a clone over and then re-doing the initial deletion(if still needed) with transaction quotas turned off might be the answer.  If its on Production, you probably need to get assistance from ServiceNow.

Priyanka136
Mega Guru

Hi Sheikhassan,

 

You can delete the custom fields that you can created. Custom field starts with u_. 

It is recommended that you remove the field from forms and lists. 

You cannot delete base system fields. In addition, any missing base system fields are recreated when the instance is upgraded.

 

Procedure :

1. Navigate to a form that contains custom field to delete.

2. Right click the field label and select Configure Dictionary.

3. Click Delete Column in the form header, and then click OK.

4. To delete multiple custom fields, complete the following steps.

     a. Navigate to System Definition > Dictionary.

     b. Locate the custom fields to delete.

         For example, search for column name that starts with u_.

     c. Check the boxes to the fields to delete and select Delete from the action list below the list.

         A confirmation dialog opens and reminds you that this may result in deletion of related records. If there               are dependencies for the selected fields, they are listed.

     d. To proceed, click Delete.

 

I am attaching the snapshot.

Mark Correct if this solves your issue. Hit Like/Helpful based on the impact.

 

 

Warm Regards,  

Priyanka

find_real_file.png

www.dxsherpa.com