Yeh my table is in PegaDATA database and schema is "personaledition", i have created using pgsql. my table doesn't contain pxobjclass column. i have tested using test connectivity it is mapped to my table correctly.
I have created a table in external database . and mapped to the same using External Table class Mapping .now when i create a report def on the class that is mapped, it is not allowing me to save ,and the error i see is
Unexposed properties cannot be selected in classes mapped to external tables".
this is working now..I see that it not required to create ant px..related objects . The only issue i had is while defining columns some how i has "" on the column names .I drooped the table and recreated with correct semantics .Now it is working as expected .
CREATE TABLE public.sae2_hr_plan (
ID character varying NOT NULL, NAME character varying, TYPE character varying, DESCRIPTION character varying, EMPLOYEE_COST numeric, CONSTRAINT sae2_hr_plan_pkey PRIMARY KEY (ID ) ) WITH ( OIDS=FALSE ); ALTER TABLE public.sae2_hr_plan OWNER TO pega
it's an issue with postgreSQL when you use pgAdmin to create table & columns with all upper case letters. Don't use all upper case letters for column names while creating tables with pgAdmin in postgreSQL.