How To Fix DBMAN763 - No compression, ref-point update version 2 is not active for InfoCube &1

SAP Error Message - Details

• Message type: E = Error

• Message class: DBMAN - Data Manager Message Class

• Message number: 763

• Message text: No compression, ref-point update version 2 is not active for InfoCube &1

What causes this issue?

The handling of compressed records in flat inventory cubes is different
from classic Star Schema InfoCubes. Due to a program error, flat
inventory cubes in BW (based on DB2 for IBM i) were compressed using the
wrong method.

System Response

The compression of flat inventory cubes in BW (based on DB2 for IBM i)
was corrected and now uses the newest method "Reference-point update
version 2".
In order to avoid creating inconsistent data, flat inventory cubes,
which contain records compressed by the old method, cannot be compressed
anymore.

How to fix this error?

When compression starts, BW checks whether the InfoCube is using the
correct method. If this is not the case, it automatically converts the
data of the InfoCube before it continues to compress new requests.
This automated conversion could not be performed. The InfoCube has not
been converted to the correct compression method and therefore it cannot
be compressed.
If you have switched off automated conversion during compression via
RSADMIN parameter RSCDS_NO_CONVERT_TO_REFP_UPD2 = X (not recommended),
then use report RSDD_SWITCH_NCUM_HANDLING_DB4 to convert the InfoCube.
If another problem prevented a successful conversion, check the
application log of the compression or contact SAP support to help find
the cause of the error.
For more information about incorrect compression of flat inventory cubes
on DB2 for IBM i, see SAP Note 2367703 - IBM i: Condensing flat
InfoCubes: Wrong Ncum-Handling and other corrections.
For more information about inventory InfoCubes in general, see SAP Note
1548125 - Interesting facts about Inventory Cubes.

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DBMAN763 - No compression, ref-point update version 2 is not active for InfoCube &1 ?

  The SAP error message DBMAN763 indicates that there is an issue with the compression of data in an InfoCube. Specifically, it states that "No compression, ref-point update version 2 is not active for InfoCube &1." This error typically arises when you attempt to perform a compression operation on an InfoCube that does not have the necessary reference point update version activated.
  Cause:
  
  Reference Point Update Version: The error suggests that the reference point update version 2 is not active for the specified InfoCube. This version is required for the compression process to proceed.
  Data State: The InfoCube may contain data that is not in a state suitable for compression, or there may be inconsistencies in the data.
  Configuration Issues: There may be configuration issues in the InfoCube settings or the data model that prevent the compression from being executed.
  
  Solution:
  
  
  Activate Reference Point Update Version:
  
  Go to the Data Warehousing Workbench (transaction code RSA1).
  Navigate to the InfoCube in question.
  Check the settings for the InfoCube and ensure that the reference point update version 2 is activated.
  If it is not active, activate it and try the compression process again.
  
  
  
  Check Data Consistency:
  
  Ensure that the data in the InfoCube is consistent and that there are no errors in the data load process.
  You can use transaction codes like RSA3 to check the data in the InfoCube.
  
  
  
  Review Compression Settings:
  
  Check the compression settings for the InfoCube. Ensure that the settings are correctly configured to allow for compression.
  You can review the settings in the InfoCube properties.
  
  
  
  Perform a Manual Compression:
  
  If the automatic compression fails, you can try to perform a manual compression using transaction code RSCONN01 or RSCOMPR to see if it provides more detailed error messages.
  
  
  
  Consult SAP Notes:
  
  Check the SAP Support Portal for any relevant SAP Notes that may address this specific error message or provide additional troubleshooting steps.
  
  
  
  Related Information:
  
  InfoCube: An InfoCube is a multidimensional data structure that is used to store data in the SAP BW (Business Warehouse) system.
  Compression: Compression in SAP BW is a process that reduces the size of the data stored in an InfoCube by aggregating and summarizing data.
  Data Warehousing Workbench: This is the primary tool used for modeling and managing data in SAP BW.
  
  If the issue persists after following these steps, it may be beneficial to consult with your SAP Basis or BW team for further investigation, as they may have access to additional tools and logs that can help diagnose the problem.