topic Buffer (incremental) load: cannot find .qvd file in QlikView

Buffer (incremental) load: cannot find .qvd file

Fri, 16 Jul 2010 15:58:48 GMT

I'm trying to find out how 'BUFFER (incremental)' load works. I'm using the statement below to load data from a text file:

HourOverview:
BUFFER (Incremental)
LOAD
@1 as Time,
@2 as Category,
@3 as Activity
FROM
uur.log
(txt, codepage is 1252, no labels, delimiter is '\t', msq) ;

The data is loaded fine, but I would expect that a .QVD file was created in the default location (in my case C:\Documents and Settings\ddoord\Application Data\QlikTech\QlikView). However, there are no .QVD files in that folder (or any folder below). Are there some limitations on that I'm not aware of?

Buffer (incremental) load: cannot find .qvd file

rwunderlich — Sat, 17 Jul 2010 05:25:25 GMT

Your sample works fine for me on QV9 SR4. I get a QVD created in the buffer loacation.

-Rob

Buffer (incremental) load: cannot find .qvd file

wizardo — Sat, 17 Jul 2010 09:06:47 GMT

hmmm have you checked the settings:

this is from the inside qlikvie help:

QVD buffers will normally be removed when no longer referenced anywhere throughout a complete script execution in the document that created it or when the document that created it no longer exists. This housekeeping can be turned off by checking the options Keep Unreferenced QVD Buffers in Document Properties: General (first requirement) and Keep Orphaned QVD Buffers in User Preferences: General (second requirement) property pages respectively, though the procedure cannot be generally recommended.

Buffer (incremental) load: cannot find .qvd file

Sun, 18 Jul 2010 14:24:59 GMT

Hi Rob,

Thank you for checking!

As your help indicated that the script was correct, I've finally figured out the problem: I've searched in the wrong location. It shouldn't have been C:\Documents and Settings\ddoord\Application Data\QlikTech\QlikView but
C:\Documents and Settings\ddoord\Local Settings\Application Data\QlikTech\QlikView\Buffers. As it is a hidden directory, a windows search delivered no results with the standard search settings on!

Kind regards,

Daniel