I came across error when I execute query.
The content is same as below.
Error reading the data of InfoProvider ZSD_C03$X
The following error 2,703 occurred in BIA server
Error executing physical plan:aggregation: not enough memory for executi
Error executing physical plan:aggregation:not en 2703
The following errors occurred duting parallel processing of query 1
Error reading the data of InfoProvider ZSD_C21$X
Amount of data to be read from the BIA server is too large
The following error 6952 occurred in BIA server
Error executing physical plan:AttributeEngine: not enough memory:BwPopAg
Error executing physical plan:AttributeEngine: no 6952
The following errors occurred during parallel processing of query 7
Errors occurred during parallel processing of query 1, RC: 3
Error while reading data; navigation is possible
I detected SAP note '1002839'.
I'm going to change the value of 'max_cells_one_index'.
To determine value of 'max_cells_one_index', I realize that I have to know hash table size and key figures.
Becasue notes mentions that 'max_cells_one_index' = hash table size * key figures.
However, I have no idea what hash table size means.
Can I find it in file 'TrexIndexServerAlert.trc'
Is there another way?
You are trying to transfer a result set to OLAP that bigger than the parameter in max_cells_one_index.
I don't know what BWA version you have but, the number was 40M, you can find it in TREXIndexServer.ini file.
I am not sure how you can calculate but this depends on how many columns in your query not only rows - including hidden KFs
If you change it, you need to restart the trex index server. But I don't recommend changing this parameter.If you raise this number you may run out of memory that may bring down the entire blade, not only one query. So I recommend you to redesign the failing query only