In this blog post, let’s learn about the error message “25221: Schema schema cannot be created with version version1 because its catalog already contains schemas with version version2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25221: Schema schema cannot be created with version version1 because its catalog already contains schemas with version version2.
Reason for the Error
The CREATE_DEFINITION_SCHEMA_VERSION CQD is set to a schema version that is different from the schema version of existing schemas in the affected catalog.
Solution
Allow the system to select the schema version for the new schema: CONTROL QUERY DEFAULT CREATE_DEFINITION_SCHEMA_VERSION ‘SYSTEM