In Oracle SOA Suite 10g, or more specific BPEL 10g, one could group functionality in domains. This feature has been away in the early versions of SOA Suite 11g. They have returned in more recent version and can be used for all SCA composites (instead of BPEL only). Nowadays these 10g domains are called partitions.
Create SOA Suite partition
- Login to the Fusion Middleware Enterprise Manager: http://server-name:portnr/em
- Use the tree-view on the left and select soa-infra.
- Use the SOA Infrastructure dropdown menu and select the Manage Partitions item.
- The manage partitions page appears and you should select Create… to create your new SOA Suite partition.
- Enter a name for the partition and press the create button.
While deploying SCA appications from JDeveloper or ANT you should add the partition from now on.
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:
Categories: AIA, BPEL, BPM, JDeveloper, Oracle, Service Bus, SOA Suite, Tools
BPEL, BPM, Fusion Middleware, instance, JDeveloper, SOA Suite
BPMN processes created in the BPM Suite can be monitored by standardized dashboard in the BPM workspace. Besides that there a default views to export Oracle BPM metrics to a data warehouse. And there is another option: BAM – Business Activity Monitoring. BAM takes the monitoring of BPMN processes one step further. BAM allows you to create more advanced dashboards and even real-time alerts. BAM enables you to make decisions based on real-time information gathered from your running processes. With BPMN processes you can use the standard Business Indicators that the BPM Suite offers you and use them to with BAM without much extra effort. However you have to enable BAM in BPM processes.
- In the BPM Project Navigator right click the BPM project
- Select Project Preferences
- In the Category tree, select Process Analytics Summary
- Click the Data Targets tab
- Check the Enable BAM checkbox
- Select the JNDI name of the BAM Adapter labeled as
- Click OK
When you run a process that has Oracle BAM enabled the BPMN Service Engine populates Oracle BAM database with information about the business indicators measured in that process. The BPMN Service Engine generates this information based on the Sampling Points preference you defined in your project.
Also read the blog post on how to configure your SOA server to know where your BAM server is running. This is also needed to use BAM for BPM metrics.
Managers and teamleads rely on measurements to know how processes and teams are performing. With an increased BPM effort and automated support of processes, more and more questions on solid information from these systems rise. Oracle BPM offers an easy way to export metrics to a data warehouse. Oracle BPM captures standard and business specific metrics and exposes these through a BPM process star schema.
Export Oracle BPM metrics to a data warehouse
To export Oracle BPM metrics to a data warehouse the
SOAINFRA schema in which all configuration and (runtime) instance data is stored offers a number fact tables. These standard views enable the extraction of information for BI usage. For Oracle BPM release prior to PS4FP (126.96.36.199.1) the views have to be created manually. From patchset 4 onwards the process has been automated. Please note that it is not recommended to run the BI reports on the BPM process database.
An overview of the standard fact tables:
- BPM_PROCESS_PERFORMANCE_V – offers standard metrics (like start and end time and running time in seconds) for completed processes.
- BPM_ACTIVITY_PERFORMANCE_V – offers standard metrics for completed activities, completed intervals, measurement marks and counters for both in-flight and completed process instances.
- BPM_PROCESS_INSTANCE_V – offers standard metrics for in-flight process instances. Because of that the information is only relevant at the time the view is queried. When processes move forward the information in this view refelcts the progress.
- BPM_ACTIVITY_INSTANCE_V – offers standard metrics for in-flight activities and interval instances.
An overview of the dimension tables:
- BPM_PROCESS_DEFINITION_V – including data on domain, composite, label and revision.
- BPM_ACTIVITY_DEFINITION_V – including the type of activity: UserTask, Gateway, Event, Measurement interval, etc.
- BPM_ROLE_DEFINITION_V – also allows you to see whether the role is the process owner.
Example queries of BPM process metrics
Average process running time by process:
GROUP BY process_name
The number of faults by process:
WHERE process_discriminator = 'instance_system_fault'
GROUP BY process_name
When you run the process in multiple domains on the same server join with the BPM_PROCESS_DEFINITION_V and differentiate on DOMAINNAME.
Example queries of task performance metrics
Average, minimum and maximum time taken by a participant in a process per activity:
GROUP BY process_name
You could add the revision to see whether certain improvements in the process resulted in faster handling of activities by joining with the BPM_PROCESS_DEFINITION_V. It could also be usefull to join with the BPM_ACTIVITY_DEFINITION_V and discriminate on ACTIVITYTYPE.
In June gartner published it’s Magic Quadrant for Application Infrastructure for Systematic SOA Infrastructure Projects. Due to the nature of SOA initiatives the selection of technologies and products aimed at supporting the implementation of the SOA infrastructure is done upfront. The resulting platform is shared among SOA applications and other integration initiatives in the enterprise.
To address the need for SOA infrastructure vendors typically have “SOA suites” of “SOA platforms”. These package products like:
Magic Quadrant for Application Infrastructure for Systematic SOA Infrastructure
All open source vendors are in the visionary quadrant. In some cases their offerings are more modern than the Leaders’ products, since they are hardly burdened with backward compatibility issues. However these vendors are constrained by their small size or sometimes inconsistent execution.
In general the open source platforms are less expensive and easier to implement and deploy. However their offerings are generally less comprehensive than the Leaders’ offerings. If these offerings fit your requirements this could be an easy-to-use/low-cost SOA infrastructure for your organisation. The open source platforms are a strong technology offering.
Other recent Magic Quadrants for SOA and integration
To create Oracle BPM processess with JDeveloper you need to install the BPM Studio extension. This is similar to installing the SOA Suite extension.
Ensure that the desired version of JDeveloper is installed. You can download JDeveloper here. Should you be unsure on how to install JDeveloper check the SOA Suite quick start guide to guide you.
Install JDeveloper BPM Studio extension
Install JDeveloper in a seperate Middleware Home. When starting JDeveloper choose the “Default” role. To enable JDeveloper to perform development for the SOA Suite and develop and deploy SCA composites you have to install an extension called SOA Composite Editor. When you want to develop BPM processess you need to install BPM Studio extension following these steps:
- Select Help > Check for Updates
- Click Next
- Select Oracle Fusion Middleware Products and Official Oracle Extensions and Updates and click Next
- Select Oracle SOA Composite Editor and Oracle BPM Studio 11g and click Next
- Check the update has finished and click finished
- Restart JDeveloper and you’re good to go
Should you choose to install these extensions from a local file make shure you have the correct version for your JDeveloper and SOA Suite install. You can find these extensions in the JDeveloper Update Center. There is also a JDev extensions blog.
Categories: JDeveloper, Oracle, SOA Suite, Tools, WLS
11g, BPM, Fusion Middleware, JDeveloper, patch, SOA Suite, WLS
Trying to keep up with Java versions that are supported for JDeveloper and SOA Suite, like in JDeveloper now supports 64 bit Windows and Java. Redstack pointed me to the OFM supported systems configurations that show that Fusion Middleware is supported on JDK7. The XLS showing certification with OS etc can be found:
Installing PS5 (188.8.131.52) can cause some problems when using Oracle XE as the infrastucture database. The solution is described in this SOA Suite / BPM blog by Niall Commiskey.
More tips on upgrading OFM 11g to patch set 5
My colleague Laurens van der Starre published a serie of tips and tricks on upgrading Oracle Fusion Middleware to PS5 on the Whitehorses blog.
More considerations on upgrading to OFM 184.108.40.206.0
There is an additional article on upgrading to OFM 220.127.116.11 on the Whitehorses blog. It goes into more detail on JDK 7 support, OWSM in SOA Suite, the combination of OSB en OWSM and for example the PSA (Patch Set Assistant) performance.
Java memory arguments in OFM 18.104.22.168.0
More on setting Java memory arguments in SOA Suite 22.214.171.124.0.
Categories: BPEL, Database, JDeveloper, Oracle, Service Bus, SOA Suite, WLS
11g, Fusion Middleware, JDeveloper, SOA Suite, XE
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.
Categories: AIA, BPEL, Database, Oracle, Service Bus, SOA Suite, Tools, WLS
11g, AIA, Database, Fusion Middleware, SOA Suite
While doing some research on the web I came across a Service Component Architecture Diagram Generator. The script generates diagrams for applications based on the Service Component Architecture (SCA) model. This can be a great aid to understand the relations between components in large BPEL or SOA applications.
Download the tool here. The readme is over here. The script runs on Linux/Unix and has primarily been tested with Oracle Fusion Middleware 11g applications but should work with other BPEL or SOA frameworks.