In this blog post, let’s learn about the error message “20520 Object object cannot participate in refresh; a utility operation associated with a DDL lock on it is currently running.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20520 Object object cannot participate in refresh; a utility operation associated with a DDL lock on it is currently running.
Reason for the Error
Object object has a DDL lock on it.
Solution
After the concurrent operation that holds the DDL lock finishes, rerun refresh again. If no concurrent operations are running, the DDL lock must be removed. Contact your service provider to remove the lock