In this blog post, let’s learn about the error message “1262 The command cannot be executed because operation is in progress for schema.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1262 The command cannot be executed because operation is in progress for schema.
Reason for the Error
You attempted a DDL or utility operation on a database object while a schema-level operation was in progress for that object’s schema or a previously attempted DDL or utility operation had failed.
Solution
Wait until the operation has finished, and then retry the DDL or utility operation.
For a failed schema level operation, run RECOVER SCHEMA with RESUME or CANCEL option to complete or cancel the failed schema level operation and retry the DDL or utility operation
