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****
Posted: 5 years ago
Optum
Optum
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://collaborate.pega.com/discussion/common-upgrade-questions
Thanks
Posted: 5 years ago
Cognizant
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: 5 years ago
Cognizant
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