Kbase P103145: Unable to grant privileges to users with database started using Progress Fathom Mgt.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/04/2005 |
|
Status: Unverified
FACT(s) (Environment):
Windows 32 Intel
Progress 9.1x
SYMPTOM(s):
Trying to grant dba privileges to a newly created SQL-92 user
Failure to acquire exclusive schema lock for DDL operation. (7872)
SQLState=HY000
ErrorCode=-210017
[JDBC Progress Driver]:Failure to acquire exclusive schema lock for DDL operation. (7872)
Using Progress SQL Explorer Tool to add new users to database
Database started using Progress Fathom Management product.
CAUSE:
The database was started using Fathom Management. To add, delete or modify a users record there cannot be any transactions active on the database because a schema lock is taken out on the entire schema while the operation is performed. Fathom Management is controlling the database. It has a connection via its agent and is actively collecting data. This is an active transaction against the database and is not permitted during a SQL grant procedure.
FIX:
To permit SQL Explorer Tool to grant privileges to a new user, follow the steps below;
1. Shutdown Fathom Management.
2. Start the database in multi-user mode (proserve sports2000 -H hostname -S port #)
3. Connect to the database with SQL Explorer using same port number used to start the database.