Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a large (over 10 GB) qvw document which fails to reload when run as a task from the management console.
The error file is attached. I am guessing the task has some timeout limit associated withopening the document.
Does anyone know wherethis is or any other possible cause?
Cheers
Mark
Hi Mark, are you load data from a network drive or a fileshare? then use the relativ search way like \\ instead of 😧 in the application.
Inside the load script I am only using relative path names, if that's what you meean.
It seems to fail because you have Section Access in the application and haven't added user and pwd in your distribution task.
"The document might require username and password"
The document has no section access.
My hunch is there is a timeout limit for opening a document which is being reached.
If I open the document in the thick client it takes about 2 minutes to open.
To prove the size of the file is casuing the problem (not the script) I did a data reduciton and tried again and it worked.
I've logged this with Qliktech but thanks anyway.
Add the user that runs the qlikview services as admin in your section access.
The error message is a red herring.
Like I said, I've ran exactly the same document with less data sucesfully.
My workaround is to load from a copy of the same dashboard with no data attached.
Detail below.
Starting point
HCM_AD_OPS_MAIN_ALL_DATA.qvw (10 GB)
HCM_AD_OPS_MAIN_ALL_DATA.qvw.NO_DATA (Same as above but with no saved data)
Task 1
Step_1.qvw
executes a bat file:
Copy "HCM_AD_OPS_MAIN_ALL_DATA.qvw.NO_DATA" "HCM_AD_OPS_MAIN_ALL_DATA.qvw.NO_DATA_TEMP"
Task 2
Step_2.qvw
executes a bat file:
MOVE /Y "HCM_AD_OPS_MAIN_ALL_DATA.qvw.NO_DATA" "TEMP_DO_NO_USE_HCM_AD_OPS_MAIN_ALL_DATA.qvw"
Task 3
Reloads TEMP_DO_NO_USE_HCM_AD_OPS_MAIN_ALL_DATA.qvw (Opens fine as no data attached)
Task 4
Step_3.qvw
Exclutes a bat file:
Move /Y "TEMP_DO_NO_USE_HCM_AD_OPS_MAIN_ALL_DATA.qvw" "HCM_AD_OPS_MAIN_ALL_DATA.qvw"
Rename "HCM_AD_OPS_MAIN_ALL_DATA.qvw.NO_DATA_TEMP" "HCM_AD_OPS_MAIN_ALL_DATA.qvw.NO_DATA"
You should report this support as it appears to be a bug. What version are you using? Reloads work differently and are more efficient in V11. As it does not load the data when the qvw is loaded into memory prior to the reload.
I've rasied a case and I'm using V11