Posted: 15 Dec 2019 11:25 EST Last activity: 14 Feb 2020 3:06 EST
Column not exposed error - Obj Operations with External Table
I have created an external table in My SQL and created corresponding class and properties using external class db mapping wizard. However , I am not able to do any Obj- operations on the table as I am getting "columns not exposed error". but the columns are shown mapped to properties in the external class db mapping properly. can somebody help?
Yes..property values are populated and i could see them in clipboard on the corresponding page. But while trying to do the obj-save of that page to external table, property not exposed error occurs, however the key property mentioned in the class definition is exposed column in the table.
Can you post the mapping details to see if you've configured the class key, column property naming correctly.
Also in case if you are not already aware, for any change you make to your external table, you should do a save of the Database Table data instance for the changes to reflect in Pega.
Posted: 11 months ago
Updated: 11 months ago
Posted: 14 Feb 2020 3:04 EST Updated: 14 Feb 2020 3:06 EST
I met the same error and solved it by rename column in database with a capital letters (so instead of ValueName column I create VALUENAME column)
If you have property ValueName (and if you even in external mapping use column in db as ValueName, see externalEx.png for example) pega will look for VALUENAME column in DB (but in DB you have only ValueName column), probably it's your case?