topic Re: ODBC read failed in QlikView

ODBC read failed

danishar — Wed, 18 Mar 2015 14:54:00 GMT

Hi
I'm trying to contact ODBC tables
Sometimes the connection fails
Is there a way to know when it fails?
I want to create conditions that if there is an error to wait a while (sleep) and then try again
How can you identify this kind of error?

My condition should look like this:

ODBC CONNECT TO DB (XUserId is USERNAME, XPassword is PASS);
if [Error: ODBC read failed] then
sleep 10000;
END IF

I want to run a loop 1 hour (every 10 minutes)

Thank you!

Re: ODBC read failed

luciancotea — Wed, 18 Mar 2015 15:01:37 GMT

Play with:

ErrorMode

ScriptError

ScriptErrorDetails

ScriptErrorCount

ScriptErrorList

functions. Set ErrorMode = 0 to prevent script from stopping, then read the error. repeat until no error or time > 1hour

Re: ODBC read failed

danishar — Wed, 18 Mar 2015 16:27:54 GMT

Thanks for the tip

it works like this:

set ErrorMode=0;

FOR i=1 to 6 // 6times=1hour

ODBC CONNECT TO DB (XUserId is USERNAME, XPassword is PASS);

if ScriptError=0 then

SLEEP 6000000; //1000=1sec 6000000=10min

end if

NEXT