How To Fix RSCV588 - DB2/UDB: Der stellvertretende Primärindex &1 ist nicht unique.

SAP Error Message - Details

• Message type: E = Error

• Message class: RSCV - Analysis of BW objects (InfoCubes...)

• Message number: 588

• Message text: DB2/UDB: Der stellvertretende Primärindex &1 ist nicht unique.

Was verursacht dieses Problem?

Index &V1& is not unique as required.
A possible cause is the availability of data records with the same key
values in fact table &V2& for the time of the creation of the index.

Systemantwort

Data records having the same key values after compression or after
rolling-up data is an inconsistency of data. This can lead to incorrect
reporting.

Wie behebe ich diesen Fehler?

Check whether duplicate data records occur in the table and delete
these. Proceed as described in SAP Note 481450.
If duplicate data records no longer occur in the table, you can correct
the index in which you execute the action "Repair Indexes (Now)". You
can also activate the InfoCube in the background processing in
transaction RSDCUBE in "InfoCube Utilities" (recommended for very large
fact tables and when the timeout for foreground actions is exceeded
with "Repair Indexes (Now)".
Note that index &V1& needs to be deleted and recreated with each
repair. With large fact tables, this can lead to long run times. If
duplicate data records still occur in the table, the index is recreated
as not being unique.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE