Qlik Oracle ODBC driver timeout after 30sec

[Anonymous]

Hi,

I have an Oracle query that takes 39sec to return the dataset and I am using Qlik Oracle ODBC drivers to connect to the database. It seems that it only run for 30sec and then returns a timeout error. How can I make it try longer, or basically not to timeout?

This is the error I get , any ideas on how to solve this?

The following error occurred:

QVX_UNEXPECTED_END_OF_DATA: ERROR [HYT00] [Qlik][ODBC Oracle Wire Protocol driver]Timeout expired. ERROR [HYT00] [Qlik][ODBC Oracle Wire Protocol driver]Timeout expired.

[Gysbert_Wassenaar]

Disable the Enable Query Timeout option of the ODBC driver: Using the Oracle ODBC Driver

[Anonymous]

Hi Gysbert,

I am using the Qlik ODBC connector package and cant find any settings like this.

ODBC Connector

[marcohadiyanto · Accepted solution]

Hi

Add querytimeout from your connection.

Regards

[Anonymous]

Hi Marco,

Thanks for the answer it works great and solved my problems.

Regards,

Birkir

[guruprem]

Thank you guys for Question and answer.  It saved my day. Community Long Live

[Anonymous]

Agreed