Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hi,
Could it be user permissions related?
Check which username QlikView services are using, maybe this username does not have the necessary rights.
Hi Kaushik, attached is the log, Thanks for the help.
Simon
On Fri, Apr 19, 2013 at 1:34 PM, Kaushik Solanki
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
This should be it. Thanks
On Fri, Apr 19, 2013 at 2:11 PM, Kaushik Solanki
Hi,
No this is also not a task log.
Go to the below path for task log.
C:\ProgramData\QlikTech\DistributionService
Regards,
Kaushik Solanki