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];
SQL SELECT "jsa_accountmanager1idYomiName",
Name as "jsa_agencyidname",
Can anyone suggest why the data is failing to load in the QMC? What are the possible solutions?