IBM Support

java.sql.SQLException with SQL State XJ040 Error Code 40000 starting a Derby database

Troubleshooting


Problem

You notice the following exception when trying to create a database table in a Derby database: java.sql.SQLException: Failed to start database '/dataconv/IBM/WebSphere/AppServer/profiles/dataconvdev/databases/EJBTimers/server1/EJBTimerDB' with an accompanying DSRA0010E: SQL State = XJ040, Error Code = 40,000 and a root exception similar to this one SQL Exception: Page Page(18,Container(0, 848)) is at version 6,298, the log file contains change version 7,612, either there are log records of this page missing, or this page did not get written out to disk properly. This latter SQLException indicates that a problem occurred writing records out to the database.

Symptom

When trying to create a database table in a Derby database, the following errors are logged.
[11/15/07 8:50:05:709 PST] 00000014 EJBContainerI E WSVR0040E:
addEjbModule failed for processors.jar
[class com.ibm.ws.runtime.component.DeployedEJBModuleImpl]
com.ibm.websphere.csi.EJBContainerException: EJB Timer Service not started
at com.ibm.ws.runtime.component.EJBContainerImpl.getSchedulerInstance (EJBContainerImpl.java:2394)
...
Caused by:
com.ibm.ws.scheduler.exception.SchedulerDataStoreException:
com.ibm.ws.extensionhelper.exception.UnableToInitializeException:
java.sql.SQLException: Failed to start database
'/dataconv/IBM/WebSphere/AppServer/profiles/dataconvdev/databases/EJBTim
ers/server1/EJBTimerDB',
see the next exception for details.
DSRA0010E: SQL State = XJ040, Error Code = 40,000
at com.ibm.ws.scheduler.WASSchedulerCfgHelper.createTables (WASSchedulerCfgHelper.java:542) at com.ibm.ws.runtime.component.EJBContainerImpl.createTimerTables(EJBContainerImpl.java:2604) at com.ibm.ws.runtime.component.EJBContainerImpl.getSchedulerInstance(EJBContainerImpl.java:2335) Caused by:
com.ibm.ws.extensionhelper.exception.UnableToInitializeException:
java.sql.SQLException: Failed to start database '/datacon
Caused by: java.sql.SQLException: Failed to start database
'/dataconv/IBM/WebSphere/AppServer/profiles/dataconvdev/databases/EJBTimers/server1/EJBTimerDB',
see the next exception for details.DSRA0010E:
SQL State = XJ040, Error Code = 40,000
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.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)

Caused by: SQL Exception: Page Page(18,Container(0, 848)) is at version
6,298, the log file contains change version 7,612, either there are log
records of this page missing, or this page did not get written out to
disk properly.
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 43 more

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.5.5;8.0;7.0","Edition":"Base;Express;Network Deployment","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SS7K4U","label":"WebSphere Application Server for z\/OS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":null,"Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"6.1;6.0","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
03 March 2025

UID

swg21288806

Page Feedback