One of my customer has Oracle DB and synonym created in it. We need to look up this via an external class mapping. Web application is Apache Tomcat. Pega version 8.6. Hosted in AWS. PegaRules/PegaData is in PostgreSQL.
I have tried to add includeSynonyms=true param in Context.xml. While restarting the server, Pega is ignoring this element saying not a valid key word. This configuration is mentioned in Unable to use synonyms for NBAM schema | Pega
Is there a solution to this or Pega can’t pick the synonyms yet?
Hello @Subhankar G
Did you check out a similar support article related to synonym topic?
Thank you!
@PoojaGadige Yes, please read through my original post. I have already tried it.
It is not working -
org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory.getObjectInstance Name = Ignoring unknown property: value of “includeSynonyms=true” for “connectionProperties” property
@Subhankar G The issue was not with Synonym. Enable optimization was the root cause for this problem. Please follow the steps mentioned in the article to resolve the issue -