In this blog post, let’s learn about the error message “25262 Cannot perform operation because metadata table table is referenced by view view.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25262 Cannot perform operation because metadata table table is referenced by view view.
Reason for the Error
The named user view references a metadata table that will be dropped as a result of the UPGRADE or DOWNGRADE command.
Solution
Remove the offending relationship and then reissue the UPGRADE or DOWNGRADE operation. It is advisable to save the view text so that the view can be recreated after the UPGRADE or DOWNGRADE operation
