How To Fix RSRV112 - Mehrfache Einträge in einer Dimension eines InfoCubes

SAP Error Message - Details

• Message type: E = Error

• Message class: RSRV -

• Message number: 112

• Message text: Mehrfache Einträge in einer Dimension eines InfoCubes

Description
This elementary test recognizes whether there are several lines that
have different <SE><AB>DIMID</></>s(dimension table key), but have the
same <AB>SID</>s for the selected dimension table for the InfoCube
specified. (This can occur by using parallel loading jobs). This has
nothing to do with an inconsistency. However, unnecessary storage space
is occupied in the database.

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Repairs
Since the different <EX>DIMID</>s with the same SIDs are normally used
in the fact tables, they cannot simply be deleted. Therefore, all of
the different DIMIDS in the fact tables are replaced by one DIMID that
is randomly selected from the equivalent ones. Before a change can be
made to the database, the consent of the user is requested.
<EX>DIMID</>s that have become unnecessary are deleted in the
connection. In doing so, not only are the <EX>DIMD</>s deleted that
were released in the first part of the repair, but so are all of those
that are no longer used in the fact tables (including aggregates). The
consent of the user is again requested before this change is made.

Wie behebe ich diesen Fehler?

Vorgehensweise für Systemadministratoren

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE