Mediator throwing incomplete BusinessFaultException

A while ago I ran into the issue that business fault information was not returned to the calling system by the Mediator component in the SOA composite. Instead, only a message that a business fault occurred was responded to the calling system. The response would look something like the below example:

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope">
	<env:Header/>
	<env:Body>
		<env:Fault>
			<env:Code>
				<env:Value>env:Receiver</env:Value>
			</env:Code>
			<env:Reason>
				<env:Text xml:lang="en-US">oracle.fabric.common.BusinessFaultException</env:Text>
			</env:Reason>
			<env:Role/>
			<env:Detail>
				<exception/>
			</env:Detail>
		</env:Fault>
	</env:Body>
</env:Envelope>

(more...)

Exadata Storage Server Patching in 18.1.1 and Above

One of the cool new features that was introduced with 18.1.0.0.0 was a subtle change in the Exadata storage server patching process.  While not required, this new functionality removes the need to use patchmgr to drive Exadata storage server patches.  In Juan Loaiza’s Open World session on new Exadata features, this slide jumped out to me:

While this slide may look like marketing fluff, this new feature turns out (more...)

CVE-2017-10151 Oracle Identity Manager Vulnerability

Oracle has released an out-of-cycle security advisory (CVE-2017-10151) for a vulnerability affecting Oracle Identity Manager.  This vulnerability has a CVSS 3.0 base score of 10 out of 10.  Oracle Identity Manager is the identity governance component within the Oracle Identity Management solution.  All supported versions of Identity Manager are impacted from 11.1.1.7 to 12.2.1.3.0.  Most likely 11.1.1.1 through (more...)

Python for Data Science – Importing CSV, JSON, Excel Using Pandas

Although I think that R is the language for Data Scientists, I still prefer Python to work with data. In this blog post, I will show you how easy to import data from CSV, JSON and Excel files using Pandas libary. Pandas is a Python package designed for doing practical, real world data analysis.

Here is the content of the sample CSV file (test.csv):

name,email
"gokhan","gokhan@gmail.com"
"mike","mike@gmail.com"

Here is the content of (more...)

I’m back, again, late 2017

Nothing much to say other then I'm back again, and hope to do some more blog posting soon. My excuse for the lack of posts is that I've been busy helping a client with a large data migration project. That is now over, with all the data successfully extracted for loading into their new system, so I've got more time available to properly write up some technical Oracle or performance posts.

How to Configure the Top 4 GSA Features in Mindbreeze – Plus 6 New Favorites

In the past few weeks, we’ve looked at why fishbowl chose Mindbreeze as a GSA replacement and how one of our GSA customers transitioned to Mindbreeze. Today I’ll share how to set up the most-used GSA functionality within the Mindbreeze InSpire enterprise search appliance.

Dynamic Navigation

The GSA’s Dynamic navigation enables users to refine a search using metadata attributes as filters. Within Mindbreeze this functionality is called Filter Facets. A default set of filters can (more...)

We -as a country- are no longer to be trusted?

Who Do You Trust? As legislation changed, Mozilla filed a bug with potential serious consequences. Check out bug 1408647. Removing the root certificate as trusted authority makes it look asif any certificate, issued by any of the Dutch PKI organizations, is potential unsafe. Which is correct, to a point, as the law allows the use of false keys by the Ducth autorities. Creepy. That makes the

The APPROX_MEDIAN Function – A Test Case

The aim of this post is not to explain how the APPROX_MEDIAN function works (you find basic information in the documentation) but to show you the results of a test case I run to assess how well it works.

Here’s what I did…

I started in the Oracle Database Public Cloud an instance of version 12.2.

