Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Avinash Haridasu (Avinash.Haridasu)
Morgan Stanley

Morgan Stanley
IN
Avinash.Haridasu Member since 2014 306 posts
Morgan Stanley
Posted: May 30, 2016
Last activity: Jun 14, 2016
Posted: 30 May 2016 6:23 EDT
Last activity: 14 Jun 2016 11:26 EDT
Closed

Q: Understand working of the PRPC Schema Report

I'n just curious to know how the functionality of Upgrade Rule Tables and Upgrade Data tables work.

Lets say i have created a couple of tables for Data- classes and now pega has come up with two new properties pxCommitDatetime and pxSavedatetime..

How does it know that my tables does not have these two columns. From what source are the implementation layer tables are compared..

Capture.PNG

To see attachments, please log in.
Pega Customer Service

Posted: 8 years ago
Posted: 1 Jun 2016 2:52 EDT
Avinash Haridasu (Avinash.Haridasu)
Morgan Stanley

Morgan Stanley
IN

Thanks for the link swati.

How does prpc know that some columns are missing in the Data- descendant class tables. When you say pxsavedatetime is missing... how does it know that this column is missing and where we define that pxsavedatetime is requied.

What is the baseline/source using which prpc compares the structure of these tables..

Capture.PNG

To see attachments, please log in.
Posted: 8 years ago
Posted: 1 Jun 2016 4:21 EDT
Swati Damele (dames)
Tetrasoft India Private Limited
Module Lead
Tetrasoft India Private Limited
IN

Hi Avinash,

I would suggest you to tag Engine team also here.

They may give some detailed insights for this.

To see attachments, please log in.
Posted: 8 years ago
Posted: 13 Jun 2016 10:41 EDT
John Peterson (JohnPeterson)
PEGA
Senior Director of Cloud Engineering
Pegasystems Inc.
US

How does prpc know that some columns are missing in the Data- descendant class tables. When you say pxsavedatetime is missing... how does it know that this column is missing and where we define that pxsavedatetime is requied.

What is the baseline/source using which prpc compares the structure of these tables..

Hi Avinash,

The recommended columns are the ones defined on the root tables.  For Data- classes, it's pr_data, Work- it's pc_work, for rule tables is pr4_rule, etc.  We only consider columns that we provide, so customer & application specific properties will be ignored.

To see attachments, please log in.
Posted: 8 years ago
Posted: 14 Jun 2016 2:24 EDT
Avinash Haridasu (Avinash.Haridasu)
Morgan Stanley

Morgan Stanley
IN

Thanks John..

Lets say i have a class PegaMYFW-Data-AppointmentReasons connected to DB table pr_PegaComm_FW_NBAMCFW_Data_Ap.. So when i access the PRPC Schema Report landing page will it compare the column metadata of both the base table (pr_data) and pr_PegaComm_FW_NBAMCFW_Data_Ap and then tell us what columns are missing?

Would it check all the classes descending from Data- and then Rule-?

Thanks in advance.

Avinash

To see attachments, please log in.
Posted: 8 years ago
Posted: 14 Jun 2016 11:26 EDT
John Peterson (JohnPeterson)
PEGA
Senior Director of Cloud Engineering
Pegasystems Inc.
US

Lets say i have a class PegaMYFW-Data-AppointmentReasons connected to DB table pr_PegaComm_FW_NBAMCFW_Data_Ap.. So when i access the PRPC Schema Report landing page will it compare the column metadata of both the base table (pr_data) and pr_PegaComm_FW_NBAMCFW_Data_Ap and then tell us what columns are missing?

No.  Just pr_data, assuming Data- is an ancestor.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice