Posted in Enterprise Manager, tagged 11g, auto recovery, bpel, configuration, em, fault, instances, oracle, Oracle SOA Suite, SOA on April 25, 2012| 4 Comments »
When running a bpel processes, you can sometimes end up with a fault state.
Later on, from “unknown reason” you see the faulted process being initiate again, and being run from the beginning.
Posted in Adapters, DB Adapter, tagged 11g, adapter, commit, connection pool, datasource, db, dbadapter, global, local, non-xa, oracle, Oracle SOA Suite, SOA, transacrion, xa on April 22, 2012| 17 Comments »
When calling a stored procedure from SOA Suite 11g (Bpel/OSB/BPM ….) , you might get the following error:
….
java.sql.SQLSyntaxErrorException: ORA-02089: COMMIT is not allowed in a subordinate session
….
Posted in Adapters, FTP Adapter, tagged 11g, adapter, deployment, FTP, ftpadapter, oracle, Oracle SOA Suite, put, SOA, stale, weblogic on April 20, 2012| Leave a Comment »
You are getting the following error when trying to execute FTP connection using FtpAdapter on 11g:
Exception occured when binding was invoked. Exception occured during invocation of JCA binding: “JCA Binding execute of Reference operation ‘Put’ failed due to…….A stale Connection Factory or Connection Handle may be used”
Posted in Repository, tagged 10g, 11g, db, oracle, Oracle SOA Suite, SOA, SOA DB tables, states on April 20, 2012| Leave a Comment »
Following is list of States Description and Values for Oracle SOA Suite 10g/11g categorized by table name:
Posted in Adapters, FTP Adapter, tagged 530, adapter, deployment, FTP, ftpadapter, Oracle SOA Suite, SOA, user, weblogic on April 20, 2012| Leave a Comment »
Below is a description of the problem & solution on the weblogic side, assuming there’s no problem with FTP server (connection to FTP server is possible from other machines…)
Oracle Fusion Middleware 