Skip to Content
avatar image
Former Member

BW Server Error

Hello Gurus,

when I run the Query and select the free characterstics (e.g Doc Nr.) The query runs for around 30-50 minutes then the either of Error Messages appears "Time Limit Exceeded" or "No roll storage space of lenght 964624 for internal storage table blocks."

Thanks for your Help

Kind Regards

Tariq

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 22, 2010 at 01:49 PM

    if you are running the same out of a cube - try having an aggregate for the fields required....

    If you are running from a DSo - the a secondary index on Document number can be used...

    Else use information broadcasting to sent to OLAP cache and then report out of it... or put the same into a web template and precalculate the same..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 22, 2010 at 08:57 AM

    Hi Tariq,

    It looks like your query is having lot of Characteristics & Keyfigues. So it is taking ot of time to execute.

    Check the query & remove few characteristics or keyfigures which are not required.

    Regards,

    Pavan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Pavan for your Reply,

      Is there other Solution apart from reducing the Key Figures and characterstics?

      Thanks and

      Kind Regards

      Tariq

  • avatar image
    Former Member
    Jun 22, 2010 at 08:29 PM

    it also seems you are running your query for a large amount of data try to create a filter for 1 month and see if it works right or not

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 23, 2010 at 04:55 AM

    Hi,

    See SAP Notes:

    144478 BEx: Termination/Message at 10th/20th drilldown characterstc

    779123 Memory-related terminations at runtime

    99010 Description of the trace tool for RFC links

    Thanks

    Reddy

    Add comment
    10|10000 characters needed characters exceeded