Unable to update field labels after an update set rollback

Priyanka Gupta · ‎04-25-2018

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 · ‎01-23-2019

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

View solution in original post

matthewmaxwell · ‎04-25-2018

I think this is a bug on the SN side of things. I went through all of the steps you describe here. I even tried using a GlideRecord update in a background script. The update throws no errors. There are no errors logged as well. In fact, on the sys_dictionary for the field, if you view the XML, the column_label appears to have the correct value. I even tried removing the sys_documentation label and readding it with no success.

Short of making a new field and writing a script to populate it, I can't think of a workaround for this.

Priyanka Gupta · ‎04-25-2018

Thank you for checking on this for me!

I tried removing the field label and adding it again, didn't work for me as well.

I can see the field label in the XML is also correct.

Sadly, I don't want to create a new field since there are applications feeding off of old fields and I would have to manually go and update choice list for all of them. When I say all, I mean like 10 fields with 60-70 choices each. 😞

matthewmaxwell · ‎04-25-2018

I would consider opening a HI ticket for this issue.

Priyanka Gupta · ‎04-25-2018

I have opened a HI ticket. I will post the updates I get from them on this thread.

Thanks!