Skip to Content
avatar image
Former Member

Rgd: Client out of memory in BEx Analyzer

Hi Guys,

I have BEx 7.0 Analyzer, I am trying to run nearly 55k lines of query with 34 column.

I get an error message client out of memory. If i run the same in rsrt and web analyzer it works fine.

Is there a way to increase the BEx analyzer memory or BEx analyzer is limited to number of cells?

I am using excel 2007.

If I remove 10 columns from the query it works fine, I think this is due to the number of cells restriction.

Is there any way to fix this issue?

Regards,

Anand

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Oct 13, 2010 at 02:25 PM

    Hi Anand,

    Your file is a big file, its very common to get such kind of issues.

    You can check with the basis team to increase the memory allocated on server for running the queries but i dont foresee it being of much more use.

    Its better to restrict/ remove few coloumns.

    Please close the thread if you feel the question is answered. Keep the Forum clean.

    Regards,

    Den

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      This is memory issue. Please see the OSS note 1040454. The maximum memory for front end processor = 1.2 GB. To find the memory used use the formula

      mem = 100MB + (#rows x #columns) x 0.0016 MB

      Regardless of the memory capacity in the front-end, a process can allocate a maximum of approximately 1.2 gigabytes (GB) in the .NET framework.

      This corresponds to approximately 750,000 data cells that can be displayed.

      The system issues an error message when you try to allocate more memory. In this case, reduce the number of cells to be displayed.

      Regards,

      Raghavendra.

  • avatar image
    Former Member
    Feb 15, 2011 at 07:28 PM

    Hey Everyone,

    I am also running into a similar issue with 7.0 and Excel 2007. I just wanted to comment regarding the 750,000 cell limitation with .NET framework. I'm currently running a query that returns 76,828 rows and 14 total columns (including key and text fields for some attributes) succesfully. It may be possible that our Basis team has changed some setting for us but i don't believe 750,000 is the Maximum.

    ~Troy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Troy,

      Did you ask your Basis team regarding the set up that has been implemented.

      It could be very nice for all of us to get this info.

      Many thanks in advance.

      Kha Luan

  • avatar image
    Former Member
    Aug 09, 2011 at 08:06 PM

    Solved

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2013 at 01:05 AM

    Hi,

    I am also dealing with same issue, anyone got solution to this problem ?.

    Thanks

    Nilesh

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 05, 2013 at 07:31 PM

    Hi Gang,

    See 1040454  - Front-end memory requirement of the BEx Analyzer

    http://service.sap.com/sap/support/notes/1040454

    Regardless of the  memory capacity in the front-end, a process can allocate a maximum of  approximately 1.2 gigabytes (GB) in the .NET framework.
    This corresponds to approximately 750,000 data cells that can be displayed.
    When  you try to allocate more memory, the system generates an error message  ("Client Out of Memory", for example). In this case, reduce the number  of cells to be displayed.

    This is a Microsoft limitation, not an SAP limitation.

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Johny,

      Unfortunately it´s true so thanks for your advice.

      I decided to reduce the volume of data by creating workbook with about ten sheets.

      This workbook is updated after smaller doses but more often and  for my purposes it is sufficient.

      Thanks to all for your help.

      Thomas

  • avatar image
    Former Member
    Jan 14, 2014 at 07:02 AM

    Will SAP or microsoft solve the root cause??

    It's needed to be solved.

    Add comment
    10|10000 characters needed characters exceeded