5 Replies Latest reply: Jan 19, 2016 4:37 PM by Bill Britt RSS

    Section Access Problem

    Ralph Graham

      Hello,

       

      I've used section access on several occasions and it has generally been straightforward to implement, however I'm having a "Failed to open document" error through Access Point. I've checked various forum posts and the account that runs the services is added to the spreadsheet that controls access and everything looks ok from my end. Also it works fine when running locally through QV Desktop, the issue is only from the Access Point.

       

      Thanks,


      Ralph

       

       

       

      My script is below:

       

      star is *;

      Section Access;
      SATABLE:
      LOAD

      upper(ACCESS) as ACCESS,
        upper(NTNAME) as NTNAME,
      upper(SAUSER) as SAUSER
      FROM
      [J:\Qlikview\resource\SA.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      Section Application;
      DocSecurity:
      LOAD

      upper(SAUSER) as SAUSER,
      upper(FIELDACCESS.SCHOOLFILTER) as Employee.link
      FROM
      [J:\Qlikview\resource\SA.xlsx]
      (ooxml, embedded labels, table is Sheet1);


      My Error log is below:


      2015-12-10 06:24:53 2016-01-07 11:02:59 4 700 Information File Upload: File upload initiated (HR/HR Reporting_Section Access.qvw)

      2015-12-10 06:24:53 2016-01-07 11:03:00 4 700 Information FileClose: Upload completed (HR/HR Reporting_Section Access.qvw)

      2015-12-10 06:24:53 2016-01-07 11:03:05 4 700 Information FileClose: Upload completed (Library/Library.qvw)

      2015-12-10 06:24:53 2016-01-07 11:03:20 4 700 Information Ticket created: Ticket (89DA9ED63D128A3FD0D528C28FA02514F3C1F332) for BELFASTMET\RalphGraham.

      2015-12-10 06:24:53 2016-01-07 11:03:20 4 700 Information Ticket Lookup: Ticket 89DA9ED63D128A3FD0D528C28FA02514F3C1F332 was found.

      2015-12-10 06:24:53 2016-01-07 11:03:20 4 700 Information DOC loading: Beginning load of document J:\QLIKVIEW\DIVISION\HR\USERDOCS\HR REPORTING_SECTION ACCESS.QVW.

      2015-12-10 06:24:53 2016-01-07 11:03:22 4 700 Information Document Load: The document J:\QLIKVIEW\DIVISION\HR\USERDOCS\HR REPORTING_SECTION ACCESS.QVW was loaded.

      2015-12-10 06:24:53 2016-01-07 11:03:22 4 700 Information Document Open: Open document: No access to document HR/HR Reporting_Section Access.qvw

      2015-12-10 06:24:53 2016-01-07 11:03:22 2 500 Warning Document Load: The document J:\QLIKVIEW\DIVISION\HR\USERDOCS\HR Reporting_Section Access.qvw failed to load because of no file access [19].