Question
Error while upgrading from 7.1.8 to 7.2.2
We are doing an upgrade from 7.1.8 to 7.2.2. We are getting error while upgrading. Error states "view not found". We tried dropping the views from PEGA_DATA but then the same error occurred in PEGA_RULES. The user has the right privilege and role as mentioned in the guide.
PFA logs and screenshots
Yes the view exist in the schema PEGA_RULES we double checked. But I get this strange comment/warning on the first line of SQL of view:
"-- Unable to render VIEW DDL for object PEGA_RULES.PWB4_CIRCUMSTANCE_DUPLICATES with DBMS_METADATA attempting internal generator"
I don't know if this has to do something with the error.
Accepted Solution
We found the solution to the error:
SELECT_CATALOG_ROLE should be the default role.
Could you please log in directly to the database and list all the available views? Please check if the view PWB4_CICRUMSTANCE_DUPLICATES exist in schema PEGA_RULES.