Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section access issues when loading with publiser?

I have created a QVW with section access and it works great on my desktop client. But when I send it to the publisher it will not load into access point. I end up getting the following errors:

     ERROR      Document open call failed. The document might require username and password.

     ERROR      The document failed to open.

     ERROR      Reload failed because the document could not be opened successfully.

     ERROR      Reload failed. Distribution Skipped.

     ERROR      The task ''Reload and Distribute - SmileyReport''failed. ErrorCount=5

We have submitted a Help desk with QlikTech and they simply replied and said they don't help with section access issues. So since I can't get any help from them I hope someone out there may be able to help me. Below is my section access script.

     Section Access;

     LOAD * INLIE [

               ACCESS,                NTNAME,               USERID

               ADMIN,          Nucornet\_qlikview     ,          1

               USER            Nucornet\ryan.worthy,            2

];

STAR IS *;

LOAD * INLINE [

     USERID, PRODUCT

          1,               *

          2,             Products

];

Labels (2)
4 Replies
stigchel
Partner - Master
Partner - Master

The server has no access due to the section acces. Maybe this thread can help you:

Continous Reload Not working

ashfaq_haseeb
Champion III
Champion III

Hi,

Make sure you add service account to section access admin access.

Regards

ASHFAQ

Not applicable
Author

If the Section Access code written in Hidden script, then i believe adding service account in Section access is important.

kuba_michalik
Partner - Specialist
Partner - Specialist

USERID is a special Section Access field usually used in conjunction with PASSWORD, I'd call it something else if it is not supposed to be a locally authenticated user login (doesn't the document throw up an "Please enter User ID" input box on open?)

Otherwise, what the others have said about adding QlikView service account to the Section Access (although Nucornet\_qlikview kinda looks like one)