Tuesday Jan 13, 2015

Repository Creation Utility, MDS and Schema Versions

Introduction

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-11.1.1.8.0.201110211138-10.3.6-win32.exe) 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
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521/XE
User=XE_MDS
Password=********
SQL Test=select 1 from schema_version_registry where
				owner=(select user from
				dual) and mr_type='MDS' and
				version='11.1.1.6.0'

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 11.1.1.6.0. In my prior installation of WebCenter I installed BPM 11.1.1.7.0 and that had installed several schemas that had a version number 11.1.1.7.0. 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 11.1.1.7.0 but I needed an RCU for 11.1.1.6.0. If found that the 11.1.1.6.0 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 11.1.1.6.0 you need to use the correct RCU.

Tuesday Mar 13, 2012

BPM 101 Series: Collaborative Process Modeling using MDS, Composer and Jdev

MDS is the metadata repository used by many pieces of the Oracle Fusion Middleware product stack.  There are times when you can combine MDS repositories but for the most part these repositories exist to support their individual pieces of the stack.  In the context of BPM the MDS repository is used as a means to share project artifacts and attributes between the web based composer environmnet and jdeveloper.  Jdeveloper is geared towards the developer while Composer is geared towards process analysts and business users.  It should be stated that the statement of direction for Composer is to grow  the functionality and include much more in terms of functionality and satisfaction of use cases.


That brings us to our need to share between the composer and jdeveloper environments.  a generic slide that has been referenced often is the ability to continuously develop and refine the process models using collabortion between business owners, process analysts, developers and other stakeholders.

social bpm

Using the Composer Space within Webcenter Spaces is one way to collaborate around process models and can include various stakeholders to the process.  The use case referenced here is the sharing of composer models between the web based composer application and jdeveloper.  From within Jdev you can create a connection to MDS and use that connection to push and pull versions of the process model that may get implemented in Jdev.  A simple use case could involve the first cut of a process model that now needs to have a simulation run on it from within Jdev.  A developer would need to create a connection to the MDS repository and pull down the process models and then create simulation artifacts and run simulation against that candidate process model. 

The two main connection resources that need to be created in Jdev are the application server connection and the actual MDS database connection.  Once you wrap the MDS db connection with an mds resource configuration piece you can easily pull down existing projects and snapshots to the local Jdev environment.

       mds db connection
+     mds resource configuration
+     application server configuraton
= ------------------------------------------
      mds_resource_pallette_connection

Below are the steps to create an MDS connection:

1. Select to view the MDS Navigator by clicking on View > MDS Navigator.

2. Click on the 'Configure Connection' icon.


3.  Click on the add symbol to create a new MDS Connection 

4. Specify a name for the new connection and click on the plus sign if you are not yet connected to your WLS application server instance.

5.  Specify a name for your app server connection.

6. Specify the username/password for the WLS server.  In a dev environment this should probably be an administrator on the WLS server. Click next.

7.  Enter your hostname, port and domain name.  Click next.

8. Test your connection. Click next after receiving 'success' for all 9 tests.

9. Click 'Finish'

10.  You are returned to the 'New BPM MDS Connection' panel.  Click the 'add' symbol in the 'SOA MDS' location.

11. A new panel opens.  Name your SOA mds connection and click on the 'add' symbol in the DB Connection section.

12. A new panel opens to create a database connection to your DB instance hosting the MDS schema.  Input connection information and click 'Test' to test the connection.  Once complete click 'Ok'.

13. The new connection should now show up on the 'Create SOA-MDS Connection' panel.  The obpm partition should also show up automatically in the 'Select MDS partition' section.  Test the connection by clicking the 'Test Connection' button. Click 'Ok'.

14. You should now see your create connection name, application server and soa MDS connection name showing in your original BPM MDS Connection panel.  Click the 'Test' button.  Upon success click 'Ok'.

15. Click 'Ok' on your original 'Configure Connection' panel. 

16. Congratulations! You now have Composer projects that you can 'check out', 'export' or otherwise interact with.

Our next BPM 101 series article will go into the use case scenarios for securing and sharing BPM Composer projects between Business Analysts and Developers.




About

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

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today