Hi All,We have an issue while trying to publish the Data Store.Couple of points to give you a background:
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
Hi,This is more like Database issue, can you take the backup of your schema, and recreate it again and then verify/publish the datastore.
That's a problem after Appian introduced direct support for synonyms. This leads to situations where Appian "sees" the table and its synonym and then throws this error message. I think you will have to solve this on the DB side. Maybe by renaming the table, while keeping the synonym.
Thanks a lot . We're considering that however changing the names of the tables may impact db views that refer those tables... but we'll figure it out.Thanks a lot for suggestion.Interesting note is that if the default schema is properly set for the user (the schema that carries all the actual objects) even with public synonyms of the same name Appian 22.4 ignores that :)