In this blog post, let’s learn about the error message “25250 Schema schema cannot be downgraded; object_type object has object feature version OFV.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25250 Schema schema cannot be downgraded; object_type object has object feature version OFV.
Reason for the Error
A DOWNGRADE operation affects a schema containing one or more objects that use features that are not supported in the target version.
Solution
Use the FEATURE_VERSION_INFO built-in function to obtain the objects names. Drop the affected objects or alter them so that they no longer have features that are not supported in the target version
