Hi,
I have two independent IS (8.0) on the same box for which I wanted to enable clustering. I enabled clustering on one of the servers and restarted the server. But the server is not coming up and throwing the below error:
It gives a database error, but the database is up and connected. Please let me know if you have any inputs
java.sql.SQLException: Failed to start database ‘AUDITINGSC’, see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection40.(Unknown Source)
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at com.webMethods.lwq.util.DBPool.createNewConnections(DBPool.java:129)
at com.webMethods.lwq.util.DBPool.(DBPool.java:58)
at com.webMethods.lwq.util.DBPool.getInstance(DBPool.java:98)
at com.webMethods.lwq.db.DBAccessObject.getAutoCommitConnection(DBAccessObject.java:102)
at com.webMethods.lwq.db.DBAccessObject.getAllMessageStoreIds(DBAccessObject.java:69)
at com.webMethods.lwq.management.LwqAdmin.getGuaranteedQueueNames(LwqAdmin.java:437)
at com.webMethods.sc.auditing.queue.WmBaseAuditQueue.detectOrphanedQueues(WmBaseAuditQueue.java:81)
at com.webMethods.sc.auditing.WmAuditingImpl.configure(WmAuditingImpl.java:165)
at com.webMethods.sc.auditing.WmAuditingImpl.configure(WmAuditingImpl.java:96)
at com.wm.app.b2b.server.AuditLogManager.init(AuditLogManager.java:540)
at com.wm.app.b2b.server.Server.run(Server.java:378)
Caused by: java.sql.SQLException: Failed to start database ‘AUDITINGSC’, see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
… 25 more
2010-07-20 17:35:24 GMT [Error.DB.onnectionE] Could not obtain a DB connection.
2010-07-20 17:35:24 GMT [Error.DB.onnectionE] Could not obtain a DB connection.
The AUDITINGSC Derby database is used by audit loggers that are configured to do guaranteed asynchronous logging. Although an external database is required for clustering, guaranteed async loggers will use the embedded Derby database as an internal queueing mechanism regardless of whether IS is clustered or not.
If you do not have any in-flight audit log records, you can clear this problem by deleting the IntegrationServer/db/AUDITINGSC directory. You may need to shut down IS to do this. The database will get recreated when the server starts up.
Please note that the guaranteed asynchronous option is, in most cases, the slowest one for audit logging. Synchronous logging is usually the fastest.
The reverse sequencing of ISs did not resolve the problem. Hence I deleted the entire folder /db/AUDITINGSC and restarted IS.
Below logs are seen
2012-11-02 12:58:16 MDT [ISS.0025.0012I] Cache Manager started
2012-11-02 12:58:17 MDT [Error.DBMessageStore.nitializationE] Failed to initialize DB message store.
2012-11-02 12:58:18 MDT [BAS.0123.0001I] FSData full consistency check is being performed. Db:DocumentStore/ISTransStore
2012-11-02 12:58:20 MDT [ISS.0098.0026I] Document Store DefaultStore initialized
2012-11-02 12:58:20 MDT [Error.DB.onnectionE] Message not found for messageKey Error.DB.Connection
2012-11-02 12:58:20 MDT [ISS.0025.9998C] Exception → com.wm.app.b2b.server.dispatcher.exceptions.PersistenceException: com.wm.app.store.TSException: [BAT.0002.0000] Wrapped Exception: com.webMethods.lwq.LwqException: Failed to start database ‘LWQ_DB_BROKER_CSQ’, see the next exception for details.
2012-11-02 12:58:20 MDT [ISS.0098.0045E] Unrecoverable Exception while initializing the Dispatcher: com.wm.app.b2b.server.dispatcher.exceptions.CommException: [ISS.0098.9018] Unrecoverable Error while initializing Dispatcher: com.wm.app.store.TSException: [BAT.0002.0000] Wrapped Exception: com.webMethods.lwq.LwqException: Failed to start database ‘LWQ_DB_BROKER_CSQ’, see the next exception for details.
2012-11-02 12:58:20 MDT [Error.DBMessageStore.nitializationE] Failed to initialize DB message store.
2012-11-02 12:58:21 MDT [Error.DB.onnectionE] Message not found for messageKey Error.DB.Connection
2012-11-02 12:58:21 MDT [ISS.0134.0015E] Unable to load configuration for JMS connection alias “0”: com.webMethods.lwq.LwqException: Failed to start database ‘LWQ_DB’, see the next exception for details.
2012-11-02 12:58:21 MDT [Error.DB.onnectionE] Message not found for messageKey Error.DB.Connection
2012-11-02 12:58:21 MDT [ISS.0134.0015E] Unable to load configuration for JMS connection alias “1”: com.webMethods.lwq.LwqException: Failed to start database ‘LWQ_DB’, see the next exception for details.
I got this error for the first time. Later I restarted and the errors disappeared and IS started ormally.