How To Fix RSCV588 - DB2/UDB : l'index primaire suppléant &1 n'est pas unique.

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 588

• Message text: DB2/UDB : l'index primaire suppléant &1 n'est pas unique.

Quelle est la cause de ce problème?

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.

Réponse du système

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.

Comment corriger cette erreur?

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.

Extrait du message d'erreur du système SAP. Copyright SAP SE.