Load statement not loading all rows

[kwnkhn]

Hi,

I am trying to load data into a qvd or text file, but not all rows are getting loaded. The data source has about 700,000 rows, but only about 200,000 get loaded every time I execute the script, whether into a qvd or text file. There are no errors registered. Why is this happening?

I am using the basic load and store statement:

QVTable:
LOAD Column1,
            Column2;
SQL SELECT Column1, Column2 FROM SQLTablename;

STORE QVTable INTO Drive:\Path\QVTable.csv (txt);

[marcus_sommer]

I think the cause is either your database-driver which couldn't handle all records and just skipped them instead of running into an error or your database didn't return more records maybe because of locking those records or any set restrictions in the possible number of records or any timeouts or something similar.

- Marcus

[dapostolopoylos]

Have you tried to execute your query on the database client to see haow many rows are returned?
Otherwise  Marcus proposes seems right to my eyes

[kwnkhn]

Yes, on database client, it returns all rows.

[kwnkhn]

Checking on this...