3 Replies Latest reply: Jan 14, 2013 8:10 AM by Märt Tikan RSS

    Server Failed To Reload

    Helen Pippard

      Hello

       

      Could someone kindly provide me with some advice to what to check next

       

      I have a document which I had scheduled on the enterprise managment console and it was reloading O.K. this morning

       

      I then added in section access information and I think the document then starting failing to reload

       

      I decided to comment the section access out and start again and turned the Relaod Schedule to None

       

      I ahve rescheduled and the document now fails every time it tries to reload

       

      I have turned on "Generate Log" in the QVW but this is not being generated

       

      Does anyone have any suggestions?

       

      Thanks

      Helen

        • Re: Server Failed To Reload

          If you added section access, make sure, that the admin user, reload engine is using, is added to section acess.

           

          If you commented it out, it should work like it used to worked. (did you leave the doc name the same...)

            • Re: Server Failed To Reload
              Helen Pippard

              Hello

               

              Thank you for your reply and advice

               

              Below is the section access I have been using....Does it look sufficient to you?

               

               

              Section Access;

              LOAD
                  'S-1-5-21-133631074-2907035605-456469473' as NTDOMAINSID,
                   USER as NTNAME,
                   ACCESS as ACCESS,
                   PATIENT_LEVEL,
                   SHEET_ACCESS
              FROM
              C:\QLIKVIEW\ACCESS\Dashboard_Access.xlsx
              (ooxml, embedded labels, table is ACCESS);

              Section Application;


              ACCESS_CONTROL:
              load * inline [
              PATIENT_LEVEL,access_type
              1,Y
              0,N
              ];


              SHEET_ACCESS:
              LOAD *
              FROM
              C:\QLIKVIEW\ACCESS\Dashboard_Access.xlsx
              (ooxml, embedded labels, table is SHEETS);

               

              I keep the set up of usernames in a spreadsheet

               

              Thanks

              Helen

               

               

                • Re: Server Failed To Reload

                  I use such version.....

                   

                  Section access;
                  LOAD * INLINE [ ACCESS, NTNAME, NTDOMAINSID
                  ADMIN, USER1, XXXXXXXXXXX
                  ADMIN, USER2, XXXXXXXXXXX
                  ADMIN, USER3, XXXXXXXXXXX
                  ADMIN, QVSERVICE, XXXXXXXXXXX
                  // I have this user as my admin user.....
                  USER, USER4, XXXXXXXXXXX
                  USER, USER5, XXXXXXXXXXX
                  USER, USER6, XXXXXXXXXXX
                  ]
                  ;
                  Section Application;

                   

                  Do you have „your“ QVSERVICE (this is the user, witch QMC is using to reload files) written into your xls spreadsheet - Dashboard_Access.xlsx?