topic Re: Qlik Oracle ODBC driver timeout after 30sec in App Development

Qlik Oracle ODBC driver timeout after 30sec

Anonymous — Thu, 22 Sep 2016 17:46:52 GMT

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.

Re: Qlik Oracle ODBC driver timeout after 30sec

Gysbert_Wassenaar — Fri, 23 Sep 2016 07:43:34 GMT

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

Re: Qlik Oracle ODBC driver timeout after 30sec

Anonymous — Fri, 23 Sep 2016 08:27:59 GMT

Hi Gysbert,

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

ODBC Connector

Re: Qlik Oracle ODBC driver timeout after 30sec

marcohadiyanto — Fri, 23 Sep 2016 11:43:09 GMT

Add querytimeout from your connection.

Regards

Re: Qlik Oracle ODBC driver timeout after 30sec

Anonymous — Fri, 23 Sep 2016 12:13:24 GMT

Hi Marco,

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

Regards,

Birkir

Re: Qlik Oracle ODBC driver timeout after 30sec

guruprem — Fri, 28 Apr 2017 11:33:28 GMT

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

Re: Qlik Oracle ODBC driver timeout after 30sec

Anonymous — Fri, 28 Apr 2017 13:40:18 GMT

Agreed