Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RedSky001
Partner - Creator III
Partner - Creator III

Large file failing to reload

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

12 Replies
stabben23
Partner - Master
Partner - Master

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.

RedSky001
Partner - Creator III
Partner - Creator III
Author

Inside the load script I am only using relative path names, if that's what you meean.

jerrysvensson
Partner - Specialist II
Partner - Specialist II

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"

RedSky001
Partner - Creator III
Partner - Creator III
Author

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.

stabben23
Partner - Master
Partner - Master

Add the user that runs the qlikview services as admin in your section access.

RedSky001
Partner - Creator III
Partner - Creator III
Author

The error message is a red herring.

Like I said, I've ran exactly the same document with less data sucesfully.

RedSky001
Partner - Creator III
Partner - Creator III
Author

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"

Anonymous
Not applicable

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.

RedSky001
Partner - Creator III
Partner - Creator III
Author

I've rasied a case and I'm using V11