Question

1
Replies
45
Views
Silvia Zicca (SilviaZ3)
Reply S.P.A.

Reply S.P.A.
IT
SilviaZ3 Member since 2019 15 posts
Reply S.P.A.
Posted: March 18, 2021
Last activity: March 19, 2021
Posted: 18 Mar 2021 11:17 EDT
Last activity: 19 Mar 2021 10:22 EDT
Solved

Error accessing database tables in external database

We recently migrated our application from Pega Platform 8.3.3 on premise to Pega Platform 8.5 on cloud environment.

We have a Database rule pointing to an external Oracle database and we had to switch from a JDBC connection pool connection to a JDBC URL connection. If we click the "Test connectivity" button on the Database rule, the result is Good.

Instead, if we click the same button on the database tables defined on that Database rule or we try to click Save on concrete classes related to those database tables, we get the following error:

Caused by: com.pega.pegarules.pub.database.DatabaseException: ERROR: relation "v$parameter" does not exist Position: 19: code: <none> SQLState: <none> Message: <none>

We don't get that error on the on premise environment which refers to the same database and database table rules.

How can we solve?

***Edited by Moderator Kayla to update Platform Capability tags****

 

Pega Platform 8.5.2 Case Management System Architect