Discussion

2
Replies
466
Views
Vigneshwaran Aravindhan (VigneshAravind)
Cognizant
Senior Technology Architect
Cognizant
IN
VigneshAravind Member since 2007 28 posts
Cognizant
Posted: June 15, 2016
Last activity: April 6, 2018
Posted: 15 Jun 2016 11:26 EDT
Last activity: 6 Apr 2018 19:26 EDT
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.

System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.