Posted: 24 Feb 2016 8:09 EST Last activity: 6 Apr 2018 19:26 EDT
tables missing error for running migrate script
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.
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');