Question
3
Replies
58
Views
Posted: June 11, 2019
Last activity: June 12, 2019
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: 1 year ago
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: 1 year ago
Most PEGADATA tables would gain following two properties (or more)...
- TIMESTAMP7PXCOMMITDATETIME
- TIMESTAMP7PXSAVEDATETIME
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
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