BAM 11g: External Data Source not Available if Parameter Dialog Box is Closed: "SQLEXCEPTION_NULL_NULL_NULL"
Last updated on NOVEMBER 19, 2012
Applies to:Oracle SOA Platform – BAM (Business Activity Monitoring) - Version 18.104.22.168.0 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"
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