topic Re: QDS task keep running while trying to connect Oracle via OLEDB in QlikView

QDS task keep running while trying to connect Oracle via OLEDB

Tue, 16 Jun 2015 20:47:52 GMT

This is our first implementation of QlikView 11. Everything went well with development server but after deploying QVD Generator qvws on production server, I am not able to run the reload tasks from QMS that tries to connect to Oracle DB via OLEDB driver.

When I am trying to open same qvw in desktop version on the server and run, it works fine and uses the same driver. Also both development and production boxes installation versions are same. Not sure whats the issue here.

QlikView 11 installed on Win2012 64bit

The only line in my script is as below. There are no other statements in this test QVW.

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxxx;Data Source=xxxx;Extended Properties=""] (XPassword is xxxxxxxx);

Please help.

Re: QDS task keep running while trying to connect Oracle via OLEDB

Wed, 17 Jun 2015 21:17:46 GMT

Further information:

I logged on to the prod server using the service account that runs the QV services and tried to reload qvw via desktop (on the server) and worked fine.

Job log shows -- reloading... statements keep on repeating until I kill the talk in QMC.

Re: QDS task keep running while trying to connect Oracle via OLEDB

Thu, 18 Jun 2015 20:24:49 GMT

Issue got resolved after completely restarting server. Shutdown and then start (not restart). Hope this will help.