Support Article
Unable to use synonyms for NBAM schema
SA-12880
Summary
Unable to use synonyms for NBAM schema. Connection is established but an error message is displayed stating that, NBAMEXTERNAL.DEMO_CUSTOMER has no columns.
Error Messages
Class DEMO-DSM-Int-CustomerData is mapped to a table with no columns
Steps to Reproduce
Test Connection for a database Table rule mapped to a Synonym.
Root Cause
The connectionProperties, includeSynonyms, property setting was not picked.
Resolution
This issue is resolved through the following local-change:
1. Map "use configuration in preferences" in Database rule corresponding to NBAM Schema.
2. Add the below highlighted entry in prconfig.xml:
3. Add the below DataSource entry (notice connectionProperties) in the context.xml of tomcat:
4. Restart the server or node.
Published August 14, 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.