Size of QVD

[Anonymous]

Hi

I am incrementally loading a QVD which is more than 100MB.

The script is getting failed now.

Will the size have an impact?

Can anyone help me on this please.

[sunny_talwar]

What is the exact error you are getting??

[Anonymous]

Its not showing any error.

The last line i get in log file is the LOAD statement.

[jonathandienst]

A QVD of 100MB is not particularly large, so the size of the QVD is not what is causing your problem. Check out the failure in the document log (if there is none, enable in Document Properties | General an reload). Post the last part of the log before the error.

[sunny_talwar · Accepted solution]

And you are checking the log file after the reload has been completed???

[Anonymous]

Below is the screenshot of last line of log file,

[qlikviewwizard]

Hi,

Please copy and paste the decoded log file text. Attached screen is not visibel.

Just try this. Please close all QV applications and restart the server and re-run the application. Hope it will work.

[Gabriel]

Hi,

The error is not down to QVD size. I will suggest you look at your script, the truth is in your script. Are you connecting to database for extraction?

Another question is, has you script worked at any time in the past?

More information to the community will help narrowing down to root cause of the failure.

Best Regards,

Gabriel

[jonathandienst]

It could be a broken join or a composite key caused by loading tables with many common fields into separate tables. It can take a long time to complete the load if you have a cartesian join (ie a join with no common field names) of million row plus tables, or to construct synthetic keys for field names common to two or more tables; and you can easily run out of memory.

[alibd225]

This error is not for QVD size. 100 MB is not a large size. practically i used more than 800 MB QVD file.

please share with us actual log file. so that everyone can understand ur problem.