In this blog post, let’s learn about the error message “6003 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS contains invalid boundary value value for column name. If you have manually modified the metadata table, you should undo your changes using the CLEAR option in UPDATE STATISTICS and regenerate the statistics.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
6003 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS contains invalid boundary value value for column name. If you have manually modified the metadata table, you should undo your changes using the CLEAR option in UPDATE STATISTICS and regenerate the statistics.
Reason for the Error
You have manually modified the metadata table, and now it contains an invalid boundary value.
Solution
Undo your changes using the CLEAR option in UPDATE STATISTICS and regenerate the statistics
