In this blog post, let’s learn about the error message “20521 Object object cannot participate in refresh; a process 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
20521 Object object cannot participate in refresh; a process associated with a DDL lock on it is currently running.
Reason for the Error
Object object has a DDL lock on it by another concurrent refresh utility execution.
Solution
After the concurrent operation that holds the DDL lock finishes, run refresh again. If no concurrent operations are running, the DDL lock must be removed. Contact your service provider to remove the lock
