Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

simongoodman
Contributor

Data load failure in QV Management Console

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?

6 Replies

Re: Data load failure in QV Management Console

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  

Not applicable

Re: Data load failure in QV Management Console

Hi,

Could it be user permissions related?

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

simongoodman
Contributor

Re: Data load failure in QV Management Console

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

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

simongoodman
Contributor

Re: Data load failure in QV Management Console

This should be it. Thanks

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

Re: Data load failure in QV Management Console

Hi,

     No this is also not a task log.

     Go to the below path for task log.

     C:\ProgramData\QlikTech\DistributionService

Regards,

Kaushik Solanki

Community Browser