Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

QV Server 10 Reload Problem

Hi all,

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.

1 Solution

Accepted Solutions
Not applicable

QV Server 10 Reload Problem

@Rakesh: Switching the Provider from "SQLNCLI.1" to "SQLOLEDB" fixed the problem.

Thanks everyone for your help.

11 Replies
prieper
Honored Contributor II

QV Server 10 Reload Problem

Under Settings - Document Properties - General you may tickmark to generate logfiles and then watch what has been written there after re-run.

HTH
Peter

Not applicable

QV Server 10 Reload Problem

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

prieper
Honored Contributor II

QV Server 10 Reload Problem

Have you tried the connection outside QV? Seems that it is not registered properly.

Peter

disqr_rm
Valued Contributor III

QV Server 10 Reload Problem

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?

Not applicable

QV Server 10 Reload Problem

@Rakesh: Provider=SQLNCLI.1. I've got SQLNCLI10.DLL installed.

Thanks for the replies.

Not applicable

QV Server 10 Reload Problem

@Peter: Yeah, they work. They also work with a manual reload on the same machine. It just dies on a scheduled reload.



Not applicable

QV Server 10 Reload Problem

@Rakesh: Switching the Provider from "SQLNCLI.1" to "SQLOLEDB" fixed the problem.

Thanks everyone for your help.

Not applicable

Re: QV Server 10 Reload Problem

HI @ xingwang,

How to Switching the Provider from "SQLNCLI.1" to "SQLOLEDB"  to fixed the problem.

Highlighted
manasamale
New Contributor II

Re: QV Server 10 Reload Problem

I am facing this problem presently while trying to reload a qvw to generate qvds.Can anyone please explain me what to do..