topic Re: Failover/secondary DB connection string in QlikView

Failover/secondary DB connection string

Thu, 09 Jun 2016 12:34:13 GMT

Hi Guys,

I have a QVW application that generates QVD files from primary SQL database.

I also have a mirror database copy of that primary server.

What function should I use or what statement to use in the connection string so in case of primary server is down then it will automatically connect to the mirror database?

Re: Failover/secondary DB connection string

Digvijay_Singh — Thu, 09 Jun 2016 12:51:57 GMT

Something similar discussed over here by pcammaert‌

Failover Partner issue or other kind of error? | Qlik Community

Re: Failover/secondary DB connection string

PradeepReddy — Thu, 09 Jun 2016 13:02:13 GMT

try something like this...

DB Connection1; //Primary Database connection

IF ScriptError=3 or ScriptError=4 then

DB Connection 2; // mirror database connection

END IF

Load Stmt1;

Load Stmt2;

Re: Failover/secondary DB connection string

rubenmarin — Thu, 09 Jun 2016 13:03:13 GMT

Hi Lokesh, I didn't tried but maybe using the script error variables, ie:

SET ErrorMode = 0; //If any error is found, continue execution

CONNECT To MainConnection;

IF ScriptError >0 then //If there was an error connecting try this

SET ErrorMode = 1; // If this one fails an error must be thrown

CONNECT TO FailoverConnection;

ENDIF

SET ErrorMode = 1; // In case there was no error, set ErrorMode to 1 for the rest of the script.