tables missing error for running migrate script
Hi,
We are upgrading our Pega 6 application to Pega 7. As a part of upgrade we migrated from mssql to Oracle database. Current multiple application stack to same infra and assessment scope to segregate one app without any framework. When we ran migration script for split schema rule, we got errors for missing tables starting with "pca_". Normally pca_ tables are related to CPM framework. How we can proceed in this scenario?
**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.
AIG
US
Migration script has defined algorithm to search rule, system, index table(OOTB, application specific) from Data-Admin-DB-Table. since your current application doesn't have dependency of CPM. You have 2 option to resolve -
1. Create explicit tables which migration script is looking, so script can find table and migrate to new rule schema
2. Remove DADT table mapping entries temporary from table, so system will not look for CPM rule related tables
select pyclassname,pydatabasename,pytablename,PZINSKEY from pega.pr4_base
where pxobjclass='Data-Admin-DB-Table' and pytablename in ('tablelist');
Rabo Bank
NL
Hi we resolved issue. We did following steps
1. Checked logs to find the tables which are missing.
2. Temporarily created those tables manually to move ahead with migration.
3. Now we are planning to remove those tables again.