Kbase P36240: Unable to connect via sql92 error 5291.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/09/2004 |
|
Status: Unverified
FACT(s) (Environment):
Solaris SPARC 9
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
connecting using SQL getting error (5291)
You have attempted to connect to a database with too many users connected to it. Retry the connection later, or increase -n on the server. (5291)
Have multiple brokers
When running scirpt for SQL permissions getting: Failure to acquire exclusive schema lock for DDL operation. (7872).
CAUSE:
Trying to change SQL access permissions / rights on an active database and were unable to get an exclusive schema lock.
FIX:
Run schema updates when database is not available to other users.