Consultor Eletrônico

SUMMARY:

This solution applies to Progress SonicMQ Versions 2000.x and 3.x. It
discusses the process_install.log file which can be used to verify the
success of database creation and initialization during installation,
and to help diagnose problems which may be encountered when starting
the SonicMQ broker immediately after installation.

EXPLANATION:

When the SonicMQ broker's database is initialized during installation,
output is sent to the file process_install.log, located in the SonicMQ
installation directory. If this process is successful, the creation
of each database table and index, and the initialization of the
recovery log is recorded in this file. For example:

Creating table BrokerDBVer.
Creating table MessageInfo.
Creating index MsgInfoIdx.
Creating table Messages.
Creating index MsgIdx.
Creating table UserIdMapping.
Creating index UidIdx.
Creating table Subscriptions.
Creating index SubIdx.
Creating table UndelMsgs.
Creating index UnDlMsgIdx.
Creating index UnDlMsgIx2.
Creating table QMessages.
Creating index QMsgIdx.
Creating table PreparedTxns.
Creating table TxnMessages.
Creating table SyncPoint.
Creating table BrokerMode.
Creating table PBMsgInfo.
Creating index PBMsgInfoIdx.
Creating table PBMsgs.
Creating index PBMsgIdx.
Creating table CbrSubs.
Creating index CBRSubIdx.
Creating table MFR.
Creating index MfrIdx.
Setting security mode
Setting sync point
Creating table LogTime.
Creating table BrokerInfo.
Creating table QueueRegistry.
Setting log time
Initializing broker recovery log files...
Broker Database initialization is complete.

InitBrokerDatabase terminates.
Success

If database creation and initialization are not successful, the broker
will fail on startup with an exceptions such as:

SQLException(SQLState=42X05, errorCode=20000):
Table [tablename] does not exist.
[146] progress.message.broker.EStartupFailure: Problem with database:
[2002] progress.message.db.EDatabaseException: SQL Exception:
Table [tablename] does not exist.


References to Written Documentation:

SonicMQ Installation and Administration Guide, Ch. 1, Installation,
"Installation of the Broker"

Progress Knowledge Base Solution 19767:
"Table Does Not Exist" Starting SonicMQ Broker on Solaris