6 Replies Latest reply: Oct 10, 2012 6:41 AM by Göran Hofstedt RSS

    Out of memory

    Göran Hofstedt

       

       

       

      Hi

       

      Can someone help me to understand what the following does in the script? After the last two steps it continues with 10 more steps but with diffrent QCode, The problem is that QV goes out of memory after 6 steps so in some way I have to rewright the script.

       

       

      Tmp_MeritValue:

      Load *,

       

      if(RadNr = 12 and MeritValue> 0, ID) as Behor_12

      ;

       

       

      Load *,

      if(previous(ID) = ID, peek(RadNr)+1, 1) as RadNr

      Resident Tmp_MV2

      Order By ID, MeritValueDesc;

      Drop Table Tmp_MV2;

       

      MeritValue:

       

       

       

       

       

       

      Load

      DistinctID as ID_12

      Resident Tmp_MeritValue

      where isNull(Behor_12)=0;

       

       

      Tmp_Behor_12:

      Load

      ID as ID_Behor,

      MeritValue as MV_SV

      Resident Tmp_MeritValue

      where exists(ID_12, ID) and QCode= 'SV';

      join
      Load
             ID as ID_Behor,
             MeritValue as MV_SVA
      Resident Tmp_MeritValue
      where exists(ID_12, ID) and QCode= 'SV2'; 

        • Re: Out of memory
          Miguel Angel Baeyens de Arce

          Hi,

           

          There is some script missing, the table Tmp_MeritValue loads from resident table Tmp_MV2. Which version are you running? In the script editor, when you Debug instead of normal reloading, what message does it show and where it does stop?

           

          Regards,

           

          Miguel

            • Re: Out of memory
              Göran Hofstedt

              Hi

              Tmp_MV2 are ok, it´s beeing droped right after the second step from above in the previous post.

              I only get a "Out of virtual and/or logical memory allocating 2 MB" message. Runs qv 10.

               

              The script continue as follow

               

              joinLoad
                      
              ID as ID_Behor,
                       MeritValue
              as MV_EN

              Resident Tmp_MeritValue

              where exists(ID_12, ID) and QCode= 'EN';

               

              join

              Load

                   ID as ID_Behor,
                       MeritValue
              as MV_MA

              Resident Tmp_MeritValue

              where exists(ID_12, ID) and QCode= 'MA';


              join Load

                   ID as ID_Behor,
                       MeritValue
              as MV_FY

              Resident Tmp_MeritValue

              where exists(ID_12, ID) and QCode= 'FY';

              ....

              Load

              Same as above but diffrent QCode....After the 6th it goes out of memory.

               

              So, Can you help me understand what the

              " where isNull(Behor_12)=0; " means/does in the above post?

              and what where exists(ID_12, ID) means/does? - I think this sorted out the fields where ID_12 are the same as ID and my guess is that there ID_Behor stacks up with several thousands per ID. Because if I only goes for say 3 join steps and then abort and click "show freqvens" in the ID_Behor field it already there have freqvens for each ID of app 6000.