SAP Note 1002839 - BIA 7.00: Error due to huge resultset of query

Component : TREX BI Accelerator - BW Accelerator

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 :

1315265BWA 7.00: High Memory Issues
1313411BWA 7.00: Revision 50
1283985BIA 7.00: Revision 49
1260249BWA 7.00/7.20: List of Error Codes
1231097BIA 7.00: Revision 48
1157582BIA 7.00: New feature "package wise read"
1018798Reading large data volumes from BI accelerator
883726BIA 7.00: Central Note SAP NetWeaver BI accelerator