Hi,

Whether that table is available in PegaData schema or externally created one.

Please check the table has pxobjclass as an column.open the class and click test connectivity and see whether your mapping is correct.

Also try re-saving your Class and DB-Table instance .

@RAGHUNATHA

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.

@Bhavya:

I did that, but still this issue is not resolved.

Hi,

Please go through platform support guide -

https://collaborate.pega.com/discussion/prpc-5x-6x-platform-support-guide-easy-find

Adding  pxobjclass as an column and other px columns worked..

Hello ,

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".

just to add to my earlier post :-

as stated above by sarathkumark i have added all px related columns in teh table :- see below the table def 

CREATE TABLE public.sae2_hr_plan
(
pxcommitdatetime timestamp without time zone,
  pxsavedatetime timestamp without time zone,
  pxcreatedatetime timestamp without time zone,
  pxcreateopname character varying(128),
  pxcreateoperator character varying(128),
  pxcreatesystemid character varying(32),
  pxinsname character varying(128),
  pxobjclass character varying(96),
  pxupdatedatetime timestamp without time zone,
  pxupdateopname character varying(128),
  pxupdateoperator character varying(128),
  pxupdatesystemid character varying(32),
  "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

Hi ,

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