Closed
PEGA 7.4 Update RULES schema failure with DB error
We are upgrading PEGA from 5.5 to 7.4 using split schema.
DBA created the RULES and DATA schemas. During the upgrade RULES schema process, we are getting -204 error while executing the following queries.
select count(*) as "count" from RULES.pr_log where pxObjClass = 'Log-SecurityAudit'
select count(*) as "count" from RULES.pr_data where pxObjClass = 'Data-Project-Task'
These tables are not created in RULES schema as they are DATA schema tables. My question is why Upgrade process is looking for a DATA schema table and how we can rectify this?
Please provide inputs on this issue.
***Edited by Moderator: Pooja Gadige to change category from Product to Update, change capability child tag***
To see attachments, please log in.
Posted: 2 years ago
MOD
Pegasystems Inc.
GB
@GuhanK91 please could you take a look at the following archived Support article?
ORA-00942 : on RULES.pr_data pxObjClass = 'Data-Project-Task'
Posted: 2 years ago
AIG
AIG
US
Thanks for your response. yes, system expects to create the table in both schema and we need to clean up the unwanted tables with the help of DBA.