How To Fix RS2HANA_VIEW028 - Please clean up obsolete objects (see long text)

SAP Error Message - Details

• Message type: E = Error

• Message class: RS2HANA_VIEW - HANA Views for BW Objects

• Message number: 028

• Message text: Please clean up obsolete objects (see long text)

What causes this issue?

You have made/changed at least one of the following settings:
Set "Assignment Type" to option 'D' ("Direct Assigment")
Enabled "Limit replication"
Changed the SAP HANA Role name

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?

Because of the changes<(>,<)> some objects that were previously required
are not required anymore. These objects will not be removed
automatically by running the authorization replication. You have to
trigger the clean up process yourself by doing the following:
Go to transaction RS2HANA_GEN.
Choose "Replication" -> "Clean Up" in the menu.
In the dialog that appears, select either "Yes" or "No". If you select
"Yes", make sure that you run the authorization replication for all BW
objects and users once the cleanup process has finished.

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 RS2HANA_VIEW028 - Please clean up obsolete objects (see long text) ?

  The SAP error message RS2HANA_VIEW028 indicates that there are obsolete objects in the system that need to be cleaned up. This typically occurs in the context of SAP BW (Business Warehouse) or SAP BW/4HANA when working with HANA views or data models. The presence of obsolete objects can lead to performance issues, inconsistencies, or errors when trying to execute queries or data loads.
  Cause:
  The error is usually caused by:
  
  Obsolete or Unused Objects: These could be old InfoObjects, InfoProviders, or other data modeling components that are no longer in use but still exist in the system.
  Changes in Data Models: When data models are modified, some objects may become obsolete if they are no longer referenced or needed.
  System Upgrades or Migrations: After an upgrade or migration to a new version of SAP BW or HANA, some objects may not be compatible or necessary anymore.
  
  Solution:
  To resolve the RS2HANA_VIEW028 error, you can follow these steps:
  
  
  Identify Obsolete Objects:
  
  Use transaction codes like RS2HANA_VIEW or RS2HANA to analyze the data models and identify which objects are marked as obsolete.
  Check the long text of the error message for specific details on which objects are causing the issue.
  
  
  
  Clean Up Obsolete Objects:
  
  Once identified, you can delete or deactivate the obsolete objects. This can be done through the Data Warehousing Workbench (transaction RSA1) or directly in the HANA Studio.
  Ensure that you have proper backups and that the objects are indeed not needed before deletion.
  
  
  
  Recheck Data Models:
  
  After cleaning up, recheck your data models and views to ensure that everything is functioning correctly.
  Execute any relevant data loads or queries to confirm that the error has been resolved.
  
  
  
  Documentation and Best Practices:
  
  Document the changes made during the cleanup process for future reference.
  Implement best practices for managing data models and objects to prevent the accumulation of obsolete objects in the future.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional guidance or updates related to this error.
  SAP Community: Engage with the SAP Community forums for insights from other users who may have encountered similar issues.
  System Monitoring: Regularly monitor your SAP BW or HANA system for performance and object management to proactively address potential issues.
  
  By following these steps, you should be able to resolve the RS2HANA_VIEW028 error and maintain a cleaner and more efficient data model environment in your SAP system.