Question

3
Replies
64
Views
 Dinu Pankajakshan Raghavan (DPR2019)
Aig

Aig
US
DPR2019 Member since 2013 4 posts
Aig
Posted: June 11, 2019
Last activity: June 12, 2019
Posted: 11 Jun 2019 15:24 EDT
Last activity: 12 Jun 2019 7:59 EDT
Closed

DataOnly Upgrade -Question

Hi Experts,

Can you please let me know the tables getting impacted during the dataonly upgrade?What kind of opertation is happening during the dataonly upgrade?Are thre any change in workobject,worklist,workbasket,operators data?If there any data upgrade can you please let us know the exact table and the corresponding change?

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Data Integration 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 Question, please write a new Question.
Posted: 2 years ago
Posted: 12 Jun 2019 0:31 EDT
Srinivas Yoganarasimha (Srinivas21)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,


You can refer this post for the steps for data-only upgrade: https://community.pega.com/knowledgebase/generating-rule-schema-objects-and-upgrading-data


This post address most FAQs regarding upgrades: https://community1.pega.com/community/product-support/question/common-upgrade-questions


Thanks


 
Posted: 2 years ago
Posted: 12 Jun 2019 7:06 EDT
Vigneshwaran Aravindhan (VigneshAravind)
Cognizant
Senior Technology Architect
Cognizant
IN

Following are the tables typically modified by DataOnly upgrade scripts...












pc_assign_workbasket
pc_assign_worklist
pc_work
pc_history_work
pc_link_attachment
pc_link_folder
pr_data_admin
pr_sys_updatescache
pr_sys_statusnodes
pr_log_reportstats
Posted: 2 years ago
Posted: 12 Jun 2019 7:59 EDT
Vigneshwaran Aravindhan (VigneshAravind)
Cognizant
Senior Technology Architect
Cognizant
IN
Most PEGADATA tables would gain following two properties (or more)...


  • TIMESTAMP 7 PXCOMMITDATETIME

  • TIMESTAMP 7 PXSAVEDATETIME

Hence the relevant Indexes / Views / Store Procedures / UDFs would be updated.


Note UDFs help with retrieving data from blobs.


 


Also PEGA no longer users DB Triggers hence they will be dropped