Import set transform failed due to error: com.glide.script.fencing.access.ScopeAccessNotGrantedExcep
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-18-2025 02:48 AM
Hi expert,
When we ran transform map in SuccessFactors spoke we got many errors: Unable to resolve target record, coalesce values not present: [Script].
This issue should be related to the script of field map for sys_id. Below is the script:
Below is the error log:
JavaScript evaluation error on:
answer = (function transformEntry(source) {
var gr = new GlideRecord('sn_hr_core_profile');
var cond = gr.addQuery('user.employee_number', source.user_id).addOrCondition('employee_number', source.user_id);
if (source.user_name != '')
cond.addOrCondition('user.user_name', source.user_name);
gs.info("tst6106:user_id:" + source.user_id);
gr.query();
gs.info("tst6106:user_name:" + source.user_name);
if (gr.next()) {
return gr.getUniqueValue(); // return the value to be put into the target field
} else {
return "-1";
}
})(source);
Root cause of JavaScriptException:
com.glide.script.fencing.access.ScopeAccessNotGrantedException
:
com.glide.script.fencing.access.ScopeAccessNotGrantedException
: read access to sn_hr_core_profile not granted:
com.glide.script.fencing.ScopedGlideRecord.checkOperationPermitted(ScopedGlideRecord.java:290)
com.glide.script.fencing.ScopedGlideRecord.jsFunction_query(ScopedGlideRecord.java:219)
jdk.internal.reflect.GeneratedMethodAccessor70.invoke(Unknown
Source)
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.base/java.lang.reflect.Method.invoke(Method.java:569)
org.mozilla.javascript.MemberBox.invoke(MemberBox.java:151)
org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:717)
org.mozilla.javascript.FunctionObject.call(FunctionObject.java:654)
org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2973)
org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1720)
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:1030)
org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:161)
com.glide.caller.gen.sys_transform_entry_db2fca44ebf06a14f878fa2b8ad0cd7b_source_script.call(Unknown
Source)
com.glide.script.ScriptCaller.call(ScriptCaller.java:22)
org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:160)
org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:3061)
org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2981)
org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1720)
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:1030)
org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:161)
com.glide.caller.gen.sys_transform_entry_db2fca44ebf06a14f878fa2b8ad0cd7b_source_script.call(Unknown
Source)
com.glide.script.ScriptCaller.call(ScriptCaller.java:22)
org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:160)
org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:731)
org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:4027)
org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:173)
com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:422)
com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:231)
com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:147)
com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:362)
com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:251)
com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:230)
com.glide.db.impex.transformer.FieldMapScript.runScript(FieldMapScript.java:58)
com.glide.db.impex.transformer.TransformEntry.getSourceScriptValue(TransformEntry.java:105)
com.glide.db.impex.transformer.TransformEntry.getSourceValue(TransformEntry.java:119)
com.glide.db.impex.transformer.MapTargetResolver.getSourceValue(MapTargetResolver.java:402)
com.glide.db.impex.transformer.MapTargetResolver.getTarget0(MapTargetResolver.java:142)
com.glide.db.impex.transformer.MapTargetResolver.getTargetAndAcquireLockOnNewRecord(MapTargetResolver.java:94)
com.glide.db.impex.transformer.Transformer.transformBatch(Transformer.java:181)
com.glide.db.impex.transformer.Transformer.transform(Transformer.java:104)
com.glide.system_import_set.ImportSetTransformerImpl.transformEach(ImportSetTransformerImpl.java:347)
com.glide.system_import_set.ImportSetTransformerImpl.transformAllMaps(ImportSetTransformerImpl.java:125)
com.glide.system_import_set.ImportSetTransformerWorker.startWork(ImportSetTransformerWorker.java:40)
com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:131)
com.glide.worker.ProgressWorker.startAndWait(ProgressWorker.java:52)
com.glide.worker.BackgroundProgressJob.execute(BackgroundProgressJob.java:59)
com.glide.schedule.JobExecutor.lambda$executeJob$1(JobExecutor.java:194)
com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:197)
com.glide.schedule.JobExecutor.execute(JobExecutor.java:177)
com.glide.schedule.JobExecutor.execute(JobExecutor.java:167)
com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:577)
com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$2(SchedulerWorkerThread.java:396)
com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:396)
com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:172)
On QA/PRD we have the same setting but cannot see this issue.
Please help to advise how to fix it.
Thanks in advance,
Yuanquan
