Posted: 18 Mar 2021 11:17 EDT Last activity: 19 Mar 2021 10:22 EDT
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****