8 Replies Latest reply: Jan 22, 2014 9:12 AM by Srikanth P RSS

    Section Access Reload from QVD fails

    Peter Cammaert

      Hi,

      I'm trying to reload a Section Access table from a QVD that's generated by another QV app. This other app contains nothing more than the following script:

       

      SA_Accounts:
      LOAD * INLINE [
      ACCESS, USERID, PASSWORD, DEPT
      ADMIN, Admin, Admin,
      USER, Peter, Peter, ZSW
      USER, Ilse, Ilse, WSZ
      ];
      STORE SA_Accounts INTO SA_Accounts.qvd (qvd);

      SA_Depts:
      LOAD * INLINE [
      DEPT, TEXT
      ZSW, Department Z
      WSZ, Department W
      ];
      STORE SA_Depts INTO SA_Depts.qvd (qvd);



      The Reload script in the main app looks like this:

       

      Section Access;
      LOAD [ACCESS],
      [USERID],
      [PASSWORD],
      DEPT
      FROM SA_Accounts.qvd (qvd);

      Section Application;
      Star is *;
      Directory;
      LOAD DEPT,
      TEXT
      FROM SA_Depts.qvd (qvd);



      Executing this script will generate a General Script Error (?). Apparently the script crashes on the Section Access LOAD statement.
      See failing QVW and both QVDs in attachment.

      What am I doing wrong here? BTW I'm running QVD9SR4.

      Kr, Peter

        • Section Access Reload from QVD fails
          Terje Knappen

          Hi Peter

           

          Did you have any luck finding an answer?

          I have a nearly identical script and the exact same problem.

           

          regards

          Terje Knappen

          • Section Access Reload from QVD fails
            Miguel Angel Baeyens de Arce

            Hello Peter and Terje,

            First, you must load all fields from external sources when in section access in uppercase:

             

            Section Access;LOAD UPPER(ACCESS) AS ACCESS, UPPER(USERID) AS USERID, UPPER(PASSWORD) AS PASSWORD, UPPER(DEPT) AS DEPTFROM SA_Accounts.qvd (qvd);


            Besides, try to load the section access table in an unoptimized form, changing the following line:

             

            FROM SA_Accounts.qvd (qvd) WHERE 1=1;


            See if that helps.

              • Section Access Reload from QVD fails
                Terje Knappen

                Thanks Miguel!

                 

                Unoptimized form solved my problem!

                 

                /Terje

                • Re: Section Access Reload from QVD fails

                  Hi Miguel!

                   

                  My case it's a little more serious. My app crashes when I enable the reduction data. I'm not loading the section access from a QVD, I wrote the section access in the qvw:

                   

                  Section Access;

                  Star is *;

                  LOAD * INLINE [

                      ACCESS,   PASSWORD, NTNAME,                                 USERID,  COD_GRUPO

                      ADMIN,    ADMIN,                  *,                                          ADMIN,      *

                      USER,     *,                  ALTENBURG\QLIKVIEW.ADMIN,           *,         1

                      USER,     *,                  ALTENBURG\DIETMAR.PISKE,             *,         1      

                      USER,     *,                  ALTENBURG\EDUARDO.CUCO,            *,         2

                      USER,     *,                  ALTENBURG\FABIO.SIMON,                 *,         1   

                      USER,     *,                  ALTENBURG\CRIS,                               *,         2   

                      USER,     *,                  ALTENBURG\JACQUELINE.GONCALVES, *,         2       

                      USER,     *,                  ALTENBURG\JACIARA.WERKA,             *,         2           

                      USER,     *,                  ALTENBURG\JOSE.JUNIOR,                   *,         5

                      USER,     *,                  ALTENBURG\FERNANDO.DALRI,             *,         4   

                      USER,     *,                   ALTENBURG\GLAUCIO.GIL,                    *,         2

                      USER,     *,                  ALTENBURG\EDGARD.MACHADO,          *,         4   

                      USER,     *,                  ALTENBURG\ROBERT.BERTHIER,           *,         5       

                  ];

                  Section Application;

                   

                  What should I do? May you help me?

                    • Re: Section Access Reload from QVD fails
                      Srikanth P

                      Hi Eduardo , If you are using NTNAME you dont need a Password and UserID because the NTNAME will authenticate the user. Please try Like Below:

                       

                      Section Access:

                       

                      STAR is * ;

                       

                      LOAD * INLINE [

                      ACCESS , NTNAME , COD_GRUPO

                       

                      ] ;

                       

                      Please make sure check the "Initial Data reduction by Section Access" option on Document Properties --> Opening Tab