How To Fix RS_DB_DB6602 - Aggregate &1: F and E fact tables in different database partition groups

RS_DB_DB6602 - Overview

• Message type: E = Error

• Message class: RS_DB_DB6 - DB6-Specific Messages in SAP BW

• Message number: 602

• Message text: Aggregate &1: F and E fact tables in different database partition groups

What causes this issue?

The F and E fact tables of an InfoCube aggregate must be in the same
database partition group; otherwise you will experience considerable
performance issues.

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?

Report an incident on component BW-SYS-DB-DB6.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

RS_DB_DB6602 - Details

• The SAP error message RS_DB_DB6602 indicates that there is a mismatch between the fact tables (F and E) of an aggregate in different database partition groups. This typically occurs in the context of SAP BW (Business Warehouse) when dealing with aggregates and their underlying fact tables.
  
  Cause:
  The error arises when the fact tables that are part of an aggregate are stored in different database partition groups. In SAP BW, aggregates are used to improve query performance by pre-calculating and storing summarized data. However, for an aggregate to function correctly, all the fact tables that contribute to it must reside in the same database partition group. If they are in different groups, the system cannot access them simultaneously, leading to this error.
  
  Solution:
  To resolve the RS_DB_DB6602 error, you can follow these steps:
  
  
  Check Database Partition Groups:
  
  Identify the database partition groups for the fact tables involved in the aggregate. You can do this by checking