question Re: Deleted filed still shows up in the List layout and form layout but not in table ? in ITSM forum

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

rajendravunnam — Fri, 14 Apr 2017 15:26:29 GMT

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.

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

Chuck Tomasi — Fri, 14 Apr 2017 15:30:33 GMT

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.

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

rajendravunnam — Fri, 14 Apr 2017 16:00:07 GMT

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'.

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

johnolivermendo — Fri, 14 Apr 2017 16:36:06 GMT

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.

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

Chuck Tomasi — Fri, 14 Apr 2017 16:38:26 GMT

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?

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

rajendravunnam — Fri, 14 Apr 2017 17:00:40 GMT

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

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

veena_kvkk88 — Fri, 14 Apr 2017 17:47:35 GMT

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.

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

rajendravunnam — Fri, 14 Apr 2017 19:01:29 GMT

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

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

rajendravunnam — Fri, 14 Apr 2017 19:07:58 GMT

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

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

DanielG50278433 — Mon, 06 Aug 2018 08:36:06 GMT

Hi Veena,

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

-Dan

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

DanielG50278433 — Mon, 06 Aug 2018 08:46:57 GMT

For future readers:

Following Veena's suggestion, I took at look at 'sys_storage_alias' table and found me "ghost field" in there. Moreover, I was able to delete a record in that table without contacting HI.

I ran the following background script to delete the record:

var sys_id = "e7e80a80dbb35f00a41efb0e0f96199b"; // substitute your sys id
var gr = new GlideRecord('sys_storage_alias');
gr.get(sys_id);
gs.info(' Table Name: ' + gr.table_name + ' Column Name: ' + gr.element_name);
gr.setWorkflow(false);
var flag = gr.deleteRecord();
gs.info(flag); // will return true if record is deleted successfully

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

DNC — Tue, 31 Aug 2021 04:52:22 GMT

Hi Daniel

I have used the same script and executed it in the background script.

The record is deleted from the 'sys_storage_alias' but, still, the field is available in the form.

Tried to hide via UI Policies, but no luck

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

DanielG50278433 — Tue, 31 Aug 2021 17:34:22 GMT

Hi Nagarjuna,

I've been using the following Fix Script to fully and cleanly delete table columns as it requires not only clearing sys_storage_alias, but also sys_dictionary and sys_documentation:

Name: Delete table column

Active: true

Unloadable: false

Run once: false

Flush cache: false

Before: false

Description: Deleting a column doesn't cleanly remove all references to it. Use this script to cleanly delete table columns.

Script:

// Replace with your table name
var table = 'incident';

// Replace with your column name
var column = 'u_metric';

// Running and checking success
gs.info("cleanDict successful? " + cleanDict(table, column));
gs.info("cleanAlias successful? " + cleanAlias(table, column));
gs.info("cleanDoc successful? " + cleanDoc(table, column));


function cleanDict(table, column) {
	var gr = new GlideRecord('sys_dictionary');
	gr.addQuery('name', table);
	gr.addQuery('element', column);
	gr.query();
	while (gr.next()){
		gr.setWorkflow(false);
		return gr.deleteRecord();
	}
}

function cleanAlias(table, column) {
	var gr = new GlideRecord('sys_storage_alias');
	gr.addQuery('table_name', table);
	gr.addQuery('element_name', 'CONTAINS', column);
	gr.query();
	while (gr.next()){
		gs.info(gr.getDisplayValue());
		gs.info(' Table Name: ' + gr.table_name + ' Column Name: ' + gr.element_name);
		gr.setWorkflow(false);
		return gr.deleteRecord();
	}
}

function cleanDoc(table, column) {
	var gr = new GlideRecord('sys_documentation');
	gr.addQuery('name', table);
	gr.addQuery('element', 'CONTAINS', column);
	gr.query();
	while (gr.next()){
		gs.info(gr.getDisplayValue());
		gs.info(' Table Name: ' + gr.name + ' Column Name: ' + gr.element + ' Column Label: ' + gr.label );
		gr.setWorkflow(false);
		return gr.deleteRecord();
	}
}

After it's all set up, you can Run Fix Script with the UI action on the Fix Script form. Note that if you've already delete your column from sys_storage_alias, the deletion will appear not successful because the record is already gone.

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

RiteshSwarnakar — Sun, 01 Jan 2023 15:58:59 GMT

Background Script to find out those which are not sys_id :

var ga = new GlideAggregate('table_name'); var c = 0; ga.groupBy('field_name'); ga.query(); while (ga.next()) { if (ga.field_name.toString().length!=32){ gs.print(ga.field_name); c+=1; }} gs.print(c);