ORABPEL-08033

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:    ORABPEL-08033

ORABPEL-08033

EJB Transaction Error.
EJB exception happened while invoking the partner.
Please verify partner service.
</fault></messages> 
</sequence> 
[2010/05/04 09:29:07] BPEL process instance "26722314" cancelled 
</process> 
[2010/05/04 09:29:07] There is a system exception while performing the BPEL instance, the reason is "Missing IN or OUT parameter at index:: 15 ". Please check the error log file for more infromation. Please try to use bpel fault handlers to catch the faults in your bpel process. If this is a system exception, please report this to your system administrator. Administrator could perform manual recovery of the instance from last non-idempotent activity or dehydration point.less 
oracle.AQ.AQOracleSQLException: Missing IN or OUT parameter at index:: 15

at oracle.AQ.AQOracleQueue.enqueue(AQOracleQueue.java:1267)
at oracle.tip.adapter.aq.database.MessageWriter.doEnqueue(MessageWriter.java:713)
at oracle.tip.adapter.aq.database.MessageWriter.enqueue(MessageWriter.java:452)
at oracle.tip.adapter.aq.database.MessageWriter.writeMessage(MessageWriter.java:414)
at oracle.tip.adapter.aq.outbound.AQEnqueuer.execute(AQEnqueuer.java:111)

Symptoms:

Log files:

BPEL logs :-

<2010-04-15 15:22:17,818> <ERROR> <declaration.collaxa.cube.ws> <AQ Adapter::Outbound> MessageWriter_enqueue: Could not enqueue message due to exception
<2010-04-15 15:22:17,819> <ERROR> <declaration.collaxa.cube.ws> <AQ Adapter::Outbound> 
java.lang.NullPointerException
at oracle.jdbc.driver.OracleCallableStatement.getBytes(OracleCallableStatement.java:1262)
at oracle.oc4j.sql.proxy.CallableStatementBCELProxy.getBytes(CallableStatementBCELProxy.java:214)
at oracle.AQ.AQOracleQueue.enqueue(AQOracleQueue.java:1238)
...
<2010-04-15 15:22:17,819> <ERROR> <declaration.collaxa.cube.ws> <AdapterFramework::Outbound> file:/u01/app/oracle/products/OAS/1013/SOA/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.6.1_5b1c49eee1f19d4b66a413310dc8b978.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - Could not invoke operation 'Enqueue' against the 'AQ Adapter' due to: 
ORABPEL-11947
Enqueue failed.
Enqueue failed.
Please examine the log file to determine the problem.

<2010-04-15 15:22:17,819> <ERROR> <declaration.collaxa.cube.ws> <AdapterFramework::Outbound> file:/u01/app/oracle/products/OAS/1013/SOA/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.6.1_5b1c49eee1f19d4b66a413310dc8b978.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - Rolling back JCA LocalTransaction
<2010-04-15 15:22:17,893> <ERROR> <declaration.collaxa.cube.ws> <WSIFInvocationHandler::invoke> Fault happened: file:/u01/app/oracle/products/OAS/1013/SOA/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.22.6.1_5b1c49eee1f19d4b66a413310dc8b978.tmp/SID_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - WSIF JCA Execute of operation 'Enqueue' failed due to: Enqueue failed.
Enqueue failed.
; nested exception is: 
ORABPEL-11947
Enqueue failed.
Enqueue failed.
Please examine the log file to determine the problem.

<2010-04-15 15:22:17,977> <ERROR> <declaration.collaxa.cube> <BaseCubeSessionBean::logError> Error while invoking bean "delivery": javax.transaction.xa.XAException
javax.transaction.xa.XAException
at com.collaxa.cube.ejb.impl.DeliveryBean.request(DeliveryBean.java:109)
at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
...
Caused by: javax.ejb.EJBException: An exception occurred during transaction completion: ; nested exception is: javax.transaction.RollbackException: Exception occurred during resource end(): oracle.jdbc.driver.T4CXAResource@d989e9 (Xid( Global Id cf.15.30.39.00.00.00.00.c6.ee.c9.ff.27.01.00.00.a5.93.00.00.00.00.00.00, Format Id 1330790740, Branch Id 75.c0.aa.38.00.00.00.00.00.00.00.00.00.00.00.02)): javax.transaction.xa.XAException
at com.evermind.server.ejb.EJBUtils.createEJBException(EJBUtils.java:365)
at com.evermind.server.ejb.EJBTransactionManager.end(EJBTransactionManager.java:150)
...
Caused by: javax.transaction.RollbackException: Exception occurred during resource end(): oracle.jdbc.driver.T4CXAResource@d989e9 (Xid( Global Id cf.15.30.39.00.00.00.00.c6.ee.c9.ff.27.01.00.00.a5.93.00.00.00.00.00.00, Format Id 1330790740, Branch Id 75.c0.aa.38.00.00.00.00.00.00.00.00.00.00.00.02)): javax.transaction.xa.XAException
at com.evermind.server.ApplicationServerTransaction.checkForRollbackOnlyWhileInCommit(ApplicationServerTransaction.java:664)
at com.evermind.server.ApplicationServerTransaction.doCommit(ApplicationServerTransaction.java:278)
at com.evermind.server.ApplicationServerTransaction.commit(ApplicationServerTransaction.java:162)
...
Caused by: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.allowGlobalTxnModeOnly(OracleXAResource.java:858)
at oracle.jdbc.xa.OracleXAResource.suspendStacked(OracleXAResource.java:267)
at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:333)
at oracle.oc4j.sql.spi.XAResourceWrapper.end(XAResourceWrapper.java:118)
at oracle.j2ee.connector.transaction.XAResourceWrapper.end(XAResourceWrapper.java:120)
at com.evermind.server.TransactionEnlistment.end(TransactionEnlistment.java:38)
at com.evermind.server.ApplicationServerTransaction.endResources(ApplicationServerTransaction.java:1168)
at com.evermind.server.ApplicationServerTransaction.doCommit(ApplicationServerTransaction.java:277)
... 57 more
...

Solution:

++ Remove ManagedConnectionFactory in the SID_invoke.wsdl and ensure that the "eis/jdbc/DPPSID_AQ" is defined in the $OH/j2ee/oc4j_soa/application-deployments/default/AqAdapter/oc4j-ra.xml.

So, your SID_invoke.wsdl should like :
...
<jca:address location="eis/jdbc/DPPSID_AQ"/>
...


++ Add the following settings to the bpel.xml for the SID_invoke partnerlink :

<partnerLinkBinding name="SID_invoke">
<property name="wsdlLocation">SID_invoke.wsdl</property>
<property name="timeout">15</property>
<property name="retryInterval">60</property>
<property name="retryMaxCount">10</property>
</partnerLinkBinding>

References:

Get Oracle Certifications for all Exams
Free Online Exams.com