Solved: Not able to extract data from Oracle database - Qlik Community

olguita2014 · ‎2018-04-24

Hi,

I am trying connect with Oracle Database, but not able to extract data, but I do not have error.

What Can I do?

Please help me.

jerifortune · ‎2018-04-25

Create data Connection using Qlik ODBC Connector Package
Supply the connection parameters
Under Advanced
Enter 'QueryTimeout' as Name and -1 as Value

Hope this helps

View solution in original post

jonathandienst · ‎2018-04-24

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)?

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

olguita2014 · ‎2018-04-24

I am working with Oracle DataBase.

When I am trying connect to Qlik, I have this print:

jerifortune · ‎2018-04-24

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.

Try to set Querytimout to -1

olguita2014 · ‎2018-04-24

Where can I set the Querytimout to -1

jerifortune · ‎2018-04-25

Create data Connection using Qlik ODBC Connector Package
Supply the connection parameters
Under Advanced
Enter 'QueryTimeout' as Name and -1 as Value

Hope this helps