Category Archives: AIA

SOA Suite delete instances for specific composite

There are fine resources on how to purge SOA Suite instances. However there are case where you want to delete the instances for a specific composite deployed in the SOA Suite. An example could be after an extensive test or test load on a specific service implemented in a SCA composite.

Here is the PL/SQL we used to purge instances of the productservice composite in the test partition. It is based on the default packages that are bundled with the SOA Suite to purge instance data:

   l_min_creation_date   TIMESTAMP     := to_timestamp('2010-01-01','yyyy-mm-dd');
   l_max_creation_date   TIMESTAMP     := to_timestamp('2012-09-10 1600','yyyy-mm-dd hh24mi');
   l_batch_size          INTEGER       := 100;
   l_max_runtime         INTEGER       := 60;
   l_soa_partition_name  varchar2(100) := 'test';
   l_composite_name      varchar2(100) := 'productservice';
-- delete instances for specific composite
soa.delete_instances( min_creation_date => l_min_creation_date
                    , max_creation_date => l_max_creation_date
                    , batch_size => l_batch_size 
                    , max_runtime => l_max_runtime
                    --, retention_period =>
                    , purge_partitioned_component => FALSE
                    , composite_name => l_composite_name
                    --, composite_revision => 
                    , soa_partition_name => l_soa_partition_name

You can use the instances tab to track the progress of the delete script:
Composite instance count

Maintaining SOA Suite infrastructure database

While trying to keep my post on purging the BPEL and ESB/Mediator database up to date with the latest documents and experiences, I found these whitepapers and references:

  • SOA 11G Database (pdf) Growth Management Strategy
  • An Oracle SOA 11G installation presents a few challenges for administrators and one of these is managing the growth of the SOA database. The advice facilitates better dialog between SOA and Database administrators when planning and managing database requirements.

  • On Oracle support: SOA 11g Infrastructure Database: Installation, Maintenance and Administration Guide [ID 1384379.1]
  • This document covers everything you need to know about the SOA Infrastructure Database for Oracle SOA Suite 11g. Here we bring together content from sources such as OTN, Product Documentation and our Knowledge Base in an effort to provide you with a single comprehensive resource.

Choosing your Oracle Application Integration Infrastructure

Today I presented at ODTUG Kaleidoscope. The presentation is aimed at supporting architects and especially developers to choose the right integration infrastructure for a job.

Kscope 11 ADF, AIA and Business Rules


There are a lot of presentations at Kscope on ADF where it is mentioned that the level of Java knowledge to implement ADF based applications is very limited. The first presentation by Markus Eisele I saw on Monday was an introduction to Java. It was called “All the Java ADF beginners need to know”. In this hour a short history, Java’s characteristics, at a high level the differences between Java EE, Java SE and Java ME were covered as weel as the the basics of the Java language.

The second presentation on ADF this day was by Sten Vesterli. It was titled: “Enterprise Applications with Oracle ADF – Skills, People, and Tools”. Not only did he go into these three aspects he also spend a part of the presentation on the process of developing software applications using ADF. The skills that were mentioned to develop ADF applications:

  • ADF Framework – Programming by exceptions
  • Object Oriented programming
  • Java programming
  • Database programming (Datamodel, PL/SQL, Batch like things)
  • XML – (Reading the Source View)
  • Regular expression
  • Graphical Design
  • Usability

Business Rules

EuroTransplant is one of the SOA Suite customers that uses the Business Rules Engine that comes with it in a production environment. Wilfred van der Deijl showed us from a developers perspective how the tools is used. During the presentation was clear that business goals like “the business must be able to verify the implemented rules” were clearly met.


Edwin Biemond gave “An Introduction to Application Integration Architecture“. The demo in his presentation helped to demystify the implementation of an AIA integration flow.

Some useful AIA 11g links

For my own reference some useful AIA 11g Foundation Pack references:


The AIA 11g Foundation Pack documentation:


Installing AIA FP ( on SOA Suite 11g R1 PS3 explained by Edwin Biemond on the Whitehorses blog. The Oracle Installation and upgrade guide to go with it can be found here and a whitepaper on installation topologies and architecture.

Blogs on installing previous versions:

Using Composite Application Validation System for non AIA Composites testing

Usings CAVS to test non AIA composites is described by Edwin Biemond.

AIA Service Constructor in JDeveloper 11g PS3

JDeveloper 11g needs extensions to work with SOA Suite / SCA Composites and AIA 3.0 (for example the Service Constructor). An earlier post describes how to use SOA Suite extension in JDeveloper 11g. This post will show you how to install the AIA Service Constructor.

The AIA Service Constructor can be acquired using the menu Help | Check for updates, clicking Next, and selecting Oracle Fusion Middleware Products. SelectAIA Service Constructor and click next to start the download.

Verify the installation of the extension using the menu Help | About, and click on the tab Extensions:

Altering JDeveloper preferences

Now we have to make the aia.jar known to the SOA stuff. In order to do this we use the preferences, using the menu Tools | Preferences.... The is aia.jar in the ...\Middleware\jdeveloper\lib directory.

After these changes JDeveloper needs a restart.

Sharing artifacts using the MDS Repository

Both during development and maintenance of code, deployment strategies relying on copying of artifacts will fail, or at least complicate the task at hand and frustrate reuse. SOA Suite offers a centralized storage for artifacts (like WSDL, XSD, and XSL files) that can be accessed both at design time and at run-time. It is called the MDS Repository, and comes with Metadata Services on top of it. It is part of the SOA Suite and doesn’t require additional installation. This blogpost will show you how to upload an artifact to the central MDS Repository, and how to use the uploaded artifact in your source code.

Locate and copy the WSDL

Locate the WSDL file in your project on the local file system, for example: C:\JDeveloper\mywork\AIApocBOUW\CreateInventoryTransactionRIBRMSProvABCSImpl.wsdl. In which a convention like C:\JDeveloper\mywork\__Workspace__\__project__ is used. You can also determine this path in JDeveloper by selecting the WSDL file and use CRTL-SHIFT-C (or by selecting contextmenu – Copy Path).

Use an FTP tool to move the file to the server running the SOA Suite. The path to use on the server depends on the application, version and component type. Typically in AIA there is a structure like $AIA_HOME/AIAMetaData/AIAComponents/ApplicationConnectorServiceLibrary/__Application__/__version__/__componentType__ . Where in AIA component types are ABCS Provider, ABCS Requestor, EBS, et cetera. In other environments you can create your own structure. Since you no longer need a local copy of the WSDL, remove it from your local file system.

Load the WSDL in the MDS Repository

To load the WSDL and other artifacts to the MDS repository there is an ANT script available on the server. To use ANT, make sure the needed environment settings are made correctly. When you installed AIA there is a Shell script available the will source both AIA and ANT environments: This script can be found in ...../weblogic/aia30/aia_instances/aia30poc/bin. It can be convenient to copy this to your home directory.

  • Source AIA and ANT environment: source ./
  • Alter the UpdateMetaDataDP.xml configuration file. It can be found in ...../weblogic/aia30/aia_instances/aia30poc/config.

In case your vi isn’t up to par use a tool like WinSCP and choose Edit in the context menu:

In the UpdateMetaDataDP.xml file alter the file set. In the example on which the screenshot is based
is added.

And now you are ready to run ANT using the actual loading script:
ant –f /fs01/app/oracle/esbtst01/weblogic/aia30/Infrastructure/Install/scripts/UpdateMetaData.xml

Check the output of the ANT script:

  • check that the correct number of files has been copied.
  • the server gave a HTTP response 200.
  • The deployment of the composite was successful.

Another check to verify a correct load into the MDS Repository is to use the MDS Browser in JDeveloper to find the file you just uploaded. A refresh of the view could be needed to include the latest changes and additions.

Using the WSDL in the MDS Repository in your source code

The last step is to reference to the WSDL in the MDS Repository, since the file has been removed from the local file system. Double click the Exposed Service to open the wizard:

Choose Existing WSDL to select the WSDL from the MDS Repository:

Check the change using the source view. In the import of the WSDL in the composite.xml there should now be an URL referring to oramds:, like in the example below:

<import namespace=""

Oracle OpenWorld 2010: Must see session guides

To prepare your visit to Oracle OpenWorld 2010, this post provides some links to selections of sessions with a focus on eg BPM, AIA, et cetera. Here is my top ten:

  1. Oracle AIA – Application Integration Architecture
  2. Architects and architecture
  3. BPM – Business Process Management
  4. Cloud Computing
  5. Data Integration
  6. EDA – Event Driven Architecture
  7. Fusion Middleware development
  8. Java EE
  9. Middleware for Enterprise Applications
  10. SOA – Service Oriented Architecture


Okay, i’ll plug two sessions:

  • Customer – S314708 – Transform Your Business with Oracle Application Integration Architecture | Monday, September 20, 14:00 | Moscone West L3, Rm 3011
  • Colleague – S316135 – From Oracle Forms to a Service-Oriented Architecture with Oracle SOA Suite 11g | Tuesday, September 21, 5:00PM | Marriott Marquis, Salon 9

Have Fun

AIAMigrationUtility avoid NullPointerException in

Using the AIAMigrationUtility in AIA 11g R1 we encountered the following error:


[exec] setupMDSstore:
[exec] bpel:
[exec] [upgrade]

[exec] [upgrade] Reading WSDL Location
[exec] [upgrade] Jul 26, 2010 3:27:34 PM oracle.viewgen.ViewGenerator main
[exec] [upgrade] SEVERE: Upgrade failed. Check the logs for any exceptions. Ensure that the WSDL URLs specified in the project are reachable and a valid 10.1.3.x project is used for upgrade. Before re-attempting upgrade, restore the original project code source from the backup directory.
[exec] [upgrade] java.lang.NullPointerException
[exec] [upgrade] at oracle.viewgen.composite.CompositeUtil.setupBinding(
[exec] [upgrade] at oracle.viewgen.composite.CompositeUtil.setupCompositeServices(
[exec] [upgrade] at oracle.viewgen.composite.CompositeUtil.createComposite(
[exec] [upgrade] at oracle.viewgen.ViewGenerator.main(
[exec] [upgrade] Exception in thread “Main Thread” java.lang.NullPointerException
[exec] [upgrade] at oracle.viewgen.composite.CompositeUtil.setupBinding(
[exec] [upgrade] at oracle.viewgen.composite.CompositeUtil.setupCompositeServices(
[exec] [upgrade] at oracle.viewgen.composite.CompositeUtil.createComposite(
[exec] [upgrade] at oracle.viewgen.ViewGenerator.main(
[exec] /fs01/app/oracle/esbtst01/weblogic/Oracle_SOA1/bin/ant-sca-upgrade.xml:71: Java returned: 1
[exec] Total time: 5 seconds

/fs01/app/oracle/esbtst01/weblogic/aia30/util/AIAMigrationUtility/AIAMigrationUtility.xml:58: The following error occurred while executing this line:
/fs01/app/oracle/esbtst01/weblogic/aia30/util/AIAMigrationUtility/AIAMigrationUtility.xml:140: exec returned: 1

Total time: 7 seconds

This was solved (unexpected) by altering the adf-config.xml in the .adf/META-INF/ directory for the workspace. The following was added:

          <namespace metadata-store-usage="mstore-usage_2"
          <metadata-store-usage id="mstore-usage_2">
            <metadata-store class-name="oracle.mds.persistence.stores.db.DBMetadataStore">
              <property value="DEV_MDS" name="jdbc-userid"/>
              <property value="poctst01" name="jdbc-password"/>
              <property value=""
              <property value="soa-infra" name="partition-name"/>

In other words the connection information for the MDS has been provided.

Update ANT and MDS

Today I came across his blogpost on another ANT script using MDS during deployment. Which requires a similar solution: altering the adf-config.xml in the .adf/META-INF/ directory.

Reference binding to Service without WSDL

For the first time I had to make an integration to a service that had no WSDL deployed with it. Since the (SCA) Composite assumes a WSDL it takes some time to figure out how to realise this. Under default conditions a Reference in a (SCA) Composite in SOA Suite 11g looks something like:

<reference ui:wsdlLocation="SomeDataRef.wsdl"
  <interface.wsdl interface=""
  < port=""
              location="" />

The location of the points to a WSDL. Which is no problem at compile time. However at runtime the WSDL can not be found and an error is raised.
This error can be prevented by pointing to the endpoint instead of to the WSDL. To accomplish this your Reference in a (SCA) Composite in SOA Suite 11g would look something like:

<reference ui:wsdlLocation="SomeDataRef.wsdl"
  <interface.wsdl interface=""
  < port=""

Now there is an uri in the refering to an endpoint.