QVD File initial generation failed (size, rows?)

Wed, 15 Apr 2015 06:07:52 GMT

Hello,

I have the situation that i want to change my relativly slow load to QVD File load and found some ways to make this incemental situation.

Therefore i want to generate first an initial load, but this fails (the script never ends) and i am not sure is this happening because of QVD size limitation or row limitation.

Script:

$(tableName):

SQL SELECT * FROM $(tableName)

WHERE Zeitpunkt > '01.01.2014 00:00:00';

STORE $(tableName) INTO $(QvdRawDataFolder)\$(tableName)_R.qvd (qvd);

// Remove my in-memory database;

DROP TABLE $(tableName);

The second table i want to generate has 195,000,000 rows and calculated the QVD will have over 4GB.

If i change the Where clause to 1.4.2014 everything runs well, the size is 3,9 GB and 175,000,000 rows will be read.

Does somebody has an idea what could be the problem or what can i change?

Thanks, Armin

topic QVD File initial generation failed (size, rows?) in QlikView

QVD File initial generation failed (size, rows?)