Kbase 21733: DB Parameter Required When Using Progress DB with SonicMQ
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/31/2002 |
|
SUMMARY:
This Solution applies to SonicMQ version 4.0.
You might get the error, "Exceeding permissible number of connections", when using SonicMQ 4.0 with a Progress Database (9.1C14 and later).
EXPLANATION:
The SonicMQ Broker requires seven Progress SQL-92 Servers (_sqlsrv2) in order to be started correctly. If the Progress Broker does not have enough Servers to serve the SonicMQ Broker, the following exceptions will be generated and the SonicMQ Broker will not start:
java.sql.SQLException: [JDBC Progress Driver]:Exceeding permissible number of connections
at com.progress.sql.jdbc.JdbcProgress.createSQLException(JdbcProgress.ja
va:6501)
at com.progress.sql.jdbc.JdbcProgress.standardError(JdbcProgress.java:66
75)
at com.progress.sql.jdbc.JdbcProgress.SQLDriverConnect(JdbcProgress.java
:2685)
at com.progress.sql.jdbc.JdbcProgressConnection.initialize(JdbcProgressC
onnection.java:340)
at com.progress.sql.jdbc.JdbcProgressDriver.connect(JdbcProgressDriver.j
ava:168)
at java.sql.DriverManager.getConnection(DriverManager.java:523)
at java.sql.DriverManager.getConnection(DriverManager.java:152)
at progress.message.db.Database.vR_(:1577)
at progress.message.db.Database.<init>(:275)
at progress.message.db.Database.<init>(:77)
at progress.message.broker.BrokerDatabase.<init>(:373)
at progress.message.broker.AgentRegistrar.<init>(:366)
at progress.message.broker.Broker.<init>(:347)
at progress.message.broker.Broker.main(:243)
SQLException(SQLState=HY000, errorCode=-20225): [JDBC Progress Driver]:Exceeding
permissible number of connections
[146] progress.message.broker.EStartupFailure: Problem with database: [2002] pro
gress.message.db.EDatabaseException: java.sql.SQLException: [JDBC Progress Drive
r]:Exceeding permissible number of connections
SOLUTION:
Before starting the SonicMQ Broker, start the Progress Database Broker, specifying the -Mn (Maximum Servers) parameter at 7 or more. For example:
proenv> PROSERVE <progressDB> -S <port> -Mn 7
References to Written Documentation:
Progress Knowledge Base Solution 21681, "Configuring SonicMQ To Use Progress DB As A Message Store"