Then I created a table with several numerical columns (the name of each column shows how many (more...)

Jarvis Pizzeria: Handle SOAP Faults within PCS

Uncategorized
| Oct 29, 2017
As we are very optimistic developer we started out with modeling and testing the happy flow of our Jarvis pizzeria. But as experience learns it is the big bad world that obliges us to deal with both expected and unexpected failures. This blog post we will look into the handling of SOAP faults that PCS has to offer out-of-the-box.


As a starting point we have created a basic process with one service call:
This SOAP (more...)

Tracing a session SQL in "Azure SQL"



With our 'cloud first' strategy we are trying to make use of Azure SQL for all of our databases as much as possible. This (as we have discovered) does come with a few things you need to be aware of as this is not 'normal' SQL Server - there are various things that are not there and quirks about the way some of the things work.

In a case this week we were having trouble (more...)

Ubuntu 17.10: problems with gnome extensions

After migrating to ubuntu 17.10 the unity desktop is gone and the system starts up with gnome 3.
As i wrote here, there are some problems with window decorations which can be fixed by (re-)moving some directories.

But i still had some problems with gnome extension:
The installation process via the webpage gnome extensions worked fine, but e.g. the system monitor did not show up...
https://extensions.gnome.org/

The solution was easy:
apt install vanilla-gnome-desktop
(more...)

nVision Performance Tuning: 4. Partitioning of Ledger, Ledger Budget, and Summary Ledger Tables

This blog post is part of a series that discusses how to get optimal performance from PeopleSoft nVision reporting as used in General Ledger.

Note: Partitioning is a licenced option in Oracle RDBMS, and is only available on Enterprise Edition.

nVision queries always contain single value predicates on LEDGER and FISCAL_YEAR.  They will also always have either single value predicate or a range predicate on ACCOUNTING_PERIOD.  Therefore, partitioning the ledger tables on these columns is an (more...)

PGConf.EU, Postgres Rocks!!

On a rainy Tuesday morning we set off on a Polish Airlines flight to Warsaw.
Our target: PGConf.EU with some of the biggest crew EnterpriseDB ever sent off.
Our goal: spread the love of EDB within the PostgreSQL community, where EDB is such an intrinsic part of.

The evening before the conference promises to be an interesting one. We have rented off the Hard rock Cafe in Downtown Warsaw for the kickoff of our (more...)

Testing network connectivity from Cloud Foundry Application Intances

This app below simply tests whether a host:port is accessible from a CF app instance. For example can my application instance access my Oracle Database Instance running outside of PCF given application instances need network access to the database database for example.

You can use bosh2 ssh to get to the Diego Cells if you have access to the environment or even "cf ssh" if that has been enabled.

GitHub URL:

https://github.com/papicella/cloudfoundry-socket-test

(more...)

Still Stuck on SiteStudio? Move Your Intranet and Modernize with WebCenter Portal

Fishbowl’s Enterprise Architect, Jerry Aber, contributed to this blog post.

Surprisingly, there are still many SiteStudio (Oracle WCM) customers out there using the product for their employee intranet. We just chatted with another one this week, in fact. I say surprisingly because even though the product is technically under support (extended lifetime) until 2019, there are so many advantages and benefits of upgrading a SiteStudio intranet to Oracle WebCenter Portal. Oracle themselves outlined a few (more...)

Oracle Database Docker Image in Docker Cloud (Digital Ocean)

Red Samurai is using Docker for our internal development environment. We are running Oracle Database and WebLogic server (with ADF support) on Docker Cloud. It is much easier to manager Docker containers than to maintain our own server.

In this post I will describe how to setup Oracle Database in Docker Cloud. Of course you could run Docker container locally on your machine, but main power of Docker comes with the option to be able (more...)

Hadoop for Database Professionals class at NoCOUG Fall Conference on 9th Nov

If you happen to be in Bay Area on Thursday 9th November, then come check out the NoCOUG Fall Conference in California State University in downtown Oakland, CA.

Gluent is delivering a Hadoop for Database Professionals class as a separate track there (with myself and Michael Rainey as speakers) where we’ll explain the basics & concepts of modern distributed data processing platforms and then show a bunch of Hadoop demos too (mostly SQL-on-Hadoop stuff (more...)

#GoldenGate Procedural Replication Support

With the release of Oracle GoldenGate 12c (12.3.0.1.x), came the support for Procedural Replication. This option is an enhancement to the integrated replicat which allows you to replicat Oracle-supplied PL/SQL procedures that cannot be replicated as DML or DDL.

Note: In order to replicate these packages and procedures, you need to be on Oracle Database Release 2 (12.2) an later and using the integrated extract and replicat.

To find out (more...)

2017 hroug – Croatia



I came to #hroug2008 and although I really enjoyed it there were not any english speaking presenters and I found that intimidating. However now the SiOUG and hroug events run back to back, it is very different.


The event is still held in Rovinj but now on an island at the Hotel Istra. To even get there you have to go by boat.

It is a beautiful setting complete with its own castle which is (more...)

prelink makes instance unusable

I spent a recent night hunting an issue which was non trivial to detect.
On a 4 node cluster 2 nodes got Linux patches and were rebooted. This was done after 10pm for minimal business impact. (The application is written by Oracle - so it's not fully TAF aware).
The DBs started fine, all services were available.
At 3:50 in the morning I got a call some processes show strange errors.
As I connected to (more...)