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 APRIL 23, 2019

Applies to:

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


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"


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

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