zero instances are getting created for some declarations (messages) in BPEL ORABPEL-04004

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: zero instances are getting created for some declarations (messages) in BPEL ORABPEL-04004

ORABPEL-04004 Cannot insert audit trail.

Symptoms:

ORABPEL-04004


Cannot insert audit trail.

The process domain was unable to insert the current log entries for the instance "24139318" to the audit trail table. 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: INSERT INTO audit_trail( cikey, domain_ref, count_id, block, block_csize, block_usize, log ) VALUES( ?, ?, ?, ?, ?, ?, ? )



at com.collaxa.cube.engine.adaptors.oracle.AuditTrailPersistenceAdaptor$TrailHandler.store(AuditTrailPersistenceAdaptor.java:296)

at com.collaxa.cube.engine.adaptors.common.BaseAuditTrailPersistenceAdaptor.store(BaseAuditTrailPersistenceAdaptor.jav
Log files:

BPEL_oc4j_psoa_default_group_1.zip
==============================================
1.ORABPEL-04077

Cannot fetch a datasource connection.
The process domain was unable to establish a connection with the datasource with the connection URL "jdbc/BPELServerDataSource". The exception reported is: java.lang.InterruptedException: sleep interrupted
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.

Message handle error.
An exception occurred while attempting to process the message "com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessage"; the exception is:

2.ORABPEL-05002

Message handle error.
An exception occurred while attempting to process the message "com.collaxa.cube.engine.dispatch.message.invoke.InvokeInstanceMessage"; the exception is:

3.ORABPEL-04066

Cannot insert invoke message.
The process domain was unable to insert the invocation data for message "8351bc50dfe78320:-67cdf2de:127b2817f0b:-7708", operation "receive" in the datastore. The exception reported is: javax.resource.ResourceException: SystemException: Failed to add the resource due to error in the resource : oracle.jdbc.xa.OracleXAException errorcode : -7
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: INSERT INTO invoke_message( conv_id, message_guid, domain_ref, process_id, revision_tag, operation_name, receive_date, priority, properties, master_conv_id, headers_ref_id ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

4.ORABPEL-04005

Cannot insert audit details.
The process domain was unable to insert the current audit trail detail entries for the instance "17650617" to the audit details table. 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: INSERT INTO audit_details ( cikey, domain_ref, detail_id, bin_csize, bin_usize, bin ) VALUES ( ?, ?, ?, ?, ?, ? )

5.ORABPEL-04004

Cannot insert audit trail.
The process domain was unable to insert the current log entries for the instance "17690783" to the audit trail table. The exception reported is: No more data to read from socket
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: INSERT INTO audit_trail( cikey, domain_ref, count_id, block, block_csize, block_usize, log ) VALUES( ?, ?, ?, ?, ?, ?, ? )

6.<2010-03-31 15:35:33,912> <:outbound>file:/u01/app/appsoau/product/10.1.3.1/OracleAS_1/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.25.0.2_48176ada0f8193d39cea1f7dce7ad1d4.tmp/DPW_invoke.wsdl [ Enqueue_ptt::Enqueue(Clearance) ] - Rolling back JCA LocalTransaction
<2010-03-31 15:35:33,913> <:invoke>Fault happened: file:/u01/app/appsoau/product/10.1.3.1/OracleAS_1/bpel/domains/declaration/tmp/.bpel_EnqueueClearanceProcess_0.25.0.2_48176ada0f8193d39cea1f7dce7ad1d4.tmp/DPW_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.

Solution:



1.Add the cache properties in bpel.xml under the partner link tag
eg:

....
120
true
10
false

2. Define a JCA connection pool in oc4j-ra.xml for the JNDI name which is being used by the
outbound AQ partnerlink.
eg:

....






3. Use separate datasource for reading or writing the queue.


==========================

1. Stop SOA Suite .
2. Change to transaction-timeout="600" in the following file
at $ORACLE_HOME/j2ee/oc4j_soa/config/transaction-manager.xml .
3. Change to transaction-timeout="600" for CubeEngineBean, DispatcherBean, and CubeDeliveryBean and DeliveryBean in the following file
at $ORACLE_HOM/j2ee/oc4j_soa/application-deployments/orabpel/ejb_ob_engine/orion- @ ejb-jar.xml
4. Start SOA Suite
5. Applying DB patches
Patch 7241999- "UNABLE TO LOCK STORE" COORDINATORCREATIONEXCEPTION PREVENTS STARTUP and Patch 7279335
6. add tx-level ="global" in all xa datasurces.

References:

Oracle Support for Note 738108.1 “Required Patching for XA Deployments of SOA Suite

Note 730285.1 AQ Adapter: ORABPEL-12511, javax.resource.spi.ResourceAllocationException: Unable to allocate new
connection

Note 565944.1 MQ Adapter Under Stress Test: ORABPEL-12511 Adapter Framework Unable to Create Outbound JCA Connection

Get Oracle Certifications for all Exams
Free Online Exams.com