My Oracle Support Banner

BAM 12c : For an External DIM DO, when changing column name, a Java.sql.SQLException is generated (Doc ID 1995791.1)

Last updated on JULY 27, 2015

Applies to:

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

Symptoms

After applying patch 20494863, when creating an external data object a radio button appears for selecting "fact" or "dimension".
If you choose "dimension" and the configuration tabs you are able to modify the display name of the columns.
After changing the name to something more friendly and when attempting to populate the data a pop-up window with the following error will display:

              java.sql.SQLException: Invalid Column Name

in the bam_server1-diagnostic.log the following ERROR is generated:

 

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!


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