DB2/UDB: The MDC columns of table &1 are not correct
Message type: E = Error
Message class: RSCV - Analysis of BW objects (InfoCubes...)
Message number: 594
Message text: DB2/UDB: The MDC columns of table &1 are not correct
The system issues an error message and will not allow you to continue with this transaction until the error is resolved.
What causes this issue?
An error occurred during activation of table &V1&.
System Response
In general, clustering improves the performance of read access to a
table. Two types of clustering are supported: you can select index
clusters in InfoCube maintenance under <ZK>Extras </>-> <ZK>DB
Performance</> -> <ZK>Clustering .</>
The current clustering of the database table is <ZK>Multidimensional
Clustering</> and the number/selection of MDC columns is not correct.
How to fix this error?
Activate the InfoCube again and check whether errors occurred during
activation.
If the InfoCube already contains data and you want to change the
clustering, you have to use reclustering. You can find this function in
InfoCube maintenance under <LS>More Functions -> Reclustering</> or in
the Data Warehousing Workbench in the function area <LS>Administration
-> Reclustering</>.
Error message extract from SAP system. Copyright SAP SE.