Not able to extract data from Oracle database

[olguita2014]

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.

[jonathandienst]

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

[olguita2014]

I am working with Oracle DataBase.

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

[jerifortune]

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]

Where can I set the Querytimout to -1

[jerifortune · Accepted solution]

• 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