Unable to access table without synonyms

himanshun over 6 years ago

Hi All,

Is there any way to map xsd to existing table without creating synonyms? We tried giving <schema name>.<table name> in XSD but it gives error.

Below is the error we are getting.
The data source schema does not match the type mappings: Missing table: <SCHEMA_NAME>.<TABLE_NAME> (APNX-2-4056-000)

The user is having grants for this table.

Thanks is advance.

Regards,
Himanshu

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 6 years ago

Take a few minutes to read why this is happening docs.appian.com/.../kb-1111.html

If you don't want to create schemas, lowercase the schema name in your database. Review the article for all options.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jraaquino over 5 years ago in reply to Eduardo Fuentes

Eduardo Fuentes (eduardo.fuentes) The link you provided is no longer working.
Is appian still converting the schema name in @Table annotation to lower case?

We're having issues reading from the database because the schema name is converted to lower case and in our DB the schema name is in upper case.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 jraaquino over 5 years ago in reply to Eduardo Fuentes

Eduardo Fuentes (eduardo.fuentes) The link you provided is no longer working.
Is appian still converting the schema name in @Table annotation to lower case?

We're having issues reading from the database because the schema name is converted to lower case and in our DB the schema name is in upper case.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data