I'm facing a little weird issue. I'm using oracle DB for my application. The Data verification passed easily in the datastore. However, when I query the DB using query entity it is unable to read the data. When I checked in the logs, it tells me Table or View not found.
There is one catch here in the oracle DB, when I want to access the tables, I need to add SYNONYM before the table names in the query, then I can access it.
Any help will be appreciated.
Discussion posts and replies are publicly visible
we are facing the same issue - we created Synonyms for the table which data we required. But appian is not able to read to synonyms and getting error while creating the data type where we are not getting any table name for selection. Any suggestion?
Support for Oracle synonyms is coming in 22.4 which will be released Nov 11.
© 2023 Appian. All rights reserved.