Hi Community,
I am struggling with BW Import failures and hitting the error message "Result set is too large, data retrieval restricted by configuration.
We are running on tenant version 2020.8.11, which is the 2020.Q2 release. In this release the BW Import restriction is meant to have changed from 800K records to 100 million cells.
Our BICS_DA_RESULT_SET_LIMIT_DEF and MAX (Safety Belt) are both set to 5 million,
My query is 23 columns (I am counting DISPLAY_KEY, TEXT variations as individual columns).
A query with 500K returned rows runs successfully - by my calculations this is 11.5 million cells.
A query with 750K returned rows fails with the "Result set is too large ...." error message - by my calculations this is 17.25 million cells.
So, I am not hitting an 800K row limit. I am not hitting a 100 million cell limit. But I also have a successfully running query which seems to go beyond the Safety Belt.
As a one-off we increased the Safety Belt to 10 million cells, but the 750K row query still fails.
So we are a bit confused as to what, if anything, the Safety Belt does and also what might be causing the larger query to fail. We are wondering if it could be Tomcat for example. If anyone has any experience with this then I would appreciate feedback.
Many thanks.