Kbase 19715: SonicMQ: Hyphens Disallowed in Broker Name
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/08/2001 |
|
SUMMARY:
This solution applies to Progress SonicMQ Version 2000.x. It explains
why the hyphen character "-" cannot be used in a broker name.
EXPLANATION:
The broker name is specified during installation. It can be changed
after installation by modifying the BROKER_NAME property in the file
broker.ini and then reinitializing the broker database with dbtool.
If the hyphen appears in the broker name, the broker will not start.
Attempts to start the broker will result in the following error:
SQLException(SQLState=42X01, errorCode=20000): Syntax error:
Encountered "-" at line 1, column 75.
[146] progress.message.broker.EStartupFailure: Problem with
database:
[2002] progress.message.db.EDatabaseException: SQL Exception:
Syntax error: Encountered "-" at line 1, column 75.
Attempts to use dbtool to recreate the database tables (dbtool /r)
when the BROKER_NAME property in broker.ini contains a hyphen
results in the following error:
SQLException(SQLState=42X01, errorCode=20000): Syntax error:
Encountered "-" at line 1, column 21.
These errors occur because the hyphen is invalid in SQL syntax, except
as a minus sign.
Although using dbtool to delete the database tables (dbtool /d)
appears to complete successfully, subsequent attempts to use dbtool to
create the tables (dbtool /c) again are unsuccessful. Dbtool displays the following message:
"Cannot create new database tables; Tables for broker <BROKER NAME>
already exist"
SOLUTION:
Remove the hyphen from BROKER_NAME and then reinitialize (recreate, or
delete and create) the tables with dbtool.
References To Written Documentation:
SonicMQ Installation and Administration Guide, Installation of the Broker section.