How To Fix RSRV078 - Aggregates deleted from InfoCube &1

SAP Error Message - Details

• Message type: E = Error

• Message class: RSRV -

• Message number: 078

• Message text: Aggregates deleted from InfoCube &1

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRV078 - Aggregates deleted from InfoCube &1 ?

  The SAP error message RSRV078 indicates that aggregates have been deleted from an InfoCube. This typically occurs during the process of data modeling or when performing maintenance tasks in the SAP BW (Business Warehouse) environment. Here’s a breakdown of the cause, potential solutions, and related information:
  Cause:
  
  Manual Deletion: Aggregates may have been manually deleted by a user or during a maintenance task.
  Data Model Changes: Changes in the data model, such as modifications to the InfoCube or its characteristics, can lead to the automatic deletion of aggregates.
  Transport Issues: If changes are transported from one system to another, aggregates may not be properly transported, leading to their deletion.
  System Cleanup: Regular system cleanup processes may inadvertently remove aggregates that are no longer deemed necessary.
  
  Solution:
  
  
  Recreate Aggregates: The most straightforward solution is to recreate the aggregates. This can be done through the SAP BW administration tools:
  
  Go to the InfoCube in the Data Warehousing Workbench.
  Select the aggregates that need to be recreated.
  Use the "Manage Aggregates" option to rebuild them.
  
  
  
  Check for Dependencies: Before recreating aggregates, check if there are any dependencies or changes in the InfoCube that need to be addressed to prevent future issues.
  
  
  Review Change Logs: Look at the change logs to identify what changes were made prior to the deletion of aggregates. This can help in understanding the root cause and preventing it from happening again.
  
  
  Transport Management: Ensure that all necessary objects are included in transport requests when moving changes between systems to avoid missing aggregates.
  
  
  System Monitoring: Implement monitoring for your BW system to catch issues early. Regularly check the status of aggregates and InfoCubes.
  
  
  Related Information:
  
  Transaction RSRV: You can use transaction RSRV to check the consistency of your InfoCubes and aggregates. This transaction provides various checks and can help identify issues.
  SAP Notes: Check for relevant SAP Notes that may address specific issues related to aggregates and InfoCubes. SAP Notes often provide patches or additional guidance.
  Documentation: Review SAP BW documentation for best practices on managing aggregates and InfoCubes to ensure optimal performance and data integrity.
  
  By following these steps, you should be able to resolve the RSRV078 error and prevent it from occurring in the future.