My Oracle Support Banner

Diagnosing org.eclipse.persistence.exceptions.DatabaseException in the SOA Suite (Doc ID 1484364.1)

Last updated on JANUARY 11, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 to 12.1.3.0.0 [Release 11gR1 to 12c]
Oracle(R) BPEL Process Manager 10g - Version 10.1.2.0.0 to 10.1.3.5.0
Oracle Business Process Management Suite - Version 10.3 to 11.1.1.6.0
Information in this document applies to any platform.
***Checked for relevance on 31-January-2014***

Purpose

This document provides information on the org.eclipse.persistence.exceptions.DatabaseException error message, when it is returned within a SOA context, for example from a SOA process or composite or an application which has a SOA process as one of its components (e.g. EBS or AIA). This is one of the most common errors which occurs in SOA products and is very similar to the oracle.toplink.exceptions.DatabaseException described in <note 1483272.1> "Diagnosing oracle.toplink.exceptions.DatabaseException in the SOA Suite".

Examples of this exception are:

org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDeadException:0:weblogic.common.ResourceException: Got minus one from a read call
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SOA_SOAINFRA.AT_PK) violated
Error Code: 1
Call: INSERT INTO AUDIT_TRAIL (CIKEY, COUNT_ID, NUM_OF_EVENTS, BLOCK_USIZE, CI_PARTITION_DATE, BLOCK_CSIZE, BLOCK, LOG) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("XXX_SOAINFRA"."AUDIT_TRAIL"."CI_PARTITION_DATE")

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Details
  Error Message Description
 Troubleshooting
 10g - in the BPEL Console
 11g - in Oracle Enterprise Manager 11g Fusion Middleware Control (Enterprise Manager Console)
 Knowledge Base Articles
 Documentation
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.