topic Re: ODBC connection time out- reconnect in QlikView

ODBC connection time out- reconnect

Tue, 26 Jul 2016 03:11:49 GMT

Qlikview application connects to DB via odbc connection. Sometimes it fails due to connection time out.

Is there a way to have a loop function in the script to try to connect and execute 'ODBC Connect' statement until a successful connection is established?

Thanks

I tried to execute the below code in my script to have looping functionality for ODBC connection:

//Script Begins

Let vConnect=1

do while vConnect=1

ODBC Connect To testDB;

If ScriptError=0 THEN

Let vConnect=2;

Endif;

loop;

//Script Ends

The above script works fine when I reload via Qlikview application instance- it tries to reload again and again until a successful connection is established.

However, when the same script/application is reloaded via QMC(Qlikview Publisher), it tries to connect and if it fails the first time, the reload task doesn't try to connect again - do while.. loop is not executed.The job ends with 'Failed' status.

Is there a way to reload the task again in QMC until a connection is established, with this script or any other setting?

Note: There is a setting in Publisher to set 'Number of re-runs'. However, I don't want to limit the number of re-runs to a fixed value. I want it to be executed as many time as it takes, until a connection is created. I am trying to explore if anyone has tried anyother method?

Message was edited by: prashanthi janakiraman

Re: ODBC connection time out- reconnect

marcus_sommer — Tue, 26 Jul 2016 07:26:00 GMT

As far as the connect-statement returned an error you could react on them within if-loops by using ErrorHandling in Qlikview.

- Marcus

Re: ODBC connection time out- reconnect

Tue, 26 Jul 2016 08:13:49 GMT

I tried to execute the below code in my script to have looping functionality for ODBC connection:

//Script Begins

Let vConnect=1

do while vConnect=1

ODBC Connect To testDB;

If ScriptError=0 THEN

Let vConnect=2;

Endif;

loop;

//Script Ends

The above script works fine when I reload via Qlikview application instance- it tries to reload again and again until a successful connection is established.

Is there a way to reload the task again in QMC until a connection is established, with this script or any other setting?

Re: ODBC connection time out- reconnect

marcus_sommer — Tue, 26 Jul 2016 09:18:07 GMT

I don't know the publisher but maybe there are further settings to ignore the errormode or not.

- Marcus

Re: ODBC connection time out- reconnect

Wed, 27 Jul 2016 07:02:02 GMT

I added 'Set ErrorMode =0' statement in the beginning and it worked in QMC, further used the settings in publisher to limit run time, so it doesn't run infinitely in case the issue persists for a long time. Thank you.