section access code not working on publisher

[SunilChauhan]

Below code causes schedule to fail

Section Access;

LOAD Upper(ACCESS) as ACCESS,

    upper(NTNAME) as NTNAME,

  upper( LEVEL) as LEVEL

  From

[Path.xls]

Section Application;

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?

[alexandros17]

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?)

[#3]

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

Joe

[SunilChauhan]

Thanks

mannually its working from both machine but using schedule its not working from second machine

[SunilChauhan]

Thanks

i can open reload but using publisher tasks application not even opening. as there is no document log generating

for this.

[#6]

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

[Bill_Britt]

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.

Bill

[NareshGuntur]

Hi Chauhan,

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.

Cheers,

Naresh

[#9]

Is NTNAME part of your service account. Please add it in your section access. IT should work.

Thanks!

[simondachstr]

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?