topic Why will Qlikview not Extract Entire data from a source in QlikView

Why will Qlikview not Extract Entire data from a source

Tue, 22 Dec 2015 16:18:38 GMT

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.

Re: Why will Qlikview not Extract Entire data from a source

Tue, 22 Dec 2015 17:20:30 GMT

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)

Re: Why will Qlikview not Extract Entire data from a source

eduardo_sommer — Tue, 22 Dec 2015 17:37:02 GMT

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