Question

2
Replies
431
Views
AnnemarieZ Member since 2013 5 posts
msg systems
Posted: July 4, 2016
Last activity: August 2, 2016
Closed
Solved

Migration from Pega6.3 to Pega7.1.7 - DataMigration

Data Migration from Pega6.3 sp1 to Pega7.1.7.

We make not the in place migration, because we migrate from an Pega6 environment to the already existing Pega7 environment. On this Pega7 environment there are some products on the platform that work till more then 1 year.

Our application consist of a FW and 6 Layer. We have bulk Data (Workitems, assignments , attachment, ...).
We use following tool to import the data.
https://pdn.pega.com/exchange/components/data-migration-helper

We first create for the FW the select statements. Then change them so we can insert the selected data from Pega6 to Pega7.
Then we simulate an run of this script. In the logfile we find ORA-00947 error.

We have some shared tables which have new columns. We dont now what to write into this colums.

Has someone an overview/idea about new colums  (Datatype, length, ...) in Pega7.1.7 and what we need to write into.

The tables we identifyed: PC_ASSIGN_WORKBASKET; PC_ASSIGN_WORKLIST; PC_DATA_WORKATTACH; PC_HISTORY_WORK; PC_INDEX_WORKPARTY; PC_LINK_ATTACHMENT; PC_LINK_FOLDER; PR_ASSIGN; PR_DATA; PR_HISTORY; PR_INDEX_ASSIGNMENTDEPS; PR_INDEX_ASSIGNMENTSKILLS; PR_SYS_QUEUES; PR_SYS_QUEUE_SLA (see attached File)

Are there more tables we need to take under consideration?

may this issue also occur for values within blobs?

Kind regards

Annemarie

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