Support Article
Unable to use synonyms for NBAM schema
SA-11924
Summary
Unable to use Synonyms for NBAM schema in our environment. Connection is established but it says NBAMEXTERNAL.DEMO_CUSTOMER has no columns.
Error Messages
Class DEMO-DSM-Int-CustomerData is mapped to a table with no columns
Steps to Reproduce
Do a test connection for a Database Table rule mapped to a Synonym
Root Cause
The connectionProperties includeSynonyms=true was not getting picked.
Resolution
This issue is resolved through the following local change in three places:
Step 1: Map "use configuration in preferences" in Database rule corresponding to NBAM Schema:
Step 2: Add the below highlighted entry in prconfig.xml:
Step 3: Add the below DataSource entry (notice connectionProperties) in the context.xml of tomcat:
After above changes and restarting the server/node, reported issue was resolved.
Published July 12, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.