Why exposed embeded properties not read from table column instead they are read from blob
Hi All - I have a question regarding pega reading from blob those Embedded properties which are exposed and mapped on class definition rule's external mapping tab.
Up until now I was asuming that after exposing embedded properties in underlying work table and making sure External Mapping tab is updated properly pega would read those embedded properties from db column but recently I found it is not the case. I confirmed by refering embedded properties in Report Definition and the tracing the generated SQL which I still see using UDF functions to retrieve the values from blob. Can someone please explain why pega is not able to read the data from db column rather than blob using class's external mapping details.
Incessant Technologies
IN
Have you created Declare Index for embeded properties and joined the declare index to report definition? If so, the pega will retreive data from columns(embedded properties) in declare index table.
JPMC
US
Hi Manoj - This is not about declare Index. This is about working functionality of Embedded properties which are exposed and specified on Class rule's external mapping tab so that PRPC can save those values into these columns. If values are saved into the column using these external mapping then why not RD reading these from column?
Pegasystems
IN
RD does use the external mapping. To verify, can you please click on "Test Connection" on the class definition and also on the associated Data-Admin-DB-Table instance. If they show errors, try resaving the Data-Admin-DB-Table instance associated with this class.
JPMC
US
Hi - I tried clicking Test Connection and its not clean connection result in the sense that I have couple of columns of type CLOB, and test connection says that it is mapped to the intended db table but has usupported columns of type CLOB. Is this the reason it is not retrieving the exposed embedded properties(not clob type) mapped in external mapping tab from Blob rather than columns?
JPMC
US
Hi Rajeev/Aditya - I did try all the options mentioned including DB table instance save, rebuilding class mapping on all nodes but no luck.
Below is the Connection results:
Class Com-Dept-App-Work is mapped to table MySchema.pc_Mywork_Work in database PegaDATA.
This is an internal class. You may access the class with Obj- activity methods.
Issues:
 |
Class Com-Dept-App-Work is mapped to table MySchema.pc_Mywork_Work in database PegaDATA, which has column DETAILEXPLANATIONCLOB of unsupported type CLOB |
|
Class Com-Dept-App-Work is mapped to table MySchema.pc_Mywork_Work in database PegaDATA, which has column SUMMARYCOMMENTSCLOB of unsupported type CLOB |
JPMC
US
Hi Rajeev - This is a normal work table with additional(other than OOTB Prpc specific) columns exposed. If you still need the table definition then pls let me know your email address as I can not share it here on public forum.
Please find attached masked query with this reply. Please let me know if you need any more details, Thanks!
JPMC
US
Hi Rajiv - I didnt get chance to create SR for the same. If you recommend I can go ahead and create SR it is an issue but not show stopper thats why I have liberty to wait and research.