deleted field still exist

[soukayna]

hello,

I'm trying to create a field named 'canal1' in a table , but i got the error "Column {1} already exists in this table or a table extended from it" , when i look for this column in my table , it doesn't exist and my table doesn't extend from others .

is there any idea of how to redelete this field correctly ? 

I've already checked in sys_audit it doesn't exist and already delete it from  the Storage Column Aliases and got the same error , 

any ideas pls??

thanks 

Soukayna

[Omkar Mone]

Hi

Can you try and Run "gs.invalidateCache();" in Script background and check if same issue persists.

Regards

Omkar Mone

[soukayna]

hi Omkar , 

Thanks for ur answer , i already run it but still have the same problem .

Regards

soukayna

[Omkar Mone]

Hi 

Then i suppose it is the problem of meta data,you can contact servicenow HI support and get this resolved.

Regards

Omkar Mone

[harishdasari]

Hi,

try checking your deleted record in sys_audit_delete table.

You can see a button as Undelete. Now click on it to restore the deleted field.

After that now you can see that the field has been restored. Now right click on the field and click on the configure dictionary and click on the Delete Column button.

This will delete the field.

If your field is a reference field, then the values in this field for all the records needs to be cleared first before deleting the field.

Thank you.