

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- « Previous Replies
-
- 1
- 2
- Next Replies »


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your reply.Yes, my statement is ending with Semicolon.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the reply, Will try this approach. But this query runs and gives output when run in Toad.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- « Previous Replies
-
- 1
- 2
- Next Replies »