Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

birkirbjorns
New Contributor III

Qlik Oracle ODBC driver timeout after 30sec

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.

1 Solution

Accepted Solutions
chooco_co
Valued Contributor

Re: Qlik Oracle ODBC driver timeout after 30sec

Hi

Add querytimeout from your connection.

trouble2.png

Regards

6 Replies

Re: Qlik Oracle ODBC driver timeout after 30sec

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


talk is cheap, supply exceeds demand
birkirbjorns
New Contributor III

Re: Qlik Oracle ODBC driver timeout after 30sec

Hi Gysbert,

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

ODBC Connector

chooco_co
Valued Contributor

Re: Qlik Oracle ODBC driver timeout after 30sec

Hi

Add querytimeout from your connection.

trouble2.png

Regards

birkirbjorns
New Contributor III

Re: Qlik Oracle ODBC driver timeout after 30sec

Hi Marco,

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

Regards,

Birkir

guruprem
Contributor III

Re: Qlik Oracle ODBC driver timeout after 30sec

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

birkirbjorns
New Contributor III

Re: Qlik Oracle ODBC driver timeout after 30sec

Agreed

Community Browser