Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

matancha
Contributor

Connect Via OLEDB - Timeout

Hello All.

On my server (Windos Server SP2 - QV10) I have a script that reload qvw file (my reloads schedule By external scheduler - JIT Scheduler) :

"C:\Program Files\QlikView\Qv.exe" /r "C:\QlikView\Model-Rolls Data Retrieval\Model\Rolls Data Retrieval.qvw"

Some times (maybe because connection erors, etc.) this reload   - hangs on the row:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=XXX ;Data Source=XXX ;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID= XXX;Use Encryption for Data=False;Tag with column collation when possible=False]

And not go on (see pic attached.).

It's possible to set a timeout for OLEDB CONNECT ?

Example (pseudo):

If (tmieout for OLEDB CONNECT TO... > 3000, Exit Script)...

So if I'll geting a connection error I will can do "Exit Script"...

Maybe another solution?

Sorry on my english,

Tnks -

Matan.

1 Solution

Accepted Solutions
matancha
Contributor

Re: Connect Via OLEDB - Timeout

Think that I got it.

set ErrorMode=0;

OLEDB CONNECT TO [Provider=SQLOLEDB.1; ....... ; Connect Timeout=5] ;

IF (ScriptError>0) THEN
EXIT Script;
ENDIF;

2.Somone can help me with -  qlikviewdistributionservice.exe ? Where can i find details?

Tnks -

Matan.

4 Replies
danielrozental
Honored Contributor II

Connect Via OLEDB - Timeout

If you're using external reloads you should look into using the qlikviewdistributionservice.exe to do it.

Yes, you can set timeouts on oledb connections but sorry, I'm not sure about the correct syntax, try Connection TimeOut=60;

matancha
Contributor

Re: Connect Via OLEDB - Timeout

Hello Daniel.

Thanks for your response.

Where can i check for qlikviewdistributionservice.exe ?

Where i type the connection Time out?

Somthing like this?

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True; TimeOut = 60 ] etc...

Tnks again -

Matan.

matancha
Contributor

Re: Connect Via OLEDB - Timeout

Think that I got it.

set ErrorMode=0;

OLEDB CONNECT TO [Provider=SQLOLEDB.1; ....... ; Connect Timeout=5] ;

IF (ScriptError>0) THEN
EXIT Script;
ENDIF;

2.Somone can help me with -  qlikviewdistributionservice.exe ? Where can i find details?

Tnks -

Matan.

danielrozental
Honored Contributor II

Re: Connect Via OLEDB - Timeout

You can find the details in the server reference manual.

Community Browser