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

Certified Senior Developer

Hi All,

We have an issue while trying to publish the Data Store.

Couple of points to give you a background:

  • Appian User is not assigned with proper Default DB Schema - the schema where all of the tables and views are held - (Therefore we're using Synonyms)
  • After upgrade to Appian 22.4 we're unable to Verify / Publish the data store

We have found the workaround by adding schema  annotation to all CDT XSD <xsd:appinfo source="appian.jpa">@Table(name="TABLENAME", schema="SCHEMA").

This workaround fails however when the CDT in question has 'primitive array'. In such case Appian creates a related table for the 'array' field.
Because those tables were created in another schema we now cannot publish the entire Data Store.

We have multiple such tables, therefore we would appreciate any help (Other than changing the default schema - which is currently not an option in our business case).

Can you please advise if you have a solution for that issue?

Thanks,

Andrzej

  Discussion posts and replies are publicly visible

Parents Reply Children