Error while obtaining handle to JDBC connection.; nested exception is: ORABPEL-11905

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    Error while obtaining handle to JDBC connection.; nested exception is: ORABPEL-11905

Symptoms:

BPEL Enqueue clearance process message is failing for few declarations intermittently
we get this error in BPEL logs

<ERROR> <declaration.collaxa.cube.ws> <WSIFInvocationHandler::invoke> Fault happened: file:/u03/app/si
tnew1/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.0.5.1_81e51e874704d9b8ed7dcdeac0b289a3.tmp/DPW_invoke.wsdl
[ Enqueue_ptt::Enqueue(Clearance) ] - WSIF JCA Execute of operation 'Enqueue' failed due to: Error while obtaining handle to JD
BC connection.
Error while obtaining handle to JDBC connection.
; nested exception is: 
ORABPEL-11905
Error while obtaining handle to JDBC connection.
Error while obtaining handle to JDBC connection

Log files:

10/02/01 09:59:19 QName string is DPPException
10/02/01 10:15:39 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@e105c08 name:DPPException
10/02/01 10:15:39 QName string is DPPException
10/02/01 11:07:42 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@668bda5a name:DPPException
10/02/01 11:07:42 QName string is DPPException
10/02/01 12:24:42 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@32835e3e name:DPPException
10/02/01 12:24:42 QName string is DPPException
10/02/01 12:32:01 pFaultMessage is org.collaxa.thirdparty.apache.wsif.base.WSIFDefaultMessage@6645db6c name:DPPException
10/02/01 12:32:01 QName string is DPPException
<2010-02-01 12:57:34,995> <ERROR> <declaration.collaxa.cube.engine.data> <BaseDocumentHandler::load> 
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
::::::::::::::
::::::::::::::
at java.lang.Thread.run(Thread.java:595)
10/02/01 12:57:35 java.sql.SQLException: Closed Connection
10/02/01 12:57:35 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
::::::::::::::::::
::::::::::::::::::
<2010-02-01 12:57:35,140> <ERROR> <declaration.collaxa.cube.engine.data> <BaseDeliveryPersistenceAdaptor::loadInvokeMetaData> 
ORABPEL-09222

Cannot deserialize DOM element.
Failed to deserialize the DOM element from binary format, the document id 793afcd967e47fcd:58734659:126885d9d4c:74ac. The exception reported is Cannot fetch document.
The process domain was unable to fetch the document "793afcd967e47fcd:58734659:126885d9d4c:74ac" from the datastore. The exception reported is: Closed Connection
Please check that the machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid.
sql statement: SELECT dockey, bin_csize, bin_usize, bin_format, bin FROM xml_document WHERE dockey = ? 


at com.collaxa.cube.xml.dom.SDOMHelper.loadCompressedNormalDocuments(SDOMHelper.java:384)
at com.collaxa.cube.xml.dom.SDOMHelper.loadDocuments(SDOMHelper.java:153)
:::::::::::::::::
:::::::::::::::::
<2010-02-01 12:57:35,150> <ERROR> <declaration.collaxa.cube.engine.data> <DBUtils::close> Caught NPE from JDBC layer: 
java.lang.NullPointerException
at oracle.oc4j.sql.proxy.StatementBCELProxy.oc4j_releaseToCache(StatementBCELProxy.java:67)
at oracle.oc4j.sql.proxy.StatementBCELProxy.oc4j_releaseTarget(StatementBCELProxy.java:79)
::::::::::::::::::
::::::::::::::::::
Exception: java.lang.NullPointerException
Handled As: com.collaxa.cube.engine.EngineException

ORABPEL-00000

Exception not handled by the Collaxa Cube system.
An unhandled exception has been thrown in the Collaxa Cube system. The exception reported is: "java.lang.NullPointerException
at com.collaxa.cube.engine.util.DBUtils.close(DBUtils.java:796)
at com.collaxa.cube.engine.adaptors.common.BaseDeliveryPersistenceAdaptor.__loadInvoke(BaseDeliveryPersistenceAdaptor.java:2250)
:::::::::::
::::::::::
10/02/02 14:37:50 QName string is DPPException


FileName
--------
BPEL~oc4j_soa~default_group~1.log

Solution:

Apply MLR #9

Get Oracle Certifications for all Exams
Free Online Exams.com