4 Replies Latest reply on Mar 2, 2017 10:39 AM by edrft_99

    LEM Reports

    edrft_99

      I have been having an issues over the past few days with LEM reports. If I try to run a report for weeks worth of data, the program eventually fails and comes back with out of system resources. Any ideas?

        • Re: LEM Reports
          rharland2012

          Take a look at this:

           

          Best Practices for LEM Memory Allocation

           

          tldr - sounds like you may need to give your LEM box more resources.

          If you run the same report for a day's timeframe and it returns data successfully, I'll wager this is the issue.

          • Re: LEM Reports
            curtisi

            LEM keeps the last seven days worth of data uncompressed to make Reporting and searching faster.  The assumption is that you'll more frequently want to be investigating what just happened, not ancient history.

             

            After 7 days, LEM compresses the data.  That means any search that includes dates/times outside the last 7 days will require more time and resources as LEM has to find the right compressed DB partition, decompress it, search it, get the data, return the data, re-compress it and move to the next section.

             

            There are also limits in Reports, so any query that would return more than 10 million results (I think) will fail.

             

            If you're regularly expected to present "weeks" worth of data, it may be more efficient to schedule weekly reports and then show multiple weekly reports instead of one "many weeks" report.

            • Re: LEM Reports
              edrft_99

              So I tried to first just up the resources to 32GB of RAM but had no luck. So i Just deiced to schedule the report to run the report on Saturday morning of the current week. Thanks for the help.