In this blog post, let’s learn about the error message “25222 version is not a valid schema version.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25222 version is not a valid schema version.
Reason for the Error
A CREATE SCHEMA command created a schema with a value that is not a valid schema version.
Solution
Use a valid schema version value for the CREATE_DEFINITION_SCHEMA_VERSION CQD. For SQL/MX R3.0, these values are valid: 1200 and 3000. Or, allow the system to select the schema version: CONTROL QUERY DEFAULT CREATE_DEFINITION_SCHEMA_VERSION ‘SYSTEM’
