Kbase P41604: Error 7872 when granting dba privileges with SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/1/2004 |
|
Status: Verified
FACT(s) (Environment):
Windows 2000
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Error 7872 when granting dba privileges with SQL-92
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210017
[JDBC Progress Driver]:Failure to acquire exclusive schema lock for DDL operation. (7872)
CAUSE:
This behavior can occur due to the following conditions:
1) Another user is connected to the database and this user has an open transaction
2) When a client is connected that maintains a schema lock of some kind, e.g. the Progress Data Dictionary.
If a user is running a transaction, this means that the tables will be locked that are accessed in that transaction. So although the user might not be directly manipulating the table definitions etc., it does mean that schema updates to the database can't be carried out. This is to prevent, for example, table definitions being changed while a user is actually working with records from a table.
FIX:
Check what users are connected and what they are running at the same time as you are trying to grant the dba privileges. The users can remain connected (unless they are running the Data Dictionary, for example), but the GRANT will need to be done when the transaction is finished.