Posted: 13 Dec 2015 8:11 EST Last activity: 14 Dec 2015 10:31 EST
Unexposed properties cannot be selected in classes mapped to external tables
I have seen this/similar issue in PDN with different work arounds. Is the error valid ? It generates the class fine and test connectivity also works.When I create a RD in the class and use one of the 3 columns in "Edit Columns" under Query tab,I get the error "Unexposed properties cannot be selected in classes mapped to external tables".
Can please some one explain why the error pops up ?
I was using postgres 9.5. I could map the external class to the table correctly and it reflected the number of columns and rows correctly. When I tried to refer the property in a RD,I got the error. The column names in DB was in mixed case,so I changed to all lower case as all other schema from Pega was in lower cases as well. It worked!!. I don't know why though.
Thanks for the details Premjit. In the Pega platform, the generated DDL or DML doesn't use quoted column names and are thus referenced in the default case of the database (lowercase for PostgreSQL, uppercase for Oracle and DB2 and mixed case for SQL Server). Thus changing it to lowercase for your PostgreSQL DB did the trick for you.