Sam Activity Job is failing with error: Failed to iterate on data stream: com.glide.transform.transformer.exceptions.InvalidPathException: Could not find path in stream: $.results - Support and Troubleshooting

Sam Activity Job is failing with error: Failed to iterate on data stream: com.glide.transform.transformer.exceptions.InvalidPathException: Could not find path in stream: $.results Issue Sam Activity Job is failing with error: Failed to iterate on data stream: com.glide.transform.transformer.exceptions.InvalidPathException: Could not find path in stream: $.results

Upon checking on this further, we will see the following errors in the system logs.

Flow Designer: Operation(Cloud Update User Activity.DS_action_wrapper-8101b8f8531120105a50ddeeff7b1263.8101b8f8531120105a50ddeeff7b1263.Datastream$1.item$41800) failed with error: com.snc.process_flow.exception.OpException: Call block 'Confluence Cloud Update User Activity.DS_action_wrapper-8101b8f8531120105a50ddeeff7b1263.8101b8f8531120105a50ddeeff7b1263.Datastream$1.item$41800' failed. Detail: Failed to iterate on data stream: com.glide.transform.transformer.exceptions.InvalidPathException: Could not find path in stream: $.results at com.snc.process_flow.engine.CallBlockOperation.run(CallBlockOperation.java:81) at com.snc.process_flow.engine.Operation.execute(Operation.java:207) at com.snc.process_flow.engine.restricted_caller_access.ExecuteWithCallerAccessTracking.executeWithMetaStack(ExecuteWithCallerAccessTracking.java:21) at com.snc.process_flow.engine.ProcessEngine.executeOps(ProcessEngine.java:618) at com.snc.process_flow.engine.ProcessEngine.runInternal(ProcessEngine.java:515) at com.snc.process_flow.engine.ProcessEngine.run(ProcessEngine.java:502) at com.snc.process_flow.engine.ProcessAutomation.run(ProcessAutomation.java:101) at com.snc.process_flow.engine.GlideProcessAutomation.runSync(GlideProcessAutomation.java:184) at com.snc.process_flow.engine.GlideProcessAutomation.runWithDomain(GlideProcessAutomation.java:343) at com.snc.process_flow.engine.GlideProcessAutomation.lambda$runAsUserSync$1(GlideProcessAutomation.java:310) at com.snc.process_flow.engine.PFSessionClone.run(PFSessionClone.java:71) at com.snc.process_flow.engine.GlidePFSession.runPlanAsUserSession(GlidePFSession.java:42) at com.snc.process_flow.engine.GlideProcessAutomation.runAsUserSync(GlideProcessAutomation.java:308) at com.snc.process_flow.engine.GlideProcessAutomation.messageFlow(GlideProcessAutomation.java:394) at com.snc.process_flow.engine.GlideProcessAutomation._start(GlideProcessAutomation.java:606) at com.snc.process_flow.engine.GlideProcessAutomation$StartBuilder.start(GlideProcessAutomation.java:1526) at com.glide.plan.runners.FlowObjectExecutor.startFlowObjectSynchronously(FlowObjectExecutor.java:248) at com.glide.plan.runners.FlowObjectExecutor.executeToCompletion(FlowObjectExecutor.java:118) at com.glide.plan.runners.FlowObjectExecutor.executeInternalWithResponse(FlowObjectExecutor.java:108) at com.glide.plan.runners.FlowObjectExecutor.lambda$executeWithResponse$0(FlowObjectExecutor.java:47) at com.glide.sys.Transaction.executeWithTimeout(Transaction.java:3250) at com.glide.plan.runners.FlowObjectExecutor.executeWithResponse(FlowObjectExecutor.java:47) at com.glide.plan.runners.FlowObjectAPI.executeWithResponse(FlowObjectAPI.java:80) at com.glide.plan.runners.scriptable.ScriptableFlowRunner.jsFunction_run(ScriptableFlowRunner.java:318) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138) at org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:677) at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:614) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2649) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830) at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160) at com.glide.caller.gen.sys_script_include_9f8b3023532011107f77ddeeff7b124f_script.call(Unknown Source) at com.glide.script.ScriptCaller.call(ScriptCaller.java:22) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2734) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2657) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830) at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160) at com.glide.caller.gen.sys_script_include_9f8b3023532011107f77ddeeff7b124f_script.call(Unknown Source) at com.glide.script.ScriptCaller.call(ScriptCaller.java:22) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2734) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2657) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830) at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160) at com.glide.caller.gen.sys_script_include_63dd30e187231300ec46ed4d87cb0b92_script.call(Unknown Source) at com.glide.script.ScriptCaller.call(ScriptCaller.java:22) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2734) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2657) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830) at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160) at com.glide.caller.gen.sys_script_include_63dd30e187231300ec46ed4d87cb0b92_script.call(Unknown Source) at com.glide.script.ScriptCaller.call(ScriptCaller.java:22) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2734) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2657) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830) at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160) at com.glide.caller.gen.sys_script_include_054adaa873c3330012a9e5e7caf6a79a_script.call(Unknown Source) at com.glide.script.ScriptCaller.call(ScriptCaller.java:22) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2734) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2657) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830) at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160) at com.glide.caller.gen.sys_script_include_54573868538313009961ddeeff7b1296_script.call(Unknown Source) at com.glide.script.ScriptCaller.call(ScriptCaller.java:22) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2734) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2657) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830) at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160) at com.glide.caller.gen.sys_script_include_63dd30e187231300ec46ed4d87cb0b92_script.call(Unknown Source) at com.glide.script.ScriptCaller.call(ScriptCaller.java:22) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159) at org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2734) at org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2657) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830) at org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160) at com.glide.caller.gen._refname_.call(Unknown Source) at com.glide.script.ScriptCaller.call(ScriptCaller.java:22) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159) at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:597) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3573) at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:172) at com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:408) at com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:218) at com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:137) at com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:128) at com.glide.script.Evaluator.evaluateString(Evaluator.java:104) at com.snc.automation.ScriptJob.executeInSingleDomain(ScriptJob.java:77) at com.snc.automation.ScriptJob.execute(ScriptJob.java:47) at com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:169) at com.snc.db.data_replicate.replicator.DataReplicationAdvisors.runInOriginatorContext(DataReplicationAdvisors.java:73) at com.glide.schedule.JobExecutor.lambda$inDataReplicationContext$2(JobExecutor.java:199) at com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:172) at com.glide.schedule.JobExecutor.execute(JobExecutor.java:155) at com.glide.schedule.JobExecutor.execute(JobExecutor.java:149) at com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:449) at com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$1(SchedulerWorkerThread.java:318) at com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35) at com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:318) at com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:118) : no thrown error

Cause The credentials configured for the integration were failing to authenticate, Hence OAuth token generated is no longer valid.

Resolution Please validate the credentials configured for SAM integration. Change the password and update it in the instance. Generate a new OAuth token.