Error Trying to Update Records in Custom Table in Scoped App with Background Scripts

[jmiskey]

I have a Scoped App that has a Custom Table with about 150 records in it.  This has been in Production for a while.  They want to add a suffix onto one of the fields for all records.  The field name is called "security_group", and they want to add "- Role" to the end of every entry of this field.

I created the following Background Script to do that:

var gr = new GlideRecord('x_table_name');
gr.addQuery('active','true');
gr.query();

while(gr.next()){
	gr.security_group = gr.security_group + '- Role';
	gr.update();
}

when I try to run it, I get the following error messages:

Security restricted: Write operation against 'x_table_name' from scope 'rhino.global' has been refused due to the table's cross-scope access policy

I did some research, and found the following articles:

https://www.servicenow.com/community/developer-forum/quot-write-operation-from-scope-rhino-global-ha...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727180

I have tried the suggestions in them, including:

1. Tried a "cache.do"

2. Tried running  "gs.invalidateCache();" in the background

3. Tried checking the "Can Create" flag on the table

None of that made any difference.  So I tried putting the code in a Scheduled Job, and tried running that.  That still did not update the records.

Does anyone have any other ideas on how I can make these data updates quickly and efficiently (without having to edit each one manually)?  I thought about exporting the records and re-importing them, but the issue is the field I am updating is the key unique field that I would be matching on!  And I know it is a bit tricky to figure out how to export the sys_id into an Excel export.

[Shruti]

Hi,

Navigate to System Definition-> Fix Scripts

Create a fix script in (custom table) scope application and execute the fix script

var gr = new GlideRecord('x_table_name');
gr.addQuery('active','true');
gr.query();

while(gr.next()){
	gr.security_group = gr.security_group + '- Role';
	gr.update();
}

[jmiskey]

Thanks.  I am out of the office for an all day meeting, but I will try a fix script tomorrow when I am back in the office.

[jmiskey]

Unfortunately, I encountered similar issues with the Fix Script attempt.  The error message was something like this: 

Script execution error: Script Identifier: unknown, Error Description: Access to GlideRecord.update from scope x_table_name not allowed, Script ES Level: 180
Evaluator.evaluateString() problem: com.glide.script.fencing.CrossScopeAccessNotAllowedException: Access to GlideRecord.update from scope x_scope_name not allowed: 	com.glide.script.fencing.ScopedScriptableObject.checkCrossScopePrivileges(ScopedScriptableObject.java:199)

(I changed the table and scope name in the error message for privacy).  Note that I did try running it from the scoped app.

Seeing as how the suggestion of creating the Excel template worked and did exactly what I need, I think I have an answer to my problem.  Thanks to all who replied.

[t_sadahisa]

Hello @jmiskey 

How about selecting the same application scope as the table when running in “Scripts - background”?

Thanks.

[jmiskey]

I should have mentioned - I already tried changing to the scope to run the code, and it made no difference - I still got those errors.