Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rxp03570
Creator
Creator

0 Lines fetched Qlik Sense SQL Query

Hi All,

I'm trying to import data from Oracle (Toad), using a select statement - When I pass one or two account in where I get the output. When I try to pass around 10 or more it doesn't fetch any records. It just fetches 0 lines - Not sure what the issue is .

My Statement ends with where c.account_id IN (222,333,444,555,666,777,888,999,1111,2222).

Any idea why the query does not fetch any records?. - Please find attachment for log file.

15 Replies
rxp03570
Creator
Creator
Author

Thanks for your reply.Yes, my statement is ending with Semicolon.

jonathandienst
Partner
Partner

The problem is most likely buried deep inside the complex select statement. I would break the statement into its components and ensure that each of these is returning the expected record count. Then rebuild it step by step verifying the correct results at each step. Then you may find what is behaving incorrectly.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rxp03570
Creator
Creator
Author

Thanks for the reply, Will try this approach. But this query runs and gives output when run in Toad.

sunny_talwar

Does this also work (give some number of rows) when you just get rid of this?

AND cp.account_id IN (3212,3204,3191,3189,3138,3121,3102,3022,3100,3098,3095,3076,3072)

rxp03570
Creator
Creator
Author

Thanks for the reply Sunny, having two or less accounts it does fetch records. Anything more than two gives me 0 lines.

Not sure what the issue is.

sunny_talwar

What kind of connection are you making? OLEDB or ODBC? I have seen the connection type to have an impact on the query... may be try to change the connection type and see if that makes any difference