Solution : https://service.sap.com/sap/support/notes/1614788 (SAP Service marketplace login required)
Summary :
SAP Note addresses issues with large hierarchies in BW reporting that exhaust buffer memory, leading to errors or dumps like EXPORT_BUFFER_NO_MEMORY. The default handling involves buffering all hierarchies in shared buffers, which can be inadequate for ones exceeding 100,000 nodes. To remedy, increase the rsdb/obj_buffersize parameter, leverage the RSADMIN parameter RSR_HIER_THRESHOLD_EXPORTDB for database buffering of large hierarchies, and optionally suppress unassigned nodes to reduce hierarchy size. Detailed node count can be determined via transaction RSH1 and needs consideration for buffer size adjustments to minimize swap occurrences and ensure memory allocation efficiency.
Key words :
short dump export_buffer_no_memory occurs, instance parameter rsdb/obj_buffersize, sap netweaver bw 7, suppress 'unassigned' node, 00 bw abap sp28, 01 bw abap sp11, 02 bw abap sp10, 30 bw abap sp05, good system performance, sap nw bw 7
Related Notes :
| 1606526 | SAPBWNews NW BW 7.30 ABAP SP5 |
| 1510977 | Prelimenary Version SAPBWNews NW BW 7.11 ABAP SP08 |
| 738098 | Performance problems with hierarchies |
| 520684 | Runtime error "EXPORT_BUFFER_NO_MEMORY" |
| 156957 | OLAP: Message 051(BRAIN) when executing a query |