Question

15
Replies
205
Views
Close popover
Harshana Dilanka Dissanayake (HarshanaD)
EVONSYS

EVONSYS
NL
HarshanaD Member since 2010 1 post
EVONSYS
Posted: December 24, 2019
Last activity: December 27, 2019
Closed

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***

System Administration Upgrades Support Case Created
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.