5 Replies Latest reply: Mar 15, 2012 12:13 PM by Guy Davidovich RSS

Section Access on Server

Blair Gibb

Hi All,

 

We have an application that uses Section Access utilizing the NTUser to restrict access for our users.  We are using a csv file to store the data for accessing the application.  This is the format (names changed to protect the innocent...)

 

ACCESSNTNAMEUSERDN
ADMINDOMAIN\BLAIR.GIBB
USERDOMAIN\first.user6703
USERDOMAIN\first.user6707
USERDOMAIN\first.user6708

...

ADMINDOMAIN\server

 

The application works correctly on my local machine, but not when it is loaded onto the server.  Here is the part of the log entry concerning the load of the csv file:

 

(2011-10-26 08:48:42) Error: Document open call failed. The document might require username and password.

(2011-10-26 08:48:42) Error: The document failed to open.

 

We have tried adding the domain\username of the server as an admin, and have unchecked strict access.  The file has loaded before - I believe the server has access to the folder that it is attempting to read from.

Any ideas?

  • Section Access on Server
    Kiran Rokkam

    Is the file in the server or shared drive? If its in shared drive you need to give read permissions to the NTID you are reloading with.

     

    Did you make sure the Directory path of the file is correct?

     

    Regards,

    Kiran.

    • Section Access on Server
      Blair Gibb

      It can see the file - it has loaded before.  I don't believe that is the issue.

       

      Here is some more hopefully pertinent information.

       

      On the Reload Schedule tab on the server, the Data Protection section gives this error in the username field when the section access check box is clicked:

       

                encryption error Invalid character in a Base-64 string.   

       

       

      • Section Access on Server
        Blair Gibb

        UPDATE:

         

        I loaded the section access data into SQL Server and then did the load from that.  Still getting the same problem.  Not a file access problem at all.

         

        It appears that the server doesn't think it has access to the qvw document because of the security placed on it by loading it elsewhere.  Does the development, at least this last build, need to take place on the server?  The NTNAME of the user that the server is running under is listed in the data as an admin.  And the data is now all capitals.

         

        What we are trying to do is limit the data that people can see by their NT username.  Has anyone done this successfully that can point us in the right direction?

        • Section Access on Server
          Blair Gibb

          Didn't want to leave this hanging. 

           

          The problem turned out to be an incorrect NT username for the server.  We were given the wrong name!

           

          Once we added that name to the list, everything worked.  The QlikView document couldn't load because the server user didn't have rights to it.

          • Section Access on Server
            Guy Davidovich

            Hi,

             

            I had a similair problem when a document that was reloaded with no problem by a task, was having this error after a SECTION ACCESS was added to its script.

            The Solution was to add the NT User of QV services to the ADMIN ACCESS list. you can get this username at "Log On As" column in the Services window (via Admninstrative tool) .

             

            Cheers,

            Guy