Discussion

2
Replies
450
Views
VigneshAravind Member since 2007 28 posts
Cognizant
Posted: 4 years ago
Last activity: 4 years 3 months ago
Closed

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.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn