Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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
Honored Contributor

Re: Section access issues when loading with publiser?

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

Continous Reload Not working

Re: Section access issues when loading with publiser?

Hi,

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

Regards

ASHFAQ

Not applicable

Re: Section access issues when loading with publiser?

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

kuba_michalik
Contributor III

Re: Section access issues when loading with publiser?

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)

Community Browser