Question

4
Replies
42
Views
Close popover
Girish Tatikonda (GirishT2)
Lloyds
Engineer
Lloyds
GB
GirishT2 Member since 2016 1 post
Lloyds
Posted: September 8, 2020
Last activity: September 9, 2020

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

Pega Platform 7.3.1 Case Management Financial Services Lead System Architect