0 Lines fetched Qlik Sense SQL Query

[rxp03570]

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.

[rxp03570]

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

[jonathandienst]

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.

[rxp03570]

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]

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