We are getting an issue with the automatic load with the distribution service.
Data is not fully loaded when the automatic reloads run but when we reload manually with the same service account , the entire data loads perfectly.
The service account has added in the section access shown below with the group and branch as "ALL" ,
Initial Data Reduction Based on Section Access checked
Strict Exclusion Checked
| ADMIN | QLIKVIEW ADMIN1 | BENZ\qadmin1 | ALL | ALL |
| ADMIN | QLIKVIEW ADMIN1 | qadmin1 | ALL | ALL |
Section Access;
LOAD ACCESS,
NAME,
NTNAME,
IF(GROUP='ALL','*', GROUP) as 'Stock Group', // STOCK
IF(GROUP='ALL','*', GROUP) as Group, // PARTS SALE
IF(GROUP='ALL','*', GROUP) as GROUP., // LABOUR LOG
IF(GROUP='ALL','*', GROUP) as GROUP.., //CLOCK ENTRIE
IF(BRANCH='ALL','*', BRANCH) as Branch,
IF(BRANCH='ALL','*', BRANCH) as 'Branch Name', // W.Revenue Branch
IF(BRANCH='ALL','*', BRANCH) as Branch.Name // W.Analysis Branch
FROM
(ooxml, embedded labels, table is [P&W]);
Section Application;
Please let me know if any other settings has been missed as we are using the qlikview 11
