3 Replies Latest reply: May 30, 2012 5:57 AM by ajeet tomer RSS

    Error: Out of virtual and/or logial memory

      I have error: Out of virtual and/or logial memory 2 MB when downloaded data. RAM: 32 gB, processor: 4. QlikView are used 5 gB of RAM.

      Number of rows are approximately 50 million.

      I rewrited script in several view and it didn't help. I don't understand where is problem. Thank's for any help.

       

      Following script:

       

      AmountTb:

      LOAD amount,
      typeid as amounttype,
      recordid,
      CurrencyId,
      Inserted as aminsert,
      month (Inserted) as Month,
      Year (Inserted) as Year,
      Day (Inserted) as Day
      FROM
      D:\Tables\AmountTb.qvd (
      qvd)
      Where amount>10 and typeid = 266;

      RecordTb:
      LOAD contractid,
      id
      FROM
      D:\Tables\RecordTb.qvd (
      qvd);

      inner join (AmountTb)

      load id as recordid,
      contractid
      Resident RecordTb;

      DROP Table RecordTb;

        • Error: Out of virtual and/or logial memory
          ajeet tomer

          Hi

           

          Here inner join will not work.

          QV support innerjoin by default,

           

          here you can use left join if needed. as i don't think u need any join.

           

          bcz conractid is only one field on that base both two tables get joined and buil data model.

            • Re: Error: Out of virtual and/or logial memory

              Hi,

              thanks a lot for your answer.

              I rewrited script:

              AmountTb:
              LOAD amount,
                   typeid as amounttype,
                   recordid,
                   CurrencyId,
                   Inserted as aminsert,
                   month (Inserted) as Month,
                   Year (Inserted) as Year,
                   Day (Inserted) as Day
              FROM
              D:\Tables\AmountTb.qvd (qvd);

               

              RecordTb:
              LOAD contractid,
                   id as recordid

              FROM
              D:\Tables\RecordTb.qvd (qvd);

              But it doesn't work on whole data base. When I checked on limitation data it was working. But when I want to upload all data QlikView returned error: Out of virtual and/or logial memory 2 MB.

            • Re: Error: Out of virtual and/or logial memory
              ajeet tomer

              Hi

               

              Plz go through the test application i attached. here is ur solution..

               

               

              bcz this error comes only when

               

              * Bad DataModeling

              Join the data table carefully.

               

               

              Thanks

              Ajeet