How To Fix RSDRI_HDB060 - Cube will be converted although not all requests are compressed

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDRI_HDB - InfoCube Conversion Program

• Message number: 060

• Message text: Cube will be converted although not all requests are compressed

What causes this issue?

A check was performed to see if conversion was possible; non-compressed
requests were found for a non-cumulative InfoCube. This usually
prevents conversion.
However, this check was disabled by setting the RSADMIN parameter
'FORCE_NCUM_CUBE_CONVERSION' = 'X'.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDRI_HDB060 - Cube will be converted although not all requests are compressed ?

  The SAP error message RSDRI_HDB060 indicates that a data cube in SAP HANA is being converted, but not all requests associated with that cube are compressed. This situation can arise during the process of data modeling or when performing data loads in SAP BW (Business Warehouse) on HANA.
  Cause:
  
  Data Compression: In SAP BW, data is often compressed to optimize storage and improve performance. If some requests (data records) in the cube are not compressed, it can lead to inconsistencies or performance issues during the conversion process.
  Data Load Issues: If there are ongoing data loads or if the data load process was interrupted, it may leave some requests uncompressed.
  Cube Configuration: The cube may have been configured in a way that does not enforce compression for all requests.
  
  Solution:
  
  Check Data Load Status: Ensure that all data loads to the cube have completed successfully. If there are any failed or incomplete loads, resolve those issues first.
  Compress Requests: You can manually trigger the compression of requests in the cube. This can typically be done through the SAP BW administration tools:
  
  Go to the Data Warehousing Workbench (transaction code RSA1).
  Navigate to the InfoProvider (the cube in question).
  Right-click on the cube and select the option to compress requests.
  
  
  Reprocess Requests: If there are specific requests that are not compressed, you may need to reprocess them. This can be done by selecting the requests and choosing the option to reprocess or compress them.
  Check for Locks: Ensure that there are no locks on the cube that might prevent compression. You can check for locks using transaction code SM12.
  Review Cube Settings: Review the settings of the cube to ensure that it is configured correctly for data compression. This may involve checking the settings in the InfoObject or InfoProvider settings.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional guidance on handling compression issues.
  Performance Monitoring: Monitor the performance of the cube after resolving the issue to ensure that it operates efficiently.
  Documentation: Refer to SAP BW documentation for best practices on data loading and compression strategies.
  
  If the issue persists after trying the above solutions, it may be beneficial to consult with SAP support or your internal SAP BW team for further assistance.