BAM 11g: External Data Source not Available if Parameter Dialog Box is Closed: "SQLEXCEPTION_NULL_NULL_NULL" (Doc ID 1506080.1)

Last updated on NOVEMBER 19, 2012

Applies to:

Oracle SOA Platform – BAM (Business Activity Monitoring) - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

A data object uses an external data source.
The report is using prompt parameters in order to filter the information.
When the report is opened, if the parameter dialog box is closed using the 'X' icon on the window, the data source becomes unavailable.

The message "SQLEXCEPTION_NULL_NULL_NULL" should appear in the report with a "Details" link.
The link should show the exception detail as "Exception Message: invalid column index".
All further attempts to open reports using the data object also fail with the message "SQLEXCEPTION_NULL_NULL_NULL"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms