topic Set ErrorMode and "General Script Error in statement handling" in App Development

Set ErrorMode and "General Script Error in statement handling"

PierfrancescoGirolami — Sun, 30 Jul 2023 08:51:43 GMT

Hello,

sometime, not often, I get the "General Script Error in statement handling" when we make a URL call.

We are trying to manage this error including the "set ErrorMode=0" to make script continue also when we catch this error. But It seems this is not working properly as you can see from the following part of the script. We've set ErrorMode=0 but the script exited with error.

 20230729T163516.365+0200 0193 set ErrorMode=0
20230729T163516.365+0200 0194 TaskExecutionStatus:
20230729T163516.365+0200 0195 SQL SELECT
20230729T163516.365+0200 0196 "id" ,
20230729T163516.365+0200 0197 "status" 
20230729T163516.365+0200 0198 FROM JSON (wrap off) "data" PK "__KEY_data"
20230729T163516.365+0200 0199 WITH CONNECTION( URL "https://xxx.yyy.com:4993/api/v1/tasks/[some_other_params[)
20230729T163516.527+0200 General Script Error in statement handling
20230729T163516.527+0200 Execution Failed
20230729T163516.551+0200 Execution finished.

Do you have any idea why the script exited even if the set ErrorMode=0 ?

Thank you!

Re: Set ErrorMode and "General Script Error in statement handling"

marcus_sommer — Tue, 01 Aug 2023 13:09:49 GMT

I don't know why it happens but I could imagine that this may occur if the error didn't comes from the script-part - see the help-text:

ErrorMode

This error variable determines what action is to be taken by Qlik Sense when an error is encountered during script execution.

This could mean that if the error comes from the outside - for example any security measure or temporary failure has prevented that Qlik could execute the script - no script error would occur which would be fetched from the error mode and therefore the load breaks.

Another thought goes to the returned ScriptError - if this value is invalid/undefined the error mode itself may break and with it the entire script.

If none from the R&D would shed some insights you will probably need some workarounds - maybe by outsourcing this part into a separate task and if it failed only this task died but not the following chain.

Re: Set ErrorMode and "General Script Error in statement handling"

Huberto_Computop — Wed, 19 Feb 2025 16:29:34 GMT

Hi @PierfrancescoGirolami,

I am facing the same problem. Did you find a solution for your use case?

From time to time, I get the "General Script Error in statement handling" message from the Qlik Sense app that triggers the QNP REST API methods and the script does not stop as well.

So far, I haven't figured out a robust and resilient solution via Qlik script. Even though it works for other use cases when I force an error.

Thank you for your attention.

Regards,

Huberto