Posted: 26 Sep 2016 14:20 EDT Last activity: 26 Oct 2016 9:19 EDT
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.
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?
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.
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?
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!