Error Automatic Distibution Task but not Manual Task

jorditorras — Tue, 05 Nov 2024 16:30:47 GMT

Dear Gurus,

I have some problems with one automatic data loading process that is extractig data from SAP BW Infocubes. Everytime it's triggered automatically (after planning a daily load) I get the following error:

Error: The name 'minDIMID' already exists.

However if I trigger it manually the result is OK.

Any idea about why I can load data manually in the QMC but not automatically?

Thanks for your help.

Jordi

Re: Error Automatic Distibution Task but not Manual Task

diegozecchini — Wed, 13 Nov 2024 09:38:02 GMT

Hi!
Qlik variables can persist across reloads if they are not cleared explicitly in the script. If minDIMID is defined in your script, it might be causing a conflict in the automatic load because the variable could already exist from a previous session or task execution.

Try adding a line to drop or reset minDIMID at the start of your script to ensure it doesn’t persist unexpectedly:

SET minDIMID = Null();

Manual tasks often run with the full Qlik session environment loaded, whereas scheduled tasks might execute in a more constrained context, potentially leading to variables or fields not being initialized as expected.
Try running the script in debug mode with a simulated scheduled task environment to catch any potential discrepancies. Also, if minDIMID is a calculated field, ensure all dependencies for its calculation are loaded and defined before its assignment.

Qlik’s automated loads may handle errors differently than manual ones, especially if there’s an "on error" handling configuration that’s stopping or altering the script flow in automatic mode.

topic Re: Error Automatic Distibution Task but not Manual Task in Connectivity & Data Prep

Error Automatic Distibution Task but not Manual Task

Re: Error Automatic Distibution Task but not Manual Task