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 MARCH 16, 2019

Applies to:

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


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:



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.