topic Re: Data load failure in QV Management Console in QlikView

Data load failure in QV Management Console

simongoodman — Fri, 19 Apr 2013 12:30:45 GMT

A QVW is failing to load any data via the Qlikview Management Console (QMC) Reload function. The Task History shows the reload as 'Succeeded'. While the document can be manually reloaded in a local directory but after this version is saved to AccessPoint the QMC Reload runs leaves no data in the QVW.

The script loads data from excel and with several OLEDB with SQL SELECT statements, some with INNER JOIN, UNION ALL and WHERE. Below is an example:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=JSAGroup_MSCRM;Data Source=jsa-crmsql01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=JSA-4ZFG95J;Use Encryption for Data=False;Tag with column collation when possible=False];

Parent:

SQL SELECT "jsa_accountmanager1idYomiName",

Name as "jsa_agencyidname",

ParentAccountIdName

FROM "JSAGroup_MSCRM".dbo.Account;

Can anyone suggest why the data is failing to load in the QMC? What are the possible solutions?

Re: Data load failure in QV Management Console

kaushiknsolanki — Fri, 19 Apr 2013 12:34:43 GMT

Hi,

it will be hard to tell you without actually having look at the log files.

Kindly send the task log files.

Regards,

Kaushik Solanki

Re: Data load failure in QV Management Console

Fri, 19 Apr 2013 12:39:55 GMT

Hi,

Could it be user permissions related?

Check which username QlikView services are using, maybe this username does not have the necessary rights.

Re: Data load failure in QV Management Console

simongoodman — Fri, 19 Apr 2013 12:58:04 GMT

Hi Kaushik, attached is the log, Thanks for the help.

Simon

On Fri, Apr 19, 2013 at 1:34 PM, Kaushik Solanki

Re: Data load failure in QV Management Console

kaushiknsolanki — Fri, 19 Apr 2013 13:11:51 GMT

Hi,

This is a Document Log.

Kindly send the Task log, you will get the folder where the task log is stored under QEMC.

Go to QEMC -> System -> Setup -> QlikView Server -> Logging -> Log Folder

Regards,

Kaushik Solanki

Re: Data load failure in QV Management Console

simongoodman — Fri, 19 Apr 2013 14:34:42 GMT

This should be it. Thanks

On Fri, Apr 19, 2013 at 2:11 PM, Kaushik Solanki

Re: Data load failure in QV Management Console

kaushiknsolanki — Sat, 20 Apr 2013 05:39:42 GMT

Hi,

No this is also not a task log.

Go to the below path for task log.

C:\ProgramData\QlikTech\DistributionService

Regards,

Kaushik Solanki