Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

MVP & Luminary
MVP & Luminary

Oracle OLEDB Select hangs when run from server task

Win2003 x64 Server, QVS 9 SR3, Oracle 10.2.0.1.0.

Qlikview services are running with a local Administrator account.

OLEDB connection, userid & password provided in the connection string.

When I reload from QV Developer, on the server, logged in as Administrator, the reload runs fine.

When I run the reload as a task from QEMC, the reload hangs at the point of doing the SQL SELECT. The DBA is pretty sure he sees my connection being made, but no select running.

Any ideas?

Thanks, Rob

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Oracle OLEDB Select hangs when run from server task

Fixed by upgrading to SR4.

-Rob

3 Replies
MVP & Luminary
MVP & Luminary

Oracle OLEDB Select hangs when run from server task

Fixed by upgrading to SR4.

-Rob

Not applicable

Oracle OLEDB Select hangs when run from server task

I am running QV9 SR4 and am having the same issue with the Oracle Ole DB connection. I am not having any issue with QlikView documents connecting to SQL Servers when run through QEMC. Are there any server settings that need to be changed to allow the Oracle Ole DB connection to work?

Not applicable

Oracle OLEDB Select hangs when run from server task

The solution is to reboot the server after installing QlikView Server v9 SR6, installing the oracle driver and setting up the TNS entries. Just restarting the QlikView services will not fix the issue. Had to reboot the server after installing qv9 on a test server and on a production server before the ORacle Ole DB connection would work in a reload job over the server,

Community Browser