HPE NonStop SQL/MX Error – 6002 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS contains invalid values. If you have manually modified the metadata table, then you should undo your changes using the CLEAR option in UPDATE STATISTICS.

In this blog post, let’s learn about the error message “6002 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS contains invalid values. If you have manually modified the metadata table, then you should undo your changes using the CLEAR option in UPDATE STATISTICS.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

6002 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS contains invalid values. If you have manually modified the metadata table, then you should undo your changes using the CLEAR option in UPDATE STATISTICS.

Reason for the Error

You have manually modified the metadata table, and now it contains invalid values.

Solution

Undo your changes using the CLEAR option in UPDATE STATISTICS