Unable to update field labels after an update set rollback

[Priyanka Gupta]

Hi everyone,

I have a few custom fields on Task table that I accidentally deleted in an update set.

I backed out the update set in the hope that the fields would get restored.

The back out helped, fields have been restored, however, I am not able to update the field label. The field label is empty. When I double click on the field label, I see my field label name is correct. 

I think because the field label is empty, I am unable to see the field in the Form Design as well.

Analysis done-

• I checked sys_documentation table and the field labels are fine there.
• I checked the sys_dictionary table and the field labels are fine for Task there as well.
• I cleared the cache by going https://<my-instance>.servicenow.com/cache.do
• I opened a new incognito window to check if this was a local browser cache issue (highly unlikely)

Please help me figure out the issue here.

Thank you!

[Priyanka Gupta · Accepted solution]

I totally forgot to update this thread and close it.

I was given a few options by SN Support team.

1. SN Support team could have restored the backup for me.

2. Reason: The reason the labels do not show is because there aren't any physical columns within the database for these fields

To correct this you will need to delete the entries from https://<ur servicenow url here>/sys_dictionary_list.do?sysparm_query=elementIN<ur element name here>

I would then recommend clearing cache on the sys_dictionary, sys_storage_alias and sys_documentation tables in background scripts:

GlideTableManager.invalidateTable("sys_storage_alias"); 
GlideCacheManager.flushTable("sys_storage_alias"); 
GlideTableManager.invalidateTable("sys_dictionary");
GlideCacheManager.flushTable("sys_dictionary"); 
GlideTableManager.invalidateTable("sys_documentation"); 
GlideCacheManager.flushTable("sys_documentation"); 

You can then recreate the columns which will recreate the physical columns required for these elements within the database.

I went with #2 and it worked just fine. So, in case you accidentally delete columns from your table and you see blank labels when you try to restore them, I would advise you to try #2. This, however, would create new columns on the table and wouldn't restore your data.

Hope this helps anyone in distress!

Priyanka