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
By default appian does'nt allow two different schema in one datastore. it's recommeded to have other datastore for other schema
We faced the same issue , please add schema attribute inside your xsd in your @table annotation . This should solve issue for you .