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

rajendravunnam · ‎04-14-2017

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.

veena_kvkk88 · ‎04-14-2017

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.

View solution in original post

Chuck Tomasi · ‎04-14-2017

I got a little lost in all the detail. Sorry, it's my brain working on too many things this morning.

What is the state of dev right now?

Do you have an entry in the dictionary for u_platform? If so, what type is it?

Is it appearing on the form/list?

Thanks.

rajendravunnam · ‎04-14-2017

The field is not showing up in the table in Dev. I can't find it in the dictionary but it is showing up in both List and form. when i right click on the field('u_platform') and configure dictionary, it says 'Record not found'.

Chuck Tomasi · ‎04-14-2017

If you input information in to the field on the form and save it, does it save?

Have you looked in the dictionary for other fields called u_platform?

rajendravunnam · ‎04-14-2017

yes, but none of them are on the table I am working on.