What is table "sh\$sys_storage_table_alias" and why /how is it part of my scoped application?

[raking08]

I am getting validation errors with a new scoped application   and want to delete the table, but want to know where it came from first. It has no columns, no data. I am getting similar errors with table "Sh$sys Storage Alias"

What is the result if I simply delete these?

thanks

r

[Pradeep Sharma]

Hello Raking,

Those are the shadow tables and it should not be created in application scope. I think there is already PRB related to this issue. As a workaround, move those tables to global scope via background scripts.

[raking08]

oddly enough if I look at the table from the dictionary, I see records and columns, but when I look at the table from the validation error citation, there are no records or columns in the table config...so this is snarled up to be sure.

I don't seem to be able to move this table to global. do you have a background script that will effect that move?

thx

[Pradeep Sharma]

Can you please share the script which is not working for you?

[Geni1]

var gr = new GlideRecord('sys_db_object');

gr.addEncodedQuery('sys_scope=sysIDOfYourApplicationScope^name=sh$sys_storage_table_alias');

gr.query();

if(gr.next()){

gr.sys_scope = 'global';

gr.update();

}

The script above should fix this issue.