topic Re: Load data successful but 0 lines fetched in Connectivity & Data Prep

Load data successful but 0 lines fetched

Anonymous — Mon, 16 Apr 2018 15:45:29 GMT

Hello,

I have an Qlik sense desktop application where I try to run fairly complicated query against the postgres database which returns few millions of records to do my analysis on.

My problem is that most of the time when I do data load - progress states:

Started loading data

vl << QueryResult Lines fetched: 0 Creating search index Search index creation completed successfully

App saved

Finished successfully

0 forced error(s)

0 synthetic key(s)

But it shall fetch few millions record. When I press Load data button several times it works at the end (After pressing it for several hours).

Normally it take 20 minutes to fetch the data when it is successful. In case it is not successful it gives me result above in ~35 - 45s from when I press the button.

I'm using postgres ODBC connector. I tried to use custom timeout for the query but it did not help anything. Is there any way I could debug why the application is not fetching the data. Since there is no error from the application itself I don't know where to look at.
I noticed that more data I try to load the lower the probability that it succeeds is.

Best regards

Martin

Re: Load data successful but 0 lines fetched

calvin_wee — Fri, 31 Aug 2018 01:45:13 GMT

Very likely it is the WHERE condition. Check the data type such as Date or special characters.

TOAD/SQL Developer somehow is able to handle when type is different but content is ok.

e.g. WHERE SOME_DATE>SYSDATE

If SOME_DATE is character but follows date format, may not work in QlikSense but will work in SQL Developer or TOAD.

Hope this helps

Re: Load data successful but 0 lines fetched

nsetty — Fri, 31 Aug 2018 03:48:23 GMT

Try First keyword prefix to limit the load.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/First.htm

First 10 LOAD * from abc.csv;

First (1) SQL SELECT * from Orders;

Re: Load data successful but 0 lines fetched

BalaBhaskar_Qlik — Fri, 31 Aug 2018 09:32:08 GMT

It's better, post your postgres query used in Qlik sense.

Re: Load data successful but 0 lines fetched

BalaBhaskar_Qlik — Fri, 31 Aug 2018 09:32:34 GMT

Check this:

Getting 0 records while reading data from oracle database

Re: Load data successful but 0 lines fetched

BalaBhaskar_Qlik — Fri, 31 Aug 2018 09:33:35 GMT

Call views into qlik sense like this:

Extracting views from Oracle

Re: Load data successful but 0 lines fetched

heij1421 — Tue, 27 Aug 2024 09:55:09 GMT

I also had the same issue. The connection was established and a bearer token was retrieved. But when using this bearer token, 0 lines where fetched.

It turned out that the bearer token was incorrect. This was due to the fact that the POST connection retrieving the bearer token had an incorrect BODY. In my case I had written "api_key" instead of "apikey". It returned a wrong access token.

My connection which worked was:

FROM JSON (wrap off) "report"
WITH CONNECTION (
HTTPHEADER "Content-Type" "application/json",
HTTPHEADER "Authorization" "Bearer $(vAccessTokenValue)",
URL "$(vBaseURL)FlexReport/Get",
BODY "$(vRequestBodyfacturen)"
)
;

AND my 'vRequestBodyfacturen' variable was

LET vRequestBodyFacturen ='{ "ReportId": 200026 }';
LET vRequestBodyFacturen = replace(vRequestBodyfacturen,'"', chr(34)&chr(34));

which changes a double quote in a double double quote.

Hope this helps someone.