Discussion Board for collaboration on QlikView Publisher.
Below code causes schedule to fail
LOAD Upper(ACCESS) as ACCESS,
upper(NTNAME) as NTNAME,
upper( LEVEL) as LEVEL
without this code application work fine.
i have two machine .one without publisher and second with.
on first Machine application with section access working peroperly.even schule task running properly.
but on the other machine its not working.
i have also tried section access for service account and make Level as Blank but its not working.
Please suggest a solution?
What does it mean "not work?"
You cannot open the application or only section access is not applied? If the second verify that on the machine the NTUser is recognized (the computer is in the domain?)
Try reloading from that second machine manually, to see what what error it is throwing.
If it works fine from 1 but not 2 then it sounds like the NTNAME for machine 2 may be missing/mistyped
mannually its working from both machine but using schedule its not working from second machine
i can open reload but using publisher tasks application not even opening. as there is no document log generating
and machine 2 is the one with publisher? Have a look at the distribution service and make sure the user running that is in your section access list and set to admin access
To start reduce your section access to the basic using only access and NTNAME. You need to make sure the Service Account that is running the services is in section access as Administrator.
As Bill says, you need to make sure the service account(the account on which QlikView Distribution Service is running) should also be a part of the NTNAME.
Is NTNAME part of your service account. Please add it in your section access. IT should work.
Are you using publisher to distribute the file once reloaded to machine 2?
What Section Access settings do you have? Initial Data Reduction Based on Section Access? Strict Exclusion?