Digital Transformation . API . Integration . IAM

Recently I have come across a strange situation for deployment of a SOA composite 12c (having DbAdapter) in production environment. Below is summary of issue and solution- Error:  Deployment of a SOA composite is failing with "Error while validating JCA Reference Binding meta data during composite deployment. : JCA deployment validation errors for 'Adapters/dbadapter_db.jca' Environment Details 1. SOA Suite: Oracle SOA Suite 12c(12.1.3.0.0) 2. Operating System: Oracle Linux 7 3. Database: Oracle Database 12cR2 (12.2.2.1) Error Log- soa_server1-diagnostic.log 2019-05-23T17:20:15.480+05:30] [soa_server1] [ERROR] [] [oracle.integration.platform.blocks.deploy] [tid: [ACTIVE].ExecuteThread: '57' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: d2fb4bbc-5b4e-4d2d-a19a-a19ac0d8be37-00001b17,0:7:2] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000Mf^XjTr56i05nzp2iZ1StcZn000001] Except...

In this post, I'll share the solution that worked for a SOA composite runtime error. I have created a soa composite with a WebService component, a mediator and a database adapter. Below error encountered during the composite web service test- Error JCA Resource , Error Oracle Mediator , ORAMED-03503: [Transaction Commit] Unable to commit transaction , Transaction has - been rolled back , XA JCA Resource SOLUTION Below solution worked for issue resolution- The issue was majorly associated with JDBC connection profile created in weblogic server. So we need to fix this inside weblogic console as per the below steps- 1. Login to weblogic server console- http://192.168.0.112:7001/console and navigate to Data Sources and click on that data source. In my case it is 'DBConnLocal06102017'. 2. Go to configuration tab and click on Transaction sub-tab. Check (mark) on 'Support Global Transactions' and select 'Emulate Two Phase Commit' option. 3. Just sav...