BAM 12c : For an External DIM DO, when changing column name, a Java.sql.SQLException is generated
Last updated on JULY 27, 2015
Applies to:Oracle BAM (Business Activity Monitoring) - Version 220.127.116.11.0 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:
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