Solution : https://service.sap.com/sap/support/notes/1002839 (SAP Service marketplace login required)
Summary :
When executing a query on BIA, users may encounter an "out of memory" error due to preset resultset size limits configured in BIA’s standard configuration. For BIA 7.0 Revision 48 and later, the 'max_cells_one_index' parameter can be set in the TREXIndexServer.ini under the [olap] section, with a default value of 40,000,000 cells. Earlier revisions until BIA 7.0 Revision 47 utilize the 'max_result_size_merge' (default 3,000,000 lines) and 'max_column_number_merge' (default 3 columns) parameters to limit the resultset size. To resolve memory issues, these parameters should be adjusted in TREXIndexServer.ini, ensuring consistency across all BIA blade landscape TREX index servers. After modification, a TREX index server restart is necessary. Additionally, server overload and extended response times can be mitigated by redesigning the queries to manage smaller resultsets.
Key words :
query result set fits, trexindexserver trace file shows, trex configuration file trexindexserver, ini configuration file, trex index server, temporary data structures, longer transport times, abort anytime independend, bia standard configuration, hash table size
Related Notes :
1315265 | BWA 7.00: High Memory Issues |
1313411 | BWA 7.00: Revision 50 |
1283985 | BIA 7.00: Revision 49 |
1260249 | BWA 7.00/7.20: List of Error Codes |
1231097 | BIA 7.00: Revision 48 |
1157582 | BIA 7.00: New feature "package wise read" |
1018798 | Reading large data volumes from BI accelerator |
883726 | BIA 7.00: Central Note SAP NetWeaver BI accelerator |