Action canceled by user - General Error??!

[samuel_lin]

Hello Qlikers,

I have been trying to run a loop in load script, during the process, it almost used up all the RAM (64GB) when the memory limit is hit, it gets stuck and slow down for a while and then this error occurs.

Has anyone seen this error? "Action canceled by user? How do I set my loop up to save more RAM? is there settings in Qlik that can help with this?

Thank you!!

Samuel

[ahaahaaha]

Hi Samuel,

Unfortunately, the material provided Is not enough for suggesting anything useful at once.

From my experience, a similar errors occurred when incorrectly linking tables. Try again to go through the script code and analyze what happens to the tables as they linking, whether multiple keys or circular references are generated.

Comment out all the script code and start adding one by one table in sequence, removing part of comment and analyzing the result in the "View data model" window after each part of comment is deleted. At a minimum, you will find point of code where the memory runs out when loading, and an error is output.

Regards,

Andrey

[john_oll]

I encountered the "Error: Action canceled by user" today in a Qlikview reload.
The reason for the error was: It aborted due to a full outer join generating close to 2 billion lines (where an interval match would have made more sense).
So maybe "not enough RAM due to bad code written by developer" would be the correct translation of

"Action canceled by user"

 😉