Skip to main content
andrzejh0002
February 28, 2023
Question

Data Store Issue ] ORACLE ] More than one table found in namespace (, ) Appian 22.4

  • February 28, 2023
  • 2 replies
  • 0 views

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-db



Did anyone else have this problem? Any tips?

Thanks in advance!

2 replies

srinivast0001
March 16, 2023

By default appian does'nt allow two different schema in one datastore. it's recommeded to have other datastore for other schema

March 16, 2023

We faced the same issue , please add schema attribute inside your xsd in your @table annotation . This should solve issue for you .