Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have an issue facing in data when automatic reloads with the distribution service.
The data is not loading fully when automatic reloads runs at morning using the service account(distribution service).
But when reload manually with the same service account , the data is loading perfectly.
The Initial Data Reduction Based on Section Access & Strict Exclusion are checked. We have section access defined as below .
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
(
Section Application;
Please let me know what could be the reason.
Any errors in the log files?
Does the document reload scheduled if you disable section access?
Hi,
I have strugeling a lot With this, when you run it from Publisher it seams that only ONE ADMIN is allowed and that is the service account. Try to delete one of the ADMIN and reload it from Publisher.
Section access has no influence to the records which will be loaded - section access will restrict the data (by reducing the data) to the set authorization while opening an application. Are after opening the application through an administrator who should see all data not all data available then you hadn't authorized all available data. The use of "*" as wildcard worked only to real values and not for NULL which couldn't considered in any way (unless you replaced NULL with something like 'Null').
- Marcus
No errors in Log File
When I removed the code in the section acess and run from the Publisher , it is loading all the data.
Hi ,
Thanks for the answer.
We got a complaint from the user for a particular group , the data is not loading correctly and also when we compare with our DMS application.
Upon further analysis , we tried to manual reload the document with the same service account and the data is loading correctly.
Then we tried the remove the code from the section access code and data was loading correctly when ran from the publisher .
Hence we finalized , it was problem with the section access.
Thanks,
Jojee
Why not separate the two process
1) One QVW file to load the data and store in QVD without Section Access
2) Load the QVD in the Final APP with Section Access
Hi Rupam,
Many thanks the reply.Is there any way to skip the session access code while reloading through the service account or from the publisher.
Thanks,
Jojee
This meant that not all of your values from your authorization-keyfield have a valid counterpart and therefore those data will be reduced/removed. Now it's on you to decide if you have a topic with the data-quality which needs to be fixed or not.
- Marcus