Hi Everyone, Query is not giving output due to Gateway Timeout for count or any other type of query(like- join), But it is working fine if I do just *SELECT * FROM <datasource_name>*. PLZ Look SS: And in this Datasource only have 740 rows. Can anyone explain what could be the reason that query is not returning output?

I would try Explain query and check the native query. is the count * working for other datasource? Is their anything notable in the broker log.

+1 to Bibek's suggestion. Also, try turning off the "limit inline results" switch on your

select *

query to see if it also fails.

@Bibek Sahoo Count * is not working for other datasource and I have not checked broker logs yet. I will post here when I check logs. @John Kowtko I have tried

select *

query after turning off limit inline results & also Use cache option And it is also getting fail