We are getting random and recurring failures in scheduled QS tasks that retrieve data using JSON. Usually when the task is retriggered it succeeds. When we have failures, there isn't any info in the logs to troubleshoot what is going on. The issues seems to happen more when memory usage is ~80-90%. It does look like the Failure is happening after the REST call is complete, for example, we use this to trigger NP tasks and the NP task will be triggered even when the QS task fails.
Generally, the script log end looks like this:
FROM JSON (wrap off) ...
General Script Error in statement handling
Execution Failed
Execution finished.
Has anyone else dealt with this or have any ideas what it could be/how to troubleshoot?
