My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.