Buffer load Issue

[#1]

I am trying to make an buffer incremental load from a csv file. But every time I reload, the last entry from the file is missing. If I load normally, everything works fine. please help me out.

[marcus_sommer]

I think you should use the buffer-feature only if you are sure that you have a significant advantage from them. Your missing entry will be probably caused by a not complete fitting load-condition which you should check again.

- Marcus

[#3]

check this: Buffer(Incremental) Load Issue

[#4]

Thnaks for the reply

...Could you please share an example for the same..

[Gabriel]

Hi,

Are you using Stale as part of this option for your BUFFER?

You need to look at this, especially if you are reloading manually.

You can specify as you want it

buffer (stale after 7 days) select * from MyTable;

or

buffer (stale after 1 hour) select * from MyTable;

[#6]

I'm not using stale....I'm just using the below script

buffer (Incremental)LOAD

U_name,
U_pwd
FROM
[Source_path\Buffer.txt]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

\\Buffer.text data

U_name,U_pwd

Jhnk,124

greg,123

Ureg,224

Preg,545

using the above script I'm able to display only first three record...if I add a fifth record to the above text file...only four record are displayed.... the last value is missing every time I load.

[Gabriel]

Hi,

The incremental option in Buffer only check the QVD file size which is stored in XML header in the QVD file.

Use FileSize () function before and after adding new records.

Add few carriage returns and see if that make difference