Tuesday Jan 13, 2015

Repository Creation Utility, MDS and Schema Versions


I recently went through the installation of WebLogic 10.3.6 using the Package Installer "Oracle WebLogic Server 11gR1 (10.3.6) + Coherence + OEPE - Package Installer" (oepe-wls-indigo-installer- from Oracle Technology Network. I was doing a full installation of everything in that package and in the process of creating my domain.

During the domain creation one of the dialog boxes was Configure JDBC Component Schema. The installation failed with error message CFGFWK-60853:  A connection was established to the database but no rows were returned from the test SQL statement.

Test JDBC Component Schema

The configuration process is to supply the necessary parameters in the Configure JDBC Component Schema (seen below) and click next.

The next dialog box allows you to test your configuration before moving on to the next step. This is when I had received an error. I was using some schemas that I had created in a previous installation.

The connection was valid but the test SQL still failed. Below is what the message was in the log file.

Component Schema=OWSM MDS Schema
SQL Test=select 1 from schema_version_registry where
				owner=(select user from
				dual) and mr_type='MDS' and

CFGFWK-60850:  Test Failed!
CFGFWK-60853:  A connection was established to the database but no rows were 
returned from the test SQL statement.

Error Resolution

The clue in determining the error was in the select statement (seen above) that is targeting version In my prior installation of WebCenter I installed BPM and that had installed several schemas that had a version number I was able to discover this matter using SQL against the schemas. The SQL is:

select * from schema_version_registry

My findings from the query were:

Since the versions were incompatible I decided to drop the existing repository schemas and then recreate them in the Repository Creation Utility. That solved my problem.

Downloading the Repository Creation Utility (RCU)

I ran into one more difficulty. My RCU was for but I needed an RCU for If found that the version is more difficult to find these days. It was not available in the WebLogic or Fusion Middleware downloads and I did not find it in eDelivery. I was finally able to find it in Oracle Business Intelligence (11.1.1.x) Downloads page in OTN. So, if you are still working in you need to use the correct RCU.

Friday Mar 01, 2013

Webcenter Content (UCM) BPM Integration

This blogs walks through the configurations required in Web Center Content and BPM to invoke a process deployed on the SOA server from the content server workflows. This is a common use case where a BPM or BPEL process has to be invoked from UCM based on an event like document check in.

  1. Prepare the UCM environment for integration with SOA.

This step is only required when the UCM and SOA domains were created separately and the UCM domain is not extended for SOA.

a. Copy the “soa” folder from SOA_ORACLE_HOME to UCM_ORACLE_HOME

For example: Copy D:\Oracle\Middleware\Oracle_SOA1\soa to D:\Oracle\Middleware\Oracle_UCM1\soa

b. Update the class path in setDomainEnv on the UCM server


Edit setDomainEnv.cmd in %DOMAIN_HOME%\bin

Add :  set POST_CLASSPATH=%ORACLE_HOME%\soa\modules\oracle.soa.mgmt_11.1.1\soa-infra-mgmt.jar;%POST_CLASSPATH%


Edit SetDomainEnv.sh in $DOMAIN_HOME/bin

Add: POST_CLASSPATH="${ORACLE_HOME}/soa/modules/oracle.soa.mgmt_11.1.1/soa-infra-mgmt.jar${CLASSPATHSEP}${POST_CLASSPATH}"

c. Enable Cross Domain Security

Perform the following steps in both UCM and SOA console

1. Login to the Weblogic server console (http://localhost:7001/console/)

2. Select the domain name under Domain Structure. Navigate to the Security Tab

3. Check “Cross Domain Security Enabled”

4. Enter the same credential for both UCM and SOA

d. Restart the servers

2. Enable UCM-BPEL Integration Component

a. Login to content server, navigate to the Admin Server

b. Select component manager for the server on which the component needs to be installed

c. Click on “Advanced Component Manager” and enable the BPELIntegrationComponent

d. Login to the Weblogic Administration console of UCM. Navigate to servers, select the UCM server and click Restart SSL.

3. Configure connection to SOA server

a. Navigate to Administration -> Oracle BPEL Administration -> Connection Configuration

b. From the “Connection Menu” select Add connection

Enter the following credentials

Note: The Provider URL contains the SOA server’s hostname and port. You can test this be running the wlst script in the SOA server and connect to t3://servername:[port]

c. Test the connection. If successful you should see the following screen. Revisit   steps 1 – 3 if there is an error.

4. Process Configuration

a. Navigate to Administration -> Oracle BPEL Administration -> Process Configuration

b. From the process menu select “Add Process”

c. Select the BPM/BPEL process from the drop down

d. Click Save

e. Go to Actions “Upload Payload”

Map the process input fields to the Metadata fields in UCM

   5. Update the SOA composite to enable UCM integration

a. Add the following line to Composite.xml in the SOA/BPM project as shown

<binding.adf serviceName="YourUniqueServiceName" registryName=""/>


       6. Configure Workflow in UCM

a. Login to content server

b. Navigate to Administration -> Admin Applets

c. Launch the Workflow Admin Applet

d. Add a new Workflow criteria


e. Click on edit criteria workflow. The following screen is where the event trigger condition is set. In this case the workflow will be triggered for Document Type that matches “Document”

f. Edit initiateprocess

              g. Add the users that have access to the workflow and document check in for which the workflow is triggered

h. Add the following lines under Exit conditions

wfGet("conversationId") and 
obIsInstanceClosed("BPEL", wfGet("conversationId"))


i. On Events tab click Edit for Entry. Add the line <$wfReleaseDocument()$> before <$endif$> to automatically approve the document. If you do not add this step the document state will be “Pending” and the user has to manually go to Content Management -> Active Workflows -> My Workflow Assignments to approve the document.

<$if not conversationId$>

7. Login as sysadmin ( the user from step 6) Check in a document of Type Document trigger               condition in step 6) and verify if the BPM/BPEL process is instantiated.

Trouble shooting

  1. Cross domain security – If the cross domain security is configured incorrectly you will see the following error:
vax.xml.ws.WebServiceException: java.lang.SecurityException: [Security:090398]Invalid Subject: principals=[weblogic, Administrators]
  at com.sun.xml.ws.client.dispatch.DispatchImpl.doInvoke(DispatchImpl.java:209)
  1. Enabling UCM System Audit to trace BPEL Integration related errors

Navigate to Administration->System Audit Information and add the BPEL integration component under “Tracing Sections Information”. Update and click “View Server Output” to view the detailed logs.

3. Complex Types as BPEL/BPM process input. With the current release of Webcenter Content ( UCM does not process the complex type as the process input and the “Update Payload” action will give and error. The work around is to use a simple type as input.



Thursday Feb 09, 2012

Writing Human Task User Interfaces in .Net

This post explores how to use the Human Workflow Services to write a Human Task User Interface using ASP.NET/C# and fully integrate it into the BPM Workspace application.



This blog was created to share bite sized bits of information picked up in the field by Oracle's team of solution consultants and engineers.Bon appetite! Locations of visitors to this page


« March 2015