Kbase P144271: Failure to acquire exclusive schema lock for DDL operation error when alter to alter a table with re
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/17/2009 |
|
Status: Unverified
SYMPTOM(s):
Failure to acquire exclusive schema lock for DDL operation. (7872)
Error attempting alter table
No users actively connected to the database
Rpserver process is running
Unable to apply schema change to an OpenEdge Replication enabled database
Connection failure for host <targetmachine> port <port#> transport TCP.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge Replication 10.x
CAUSE:
The rpserver process is running but is not communicating with the rpagent. The process must be actively in synchronization with the target or shut down.
FIX:
Either restart the target db or stop the the rpserver process using:
dsrutil dbname -C terminate server
Once the rpserver is down or communicating with the target, apply the schema changes, and restart the rpserver process using:
dsrutil dbname -C restart server