"EJPDB0101E: Database domain unavailable" and SQLCODE=-514, SQLSTATE=26501

Technote (troubleshooting)


Problem

When using WebSphere Portal with DB2, the Portal server randomly loses connection to the database and throws "EJPDB0101E: Database domain unavailable" for any of the database domains, along with DB2 errors SQLCODE=-514, SQLSTATE=26501.

Symptom

In the SystemOut.log, the following exception can be seen:

====================
EJPDB0013E: Internal Error.
at com.ibm.wps.datastore.impl.DataStoreContext.handleException
(DataStoreContext.java:388)
at com.ibm.wps.datastore.impl.ResourcePersister.findInternal2
(ResourcePersister.java:1146)
at com.ibm.wps.datastore.impl.ResourcePersister.findInternal
(ResourcePersister.java:1050)
.
.
.
Caused by: com.ibm.wps.datastore.domains.DomainUnavailableException:
EJPDB0101E: Database domain [Domain: rel] is currently unavailable.
at com.ibm.wps.datastore.impl.DataStoreContext.init
(DataStoreContext.java:120)
at com.ibm.wps.datastore.impl.ResourcePersister.findInternal2
(ResourcePersister.java:1074)
... 54 more
====================

and the following DB2 exception can be seen:

==================
[3/27/13 13:34:35:144 EDT] 00000713 Unavailabilit >
com.ibm.wps.services.datastore.UnavailabilityCheckerImpl
isCausedByUnavailability ENTRY
com.ibm.websphere.ce.cm.StaleConnectionException: DB2 SQL Error:
SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURSN200C5, DRIVER=4.12.55
==================


Cause

At the time of this writing, it is unknown what causes this. IBM has been unable to reliably reproduce the error.

Diagnosing the problem

To properly diagnose the problem, JCC tracing must be collected:

Collecting Data: Tracing with the IBM Data Server driver for JDBC and
SQLJ

https://www-304.ibm.com/support/docview.wss?uid=swg21196160

Once tracing is collected, contact IBM support. Otherwise you can use the workaround described in the "Resolving the Problem" section.

Resolving the problem

To workaround the problem, you can take the following steps:

1. Log in to the WAS Admin Console and navigate to Resources -> JDBC -> Datasources
2. Click the link for you Release datasource
3. Click Custom Properties
4. Set the property "keepDynamic" to a value of "2".
5. Save all changes
6. Repeat for each Portal datasource.
7. Restart the Portal server.

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Portal

Software version:

7.0, 8.0

Operating system(s):

AIX

Reference #:

1637452

Modified date:

2013-05-20

Translate my page

Machine Translation

Content navigation