Question

15
Replies
91
Views
HarshanaD Member since 2010 1 post
EVONSYS
Posted: 9 months ago
Last activity: 9 months ago

Pega 8.2 Upgrade.sh execution fails due to ORA-00942: table or view does not exist

We are upgrading Pega 6.3 platform to Pega 8.2. We followed below steps.

  1. Pega 6.3 platform has single schema. Split current schema as rule schema and data schema(Current schema).
  2. Create DB users with privileges
  3. Configure migrateSystem.properties
  4. Run migrate.sh. Step was success.
  5. configure setupDatabase.properties with bypass schema generation and UDF generation as true.
  6. Run upgrade.sh without any parameter

Execution was failed due to following error message.

sql=SELECT pzInsKey AS "pzInsKey", pxObjClass AS "pxObjClass" FROM <Rule schema name>.pi_data_connect WHERE pxObjClass = 'Data-Admin-Connect-DSM-EventCatalog', OriginalSql = SELECT pzInsKey AS "pzInsKey", pxObjClass AS "pxObjClass" FROM <Rule schema name>.pi_data_connect WHERE pxObjClass = 'Data-Admin-Connect-DSM-EventCatalog', Error Msg = ORA-00942: table or view does not exist

For the time being I copied pi_data_connect table in data schema to rule schema and continue upgrade script execution. Finally we created pi_data_connect, pr_data, pr_data_file, pr_index, pr_operators, pr_sys_locks, pr_sysstatusnodes, pr_sys_updatecache, pr_data_sample_uidetails, pr_data_samplesrcustomer, pr_data_samplesrproduct, pr_data_samplesrpurchase, pr_data_sample_shoppingcart tables with data in rule schema to continue upgrade.

Please let me know, anyone face this issue before? Is this proper way to continue upgrade?

***Edited by Moderator Marissa to update SR Details***

Low-Code App Development Upgrades SR Created
Share this page LinkedIn