Discussion Board for collaboration related to QlikView Deployment.
I've got a problem with the reload task.
My scenario is as follows:
-I have 4 qv source documents.
-Each document has a reload task that is set not to run at the same time as the other 3.
-The query behind the 4 documents all access the same database and table. In fact, it is the exact same query, just with different where clauses.
What is weird is that only 1 of the 4 tasks reload properly and that is the only one that works, regardless of whether it's by the task schedule or by manually running it.
Does anyone have any ideas of why this is occurring?
Thanks in advance.
Go to Solution.
@Rakesh: Switching the Provider from "SQLNCLI.1" to "SQLOLEDB" fixed the problem.
Thanks everyone for your help.
Under Settings - Document Properties - General you may tickmark to generate logfiles and then watch what has been written there after re-run.
I got the following with the document log:
4/5/2011 1:15:30 PM: 0013 OLEDB CONNECT*Provider*
4/5/2011 1:15:30 PM: Error: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered
4/5/2011 1:15:30 PM: General Script Error
4/5/2011 1:15:30 PM: Execution Failed
4/5/2011 1:15:30 PM: Execution finished.
Some more background info:
-I'm using QV Server 64bit Version 10.
-The server is running on MS Windows Server 2003 64bit.
-It's trying to connect to MS SQL Server 2005 64bit
Have you tried the connection outside QV? Seems that it is not registered properly.
Seems to be problem with 32bit 64bit combination for QV and OLEDB driver. What version of OLEDB Provider driver you have? Is it 32 bit one?
@Rakesh: Provider=SQLNCLI.1. I've got SQLNCLI10.DLL installed.
Thanks for the replies.
@Peter: Yeah, they work. They also work with a manual reload on the same machine. It just dies on a scheduled reload.
HI @ xingwang,
How to Switching the Provider from "SQLNCLI.1" to "SQLOLEDB" to fixed the problem.
I am facing this problem presently while trying to reload a qvw to generate qvds.Can anyone please explain me what to do..