Section Access problem with linked table

[#1]

Hi,

My section access setup has always been that I assign "roles" in the user table (that is entered in the Section Access). After that I have other excel sheets that are read in the Section Application section. This has been working well, when everything was on one server.

Now I have moved to a different setup - with separate servers for QV Server and QV Publisher - and it is no longer working. The linked tables in Section Applications are not being properly applied when the user opens the applications from the access point. One of two errors occur:

1. The document opens, but with NO RESTRICTIONS

2. The document does not open, Error message saying the user does not have access to the document.

Below is an example of the script: Please help, this is a mystery to me...

Magnus

----------------------------------------

Section Access;

Load [ACCESS],

  [NTNAME],

  [LOCATION_ROLE],

...

...

FROM [QlikView_Users.xls] (biff, embedded labels, table is [Sheet1$])

;

Section Application;

Star is #;

LOAD LOCATION_ROLE,

  LOCATION

FROM [Access.xls] (biff, embedded labels, table is [LOCATION$]);

[jagan]

Hi,

Did you done this

Document Properties -> Opening tab -> Select Initial Data reduction based on Section Access option

and try.

Hope this helps you.

Regards,

Jagan.

[#3]

I might add that the document opens properly for users that don't have any restrictions in the "Section Application". And the document reloads without problems, both in the desktop and using publisher.

[#4]

It already is like that...unfortunately not helping.

Thanks anyway!

[amars]

Can't say what could be the issue but you can debug by using the property "Initial Selection based on Section Access".

This will select the fields on which reduction is happening.

[#6]

Sorry, but I am not sure how to do that. I know where to uncheck the box, but not how that will help me?

Thanks,

Magnus

[#7 · Accepted solution]

I have now resolved this issue, but it wasn't very easy. It required a change to the excel table that I use (QlikView_Users.xls above).

The user that is being setup to run the distribution service on the publisher must be registered as ADMIN in the ACCESS column. This was already OK. The problem was that the LOCATION_ROLE column had the value "ALL". When I changed this to blank, it started working. Not sure why, got the instruction from QV Support and then it works.