How To Fix RSDRI_HDB059 - Not all requests in the non-cumulative InfoCube are compressed.

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDRI_HDB - InfoCube Conversion Program

• Message number: 059

• Message text: Not all requests in the non-cumulative InfoCube are compressed.

What causes this issue?

After converting a non-cumulative InfoCube, it is no longer possible to
identify requests that contain historical values during compression.
Therefore all requests must be compressed before conversion.

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?

Compress all requests in the non-cumulative InfoCube.

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_HDB059 - Not all requests in the non-cumulative InfoCube are compressed. ?

  The SAP error message RSDRI_HDB059 indicates that not all requests in a non-cumulative InfoCube have been compressed. This typically occurs in the context of SAP BW (Business Warehouse) when dealing with data storage and performance optimization.
  Cause:
  
  Non-Cumulative InfoCubes: Non-cumulative InfoCubes are designed to store data that does not accumulate over time, such as transactional data. They are often used for reporting purposes.
  Compression Issues: The error suggests that there are requests in the InfoCube that have not been compressed. Compression is a process that reduces the size of the data stored in the InfoCube, improving performance and storage efficiency.
  Data Load Failures: If there were issues during data loading processes, it might prevent the requests from being compressed.
  Request Status: The requests may be in a status that does not allow compression, such as being in a "new" or "in process" state.
  
  Solution:
  
  Check Request Status: Verify the status of the requests in the InfoCube. Ensure that they are in a state that allows for compression (e.g., "green" status).
  Manual Compression: You can manually trigger the compression of the InfoCube. This can typically be done through the SAP BW administration transaction (e.g., RSA1) by selecting the InfoCube and choosing the option to compress.
  Data Load Monitoring: Review the data load process to ensure that there are no errors or issues that could prevent requests from being compressed. Check the logs for any failed requests.
  Reprocess Requests: If there are requests that failed to load correctly, consider reprocessing them to ensure they are correctly loaded and can be compressed.
  Check for Locks: Ensure that there are no locks on the InfoCube that might prevent compression from occurring.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might provide additional insights or patches related to this error.
  Documentation: Review SAP BW documentation for best practices on managing InfoCubes, including compression strategies and data load processes.
  Performance Tuning: Regularly monitor and tune the performance of your InfoCubes to prevent similar issues in the future.
  
  If the problem persists after trying the above solutions, it may be beneficial to consult with your SAP Basis or BW team for further investigation or to reach out to SAP support for assistance.