Question
creating external table for data types
we ceated a data type and then used pega generated DDL to get xternal table created & mapped to class. we did couple of modfications to generated DDL - dropped two columns PZPVSTREAM BLOB & PZINSKEY.
but now we are getting bellow error for all px, py, pz properties, are we doing something wrong ?
Class AA-CS-CSD-Data-Groups is mapped to foreign data table SCHEMA.pr_AA_CS_CSD_Data_Groups in database PegaDATA , but it contains a px, py, or pz property: pxCommitDateTime
***Updated by Moderator: Vidyaranjan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***
Hi Mohit,
We should not drop PZPVStream BLOB column as it is repository for all properties in a table. What is the primary key column for your table.
Thanks and Regards,
Prudhvi Ranjan
thanks Prudhvi for responding, we have created one id column and marked it as key and now we are are thinking to restore pzinskey and keep it as primary key.
Hi,
I am also facing the same issue in our application. Following is the error we receive, "Class AZ-FW-InsUW-Interface-PartyRoleMap is mapped to foreign data table AZURE_UK.T_AZ_PARTY_ROLE_MAP in database PegaRULES , but it contains a px, py, or pz property: pyID".
Can anyone please help me out?
Thanks,
Vignesh.
Hi, I am also facing the same issue. In my case its a Oracle view. How to resolve this issue? Due to this, the view is mapped as an external table and none of the listview and summary views are working fine. Any help is appreciated!!!
Hi Mohit,
we should not drop PZPVStream BLOB as it is repository for all propertiesin a table. What is the primary key column of the table.
Thanks and Regards,
Prudhvi Ranjan