Why will Qlikview not Extract Entire data from a source

[#1]

Hi, Can anyone tell if there are any reason why qlikview will not extract the entire data in a table from a database;

I have a qvd generator that extracts data from oracle Sql developer but it does not extract the entire data,  I know this because when I query the database I see all the data but in my qlikview app I can not find this same data.

[#2]

watch out for the data having end of file markers in it. arrows and stuff like that. they can cause the load to stop.

I had this before when loading from a text file and had to use something like

(txt, codepage is 1252, embedded labels, delimiter is '\t', no quotes, no eof)

[eduardo_sommer]

Hi,

It happened to me also. I used the WITH (NOLOCK) option after every table in from clause of the SQL Statement. It worked for me. The cause was, probably, a record of the table being locked by the ERP.

I hope this will help you

Eduardo