Symptom
- When the amount of data exceeds the BW Safety belt, the following errors my be thrown:
Result set too large (XXXXXX cells). Data retrieval restricted by configuration (Maximum=XXXXXX cells).
Or:
The query size exceeds the maximum allowed by the BW servers safety belt. Modify the query parameters or contact the BW server Administrator.
- Lumira Discovery hangs when acquiring data from a BeX query during a document refresh
Environment
- Lumira Desktop 1.31
- Lumira Discovery 2.x
- Lumira Server, for BI Platform 1.31
Cause
- The BW Safety Belt set by the BW Server Administrator has been exceeded.
Resolution
- Modify the Lumira SAPLumira.ini (1.31) or the SAPLumiraDiscovery.ini (2.x) file by increasing the maxvizdatasetsize: -Dhilo.maxvizdatasetsize=<value>
- Increase the maximum heap size to 2048 megabytes by setting the Xmx2048m value to 2048 megabytes: -Xmx2048m
- For SAP Lumira, server for BI Platform perform the following in Central Management Console (CMC):
- Choose Servers
- Choose LumiraServer Services
- Choose the server
- Choose Properties
- In the Command Line Parameters, enter the following code snippet:
-DBICS_DA_RESULT_SET_LIMIT_DEF=500000
-DBICS_DA_RESULT_SET_LIMIT_MAX=1000000
4. For SAP Lumira Desktop and Discovery add the following parameters to the SAPLumira.ini/SAPLumiraDiscovery.ini file respectively:
-DBICS_DA_RESULT_SET_LIMIT_DEF=500000
-DBICS_DA_RESULT_SET_LIMIT_MAX=1000000
- Note 1: This is documented in the SAP Lumira, server for BI Platform User Guide, section 3.6.3 Refreshing a Document Based on SAP Business Warehouse Data Source (p. 16)
- Note 2: This is documented in the SAP Lumira, desktop edition User Guide, section 9.1.2.1 Downloading a BW dataset (p. 184)
- Note 3: Ensure that the MAXIMUM value is always greater than the DEFAULT value.
- Note 4: Overriding the BEX Safety Belt may result in undesired behaviors and other performance issues.
Here's the steps of how to check BW side values for BICS_DA_RESULT_SET_LIMIT_DEF and BICS_DA_RESULT_SET_LIMIT_MAX :
- Connect to your SAP Bussiness Warehouse in SAP GUI
- Start transaction SE16
- Enter table RSADMIN and hit enter
- Select OBJECT BICS_DA_RESULT_SET_LIMIT_DEF to BICS_DA_RESULT_SET_LIMIT_MAX
- Click Execute or hit F8
See Also
Keywords
overide Business warehouse bex increase , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , BI-LUM-SRV , SAP Lumira Server , BI-LUM-OD , SAP Lumira Cloud , BI-LUM-SRV-ADM , Lumira Server BI Platform Admin, Auth, Security , Problem