Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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;
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.
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.
You can find the details in the server reference manual.