SAP Knowledge Base Article - Public

2334805 - How to override the BW Safety Belt using Lumira

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).

2334805-2.png

Or:

 The query size exceeds the maximum allowed by the BW servers safety belt. Modify the query parameters or contact the BW server Administrator.

 2334805.png

Environment

  • Lumira Desktop 1.31
  • Lumira Server, for BI Platform 1.31

Cause

  • The BW Safety Belt set by the BW Server Administrator has been exceeded.

Resolution

  1. Modify the Lumira SAPLumira.ini file by increasing the maxvizdatasetsize:   -Dhilo.maxvizdatasetsize=<value>
  2. Increase the maximum heap size to 2048 megabytes by setting the Xmx2048m value to 2048 megabytes: -Xmx2048m
  3. For SAP Lumira, server for BI Platform perform the following in Central Management Console (CMC):
    1. Choose Servers
    2. Choose LumiraServer Services
    3. Choose the server
    4. Choose Properties
    5. In the Command Line Parameters, enter the following code snippet:

-DBICS_DA_RESULT_SET_LIMIT_DEF=500000
-DBICS_DA_RESULT_SET_LIMIT_MAX=100000

     4.   For SAP Lumira Desktop add the following parameters to the SAPLumira.ini file:

-DBICS_DA_RESULT_SET_LIMIT_DEF=500000
-DBICS_DA_RESULT_SET_LIMIT_MAX=100000

  • 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.

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 , Problem

Product

SAP Lumira, desktop edition 1.0