Feeds:
Posts
Comments

Archive for the ‘Adapters’ Category

The below error can happen when you run any kind of a process that uses JDBC:

ORA-28267: Invalid Namespace Value In SOA Suite 11.1.1.7
ORA-02063

This is a bug!
The cause of the problem is when using Oracle JDBC Driver file (ojdbc6dms.jar) and calling a DB object (procedure, function etc…) that issues SQL over a DB link from 11g to 10g DB.

There is no patch for that at the moment.
I found a workaround, that was approved by oracle:

Under the below folders, replace the ojdbc6dms.jar file with ojdbc6.jar file:
$MID_HOME/wlserver_10.3/server/ext/jdbc/oracle/11g
$MID_HOME/oracle_common/modules/oracle.jdbc_11.1.1

You can find the ojdbc6.jar driver in the below link:
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

It is also suppose to be under $MID_HOME/wlserver_10.3/server/lib. You can just copy it from there.

There is one exception: No JDBC metrics will be produced. If you need it, you will have to open SR.

Good Luck!

Read Full Post »

The following steps describes how to create a JNDI location so you can use it later on your DbAdapter
(The configuration is done on Oracle EM 10g(10.1.3.1) Application Server Control):

1. Create a Connection Pool

In the EM click on your OC4J server (where Bpel PM exists in):

oc4j

 

 

(more…)

Read Full Post »

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.”

(more…)

Read Full Post »

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

(more…)

Read Full Post »

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.

(more…)

Read Full Post »

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

(more…)

Read Full Post »

Archiving a file when using FTP Adapter is very important. From some reason a file might be poled but not processed.
To overcome it, there is an option to save a backup file, after the file was polled.
When using FtpAdapter, you can choose to save a backup file on the remote FTP server, or on the local server.
In this post I will explain how to do it.

(more…)

Read Full Post »

Older Posts »