Discussion
Cognizant
IN
Last activity: 6 Apr 2018 19:26 EDT
Rule-Obj-FieldValue & System-Updates-Cache DB Mapping Issues
Post Pega7 upgrade we made some observations in the following two classes
- Rule-Obj-FieldValue
- System-Updates-Cache
These observations were made in both PEGA 7.1.8 and PEGA 7.1.9 (Recently we upgraded two different applications to these MLs).
Please verify the errors we observed below and let us know if we can ignore these ?
To reproduce >>> Click the Test connection button in the concerned class rule form.
Rule-Obj-FieldValue
- Class Rule-Obj-FieldValue is mapped to table RULES_SCHEMA.pr4_fieldvalue in database PegaRULES , which has column PYLOCALIZEDVALUE of unsupported type CLOB
System-Updates-Cache
- Class System-Updates-Cache is mapped to foreign data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA , but it contains a px, py, or pz property: pxCommitDateTime
- Class System-Updates-Cache is mapped to foreign data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA , but it contains a px, py, or pz property: pzClearCacheType
- Class System-Updates-Cache is mapped to external data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA , but the column PZCREATEDATETIME does not have the corresponding Rule-Obj-Property PZCREATEDATETIME
- Class System-Updates-Cache is mapped to foreign data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA , but it contains a px, py, or pz property: pzKeyString
- Class System-Updates-Cache is mapped to foreign data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA , but it contains a px, py, or pz property: pzNodeName
- Class System-Updates-Cache is mapped to external data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA , but the column PZOBJCLASS does not have the corresponding Rule-Obj-Property PZOBJCLASS
- Class System-Updates-Cache is mapped to external data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA , but the column PZPARAMETERS does not have the corresponding Rule-Obj-Property PZPARAMETERS
- Class System-Updates-Cache is mapped to external data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA , but the column PZSYSTEMNAME does not have the corresponding Rule-Obj-Property PZSYSTEMNAME
- There is a key mismatch: the keys defined for class System-Updates-Cache do not match the primary key columns for external data table DATA_SCHEMA.pr_sys_updatescache in database PegaDATA ; the class keys are [pxSystemName, pxNodeName, pxCreateDateTime] , but the table's primary keys are []
|
|
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Scotiabank
CA
Hi Vignesh
The issue related to "Rule-Obj-FieldValue" is a known Pega issue, PFB the url with more details.
https://community.pega.com/support/support-articles/unsupported-data-type-clob
I checked one of our upgraded instances, same issue is there. The resolution which is provided is "CLOB (Character large object) is not an officially supported data type by Pega Platform. Perform the following local-change: use a supported data type, such as VARCHAR2", however as this is a system created table, Pega should automatically apply the changes during upgrade.
Secondly pr_sys_updatescache is used for rule changes that are recorded in this table for synchronization to other PRPC server by the System Pulse in a multi-node environment. We have also checked and found that this issue persist in one of our environment. It looks like a issue with Pega.
Regards,
Sandeep
Cognizant
IN
Thanks Sandeep.
We took care of errors in "Rule-Obj-FieldValue" by converting PYLOCALIZEDVALUE from CLOB to VARCHAR2
As such "System-Updates-Cache" still has errors and we have not addressed it yet.