topic Re: Not able to extract data from Oracle database in App Development https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82081#M5464 <HTML><HEAD></HEAD><BODY><P>Perhaps your query returns no data - but I cannot really say as you have provided no information for diagnosis. I suggest that you provide a lot more information. Have you tested the query outside QS (eg in Toad or command line SQL)?</P></BODY></HTML> Tue, 24 Apr 2018 05:07:52 GMT jonathandienst 2018-04-24T05:07:52Z Not able to extract data from Oracle database https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82080#M5463 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying connect with Oracle Database, but not able to extract data, but I do not have error.</P><P></P><P>What Can I do?</P><P></P><P></P><P>Please help me.</P></BODY></HTML> Tue, 24 Apr 2018 04:55:48 GMT https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82080#M5463 olguita2014 2018-04-24T04:55:48Z Re: Not able to extract data from Oracle database https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82081#M5464 <HTML><HEAD></HEAD><BODY><P>Perhaps your query returns no data - but I cannot really say as you have provided no information for diagnosis. I suggest that you provide a lot more information. Have you tested the query outside QS (eg in Toad or command line SQL)?</P></BODY></HTML> Tue, 24 Apr 2018 05:07:52 GMT https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82081#M5464 jonathandienst 2018-04-24T05:07:52Z Re: Not able to extract data from Oracle database https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82082#M5465 <HTML><HEAD></HEAD><BODY><P>I am working with Oracle DataBase.</P><P></P><P>When I am trying connect to Qlik, I have this print:</P><P></P><P><IMG alt="WhatsApp Image 2018-04-23 at 16.30.17.jpeg" class="jive-image image-1" src="/legacyfs/online/200674_WhatsApp Image 2018-04-23 at 16.30.17.jpeg" style="height: 349px; width: 620px;" /></P></BODY></HTML> Tue, 24 Apr 2018 19:33:18 GMT https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82082#M5465 olguita2014 2018-04-24T19:33:18Z Re: Not able to extract data from Oracle database https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82083#M5466 <HTML><HEAD></HEAD><BODY><P>Your query could be timing out. It is common with Oracle DB. When the DB times you out, it returns no records without displaying any error message.</P><P>Try to set Querytimout to -1</P></BODY></HTML> Tue, 24 Apr 2018 20:37:03 GMT https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82083#M5466 jerifortune 2018-04-24T20:37:03Z Re: Not able to extract data from Oracle database https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82084#M5467 <HTML><HEAD></HEAD><BODY><P>Where can I set the Querytimout to -1</P></BODY></HTML> Tue, 24 Apr 2018 21:36:54 GMT https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82084#M5467 olguita2014 2018-04-24T21:36:54Z Re: Not able to extract data from Oracle database https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82085#M5468 <HTML><HEAD></HEAD><BODY><UL><LI>Create data Connection using Qlik ODBC Connector Package</LI><LI>Supply the connection parameters</LI><LI>Under <STRONG>Advanced</STRONG></LI><LI>Enter '<STRONG>QueryTimeout'</STRONG> as Name and <STRONG>-1</STRONG> as Value</LI></UL><P></P><P></P><P>Hope this helps</P></BODY></HTML> Wed, 25 Apr 2018 12:52:38 GMT https://community.qlik.com/t5/App-Development/Not-able-to-extract-data-from-Oracle-database/m-p/82085#M5468 jerifortune 2018-04-25T12:52:38Z