Posted in Activities, Bpel, Email, tagged 10g, bpel, email, email activity, JDeveloper, Oracle SOA Suite, SOA on January 15, 2013| Leave a Comment »
In this post I will show one way to send Email notification with attachments.
This example will explain how to assign a string message that will appear on the mail as a HTML attachment.
In my next post I will explain how to read a file from your OS and send it as an attachment.
Start with creating a new bpel process. Create a new string variable and assign to it the required message that will appear later on in the HTML
(notice that you don’t need to add header/body tags):
Posted in Bpel, Development, tagged 10g, 11g, bpel, JDeveloper, Oracle SOA Suite, SOA Suite, transformation activity, xsl on January 10, 2013| Leave a Comment »
In this post I will explain how to add a variable into a XSL code. I will also explain why do we need it at all.
(This option exists on both Oracle SOA Suite 10g and 11g versions. Some of the screens might be a little bit different. Below I’ve attached print screens from 11g)
If you are using a transformation activity in your process, you probably need to do some mapping for multiple records data.
Like in other developing languages, there are cases where you want to declare a variable once, assign to it a value, and use it later on in your code.
When using xsl for mapping source to target, it is the same behavior.
Let’s take 2 scenarios:
Posted in Bpel, Enterprise Manager, tagged bpel, composites, em, instances, Oracle SOA Suite, SOA, SOA Suite on December 10, 2012| Leave a Comment »
When dealing with large amount of instances (on one composite application or more), you can end up with slow performance
on the instances load.
I will describe, how a simple configuration can increase the performance for this issue.
Before, I would like to emphasize: performance issues on EM, can be caused from many reasons, like – wrong process plan, DB growth, lack of infra structure resources etc.
When planning processes, there is a need to take in a consideration, all of the parameters.
So, how to set those parameters – very simple:
Posted in Activities, Bpel, Development, tagged 10g, 11g, bpel, fault management, oracle, Oracle SOA Suite, SOA Suite, Throw Activity on November 3, 2012| 4 Comments »
When creating and planning bpel processes, you must always consider using Fault Management.
Bpel process management provides many options and ways to handle and manage fault.
Sometimes, there can be a requirement to throw a custom fault – one that does not exist in the built in system fault that is being provided in the Throw Activity list.
In this post I will describe how to do it, in the most simple way.
I created my example in SOA suite 11g (11.1.1.6), but that’s the way to go on all bpel versions.
Posted in Adapters, DB Adapter, tagged bpel, db, dbadapter, Oracle SOA Suite, weblogic on October 2, 2012| 2 Comments »
When you are using one of the following Adapters – Database/Oracle Application/AQ, sometimes (randomly) you might get an error like:
“Exception occured when binding was invoked. Exception occured during invocation of JCA binding: “JCA Binding execute of Reference operation ‘GetData’ failed due to: Stored procedure invocation error. Error while trying to prepare and execute the BPEL_GETDATA.PROCEDURE$GET_ DATA API. An error occurred while preparing and executing the BPEL_GETDATA.PROCEDURE$GET_ DATA API. Cause: java.sql.SQLTimeoutException: ORA-03111: break received on communication channel Check to ensure that the API is defined in the database and that the parameters match the signature of the API. This exception is considered retriable, likely due to a communication failure. Because the global transaction is rolling back the invoke must be retried in a new transaction, restarting from the place of the last transaction commit. To classify it as non-retriable instead add property nonRetriableErrorCodes with value “1013” to your deployment descriptor (i.e. weblogic-ra.xml). “. The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.”
Posted in WebLogic, tagged 10.3.5, 11g, BEA-090087, Manage Server, oracle, Oracle SOA Suite, SOA, weblogic on September 11, 2012| 1 Comment »
It is very problematic and annoying when you didn’t change anything on your WebLogic server (like your manage server IP), and still you get the following error:
…
BEA-002606>
…
…
Posted in Adapters, FTP Adapter, tagged 11g, adapter, deployment, FTP, ftpadapter, get, JCA-11007, JCA-11426, JCA-11430, jndi, oracle, Oracle SOA Suite, put, SOA, stale, weblogic on August 21, 2012| Leave a Comment »
I’ve noticed something very interesting in the log file when the ‘GET’ operation stopped working (Poll files from remote server).
I found some errors like:
…
BINDING.JCA-11007
No Data to process
…
BINDING.JCA-11430
Error in listing files in the remote directory.
Unable to list file in remote directory.
Please make sure that the ftp server settings are correct
…
Caused by: BINDING.JCA-11426
Unable to enter passive mode
…
File Adapter testTab PollWork::run exiting, Worker thread will die
…
Posted in Adapters, Bpel, DB Adapter, tagged 10g, 11g, bpel, db, dynamic parameter, JDeveloper, oracle, Oracle SOA Suite, parameter, Pure SQL Operation, SOA on August 1, 2012| 2 Comments »
DbAdapter provides all kind of operations that helps you interact with the DB.
I saw more than few times, questions, about how to use dynamic parameters when executing the ‘Execute Pure SQL‘ operation.
In the following step I will explain how to do it.
Posted in Adapters, DB Adapter, tagged 10g, 11g, bpel, bpelconsole, case sensitive, db, JDeveloper, oracle, Oracle SOA Suite, SOA, SQLException on July 8, 2012| Leave a Comment »
I must say that I’ve predicted this error….
One of my customer’s requirements is to run a simple query on Oracle 10g Database.
I’ve developed a simple process in Bpel 10g that uses ‘select’ operation from a DbAdapter.
I ran the process from the BPELConsole, and got the following error:
WSIF JCA Execute of operation ‘GetDataSelect’ failed due to: DBReadInteractionSpec Execute Failed Exception.
Query name: [GetDataSelect], Descriptor name: [GetData.PlwProject1]. [Caused by: ORA-00911: invalid character
]
; nested exception is:
ORABPEL-11614
DBReadInteractionSpec Execute Failed Exception.
Query name: [GetDataSelect], Descriptor name: [GetData.PlwProject1]. [Caused by: ORA-00911: invalid character
Oracle Fusion Middleware 