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 220.127.116.11.0 to 18.104.22.168.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 22.214.171.124.0
Information in this document applies to any platform.
***Checked for relevance on 31-January-2014***
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:
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
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 (?, ?, ?, ?, ?, ?, ?, ?)
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("XXX_SOAINFRA"."AUDIT_TRAIL"."CI_PARTITION_DATE")
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
|Error Message Description|
|10g - in the BPEL Console|
|11g - in Oracle Enterprise Manager 11g Fusion Middleware Control (Enterprise Manager Console)|
|Knowledge Base Articles|