Deleted filed still shows up in the List layout and form layout but not in table ?

[rajendravunnam]

Hello,

I have a   string field 'platform'(u_platform) , i tried to convert it into Reference. I have deleted the field and created a new one with the same name 'Platform' (u_platform) but as a reference field. All this is captured in a single update set. When this update set is moved to Dev from Beta environment, there was an error   while committing the update set:

Error

sys_dictionary_change_request_u_platform

Type change not allowed. Invalid type conversion for field 'Platform' on table 'Change Request'. Cannot convert from 'String' to 'Reference'. There exists data records (252) that are not a Sys ID.

so, in   my Beta instance i have deleted the Reference field and added it back as a String and moved it to dev (the update set which has String configuration captured). Now dev looked good. But again i have deleted this field in beta and moved the update set to Dev. Unfortunately the field was still showing up as 'u_platform' on the form and list layout but i can't see it in the table.   When i tried to configure dictionary on this field, it is giving me 'no record found'.There were already some records for which this field is populated in Dev.   I am not sure how to fix this and what problems would arise when i move this change to TEST and beyond. Any help is appreciated.

[johnolivermendo]

Hey Rajendra,

Have you tried checking your form through Form Design or Form Layout to see if the field still appears there? It seems that the dictionary definition doesn't exist anymore but somehow there's still an orphan of its existence in the form definitions. I think all you need to do is remove the field from your form. Let me know if that solves your problem.

[rajendravunnam]

I tried removing it but it is still available to add to the form layout/list layout

[veena_kvkk88 · Accepted solution]

Hi Rajendra!

I've faced this way too many times! If you check the 'sys_storage_alias' table, and search for the field name in the element column, I'm pretty sure you'll find it which is the reason you see it in the layouts, but not in the table.

When we delete a field, the storage alias is not being deleted sometimes. Once that's deleted too, it shouldn't show up anymore. However, even admins cannot delete stuff from that table and its not advices to change the acls. You need to create a HI ticket and ask HI team to delete it for you.

[rajendravunnam]

Hi Veena,

yeah, i can see the field in 'sys_storage_alias' in table. I will check on creating a ticket. Thank you very much!

-Raj

[Daniel Gens]

Hi Veena,

Thanks so much, you have helped me resolve this pesky issue!

-Dan