RDB methods are failing with table or View doesnt exists wheras OBJ rules are working without any issues
We have an application hosted on Pega 7.3.1 with Oracle 11g Data base . We did a Data Base only upgrade to Oracle cloud 12 CR2 where the whole Data and rules Schemas were exported and imported directly into cloud 12Cr2.
Post that , we are able to launch the application and all other transactions are working but RDB methods are failing with the below errors
"There was a problem getting a list: code: 942 SQLState: 42000 Message: ORA-00942: table or view does not exist"
We are using RDB rules for few of the tables under the PegaData Schema to browse/ Save /Delete. we were told by DBA that those tables exists on PegaDATA schema.
i suspect its an issue with grants but DBA confirmed PEGADATA has required access on those tables.
Is there anyway we can resolve this issue.
Attaching the log trace below.
Error in RDB-Delete
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 942 SQLState: 42000 Message: ORA-00942: table or view does not exist