Dear Developer
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?
Hi,
Looking at the error it seems like some issue with memory space, why don't you check with your basis team or BIA Admin team for more information?
Regards,
Durgesh.
Hello,
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
Cheers
Tansu