Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

kdejong
New Contributor II

Auto reload Qlikview Dashboard

Hello,


I've got a question considering the auto reload of a QVW.

In the script there's the following OLEDB connection:

OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=DB****;Data Source=*****] (XPassword is scrambled password);


The manual reload works excellent, the auto reload returns an error in the log file:
021  OLEDB CONNECT32*Provider*XPassword*

Error: ErrorSource: (null), ErrorMsg: (null)

General Script Error

Execution Failed

Execution finished.


What needs to be done to make the auto reload work?


Thanks for any help finding a solution

5 Replies
MVP & Luminary
MVP & Luminary

Re: Auto reload Qlikview Dashboard

No idea. But check:

1. The oledb driver is installed on the machine that does the reloading

2. You have the correct 32-bit version of the driver installed on that machine

You could also try installing the Oracle OLEDB driver from Oracle itself and connect using that driver.


talk is cheap, supply exceeds demand
roger_stone
Contributor III

Re: Auto reload Qlikview Dashboard

Make sure that the QlikView server account has access to the database table. It looks like you have access but the server account does not.

manojkulkarni
Valued Contributor II

Re: Auto reload Qlikview Dashboard

Tick the Force 32bit check box (Forced the OLEDB connection to 32-bit ). Should solve the issue

kdejong
New Contributor II

Re: Auto reload Qlikview Dashboard

The checkbox is ticked. So i can rule this out.

kdejong
New Contributor II

Re: Auto reload Qlikview Dashboard

Gysbert and Roger thanks for your responses.

I'll let you know if your responses provided the solution