Feeds:
Posts
Comments

Posts Tagged ‘oracle’

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 »

After I’ve downloaded and installed Oracle SOA Suite 11g, I relyezed very quickly that I forgot to set one important parameter.

When trying to start the manage server I got the following error:

 

MDS-01329: unable to load element “persistence-config”

MDS-01370: MetadataStore configuration for metadata-store-usage “soa-infra-store” is invalid.

ORA-04063: package body “DEV_MDS.MDS_INTERNAL_SHREDDED” has errors

ORA-06508: PL/SQL: could not find program unit being called: “DEV_MDS.MDS_INTERNAL_SHREDDED”

(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 »

While running Bpel processes you might run into the following errors:

Transaction Rolledback.: weblogic.transaction.internal.TimedOutException: Transaction timed out

….

(more…)

Read Full Post »

The Weblogic installed in this demo is ‘Oracle WebLogic Server + Coherence – Package Installer 10.3.6’ (32-bit JVM)

You can find Weblogic Installation here:
http://www.oracle.com/technetwork/middleware/weblogic/overview/index.html

Please follow the next steps in order to install the WebLogic Server:

(more…)

Read Full Post »

The RCU creates all the needed schemas required by the SOA Suite.
You can find RCU 11.1.1.6.0 installation here:
http://download.oracle.com/otn/nt/middleware/11g/111160/ofm_rcu_win_11.1.1.6.0_disk1_1of1.zip

More information about the RCU and schmeas creation:
http://docs.oracle.com/cd/E23943_01/doc.1111/e14259/rcu.htm#BABIDIBC

(more…)

Read Full Post »

After working many years with Oracle SOA Suite 10g/11g on Development & Production mode, I’ve decided to implement and install the last release – Oracle SOA Suite 11gR1 (11.1.1.6.0) on my local machine. I’m curious to see and test the new features Oracle posted on their release from February 2012 (http://www.oracle.com/technetwork/middleware/soasuite/documentation/default-1532821.html).

I must say that Oracle’s Documentations for the full installation are very comprehensible and clear.
To focus the installation into the main parts, I’ve posted this blog that describes, a step by step explanation and description about how to download & install Oracle SOA Suite 11gR1(11.1.1.6.0).

(more…)

Read Full Post »

Oracle Database 11g Express Edition is free and can be download from here:
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

Please follow the next steps in order to install the DB:

(more…)

Read Full Post »

« Newer Posts - Older Posts »