Hi All,I've experienced an issue with the data store. After an upgrade to 22.4 we face the below error.
The data store "XXX" [id=0000] was saved but cannot be published: The data source schema does not match the type mappings: More than one table found in namespace (, ) :
Just to explain the background we're using synonyms for many db objects (because the target objects are in another schema that is not default for the Appian FID).
I've seen a comment from an Appian employee under below article that 'support for Oracle is coming in 22.4.'https://community.appian.com/discussions/f/data/10323/unable-to-find-table-or-view-for-oracle-dbDid anyone else have this problem? Any tips?
Thanks in advance!
Discussion posts and replies are publicly visible
We faced the same issue , please add schema attribute inside your xsd in your @table annotation . This should solve issue for you .