WARNING BRAIN (230):Could not buffer query structures.

[Former Member]

Hi

We are trying to run a OOTB report and we are getting redirected to Bex but we are getting the following error in the UI

Unknown Error: [object Object].

com.sap.bi.base.application.exceptions.AbortMessageRun

timeException: Termination message sent

WARNING BRAIN (230):Could not buffer query structures.

Buffer too small

Could you please suggest how to proceed further on this?

Regards

Neel

[Former Member · Accepted solution]

Hi Neel,

As the message indicates the query you are trying to execute is too large. You might have to request your basis team to add more memory for this report execution.

Secondly of this reason we do not recommend anybody to run the SPM - Spend Analysis Final query as is, because we have a whole bunch of dimensions & measures in the query. If you have a lot of data in your system then the system would need quite a bit of resources to run this query.

I would request your basis team to look into the query cache parameters (Global & Local cache size) and see if they can be increased. Also check query caching persistence mode and see what works best.

Regards,

Rohit

[Former Member]

Hi Rohit

Thank you

Regards

Neel