Unable to access table without synonyms

himanshun over 7 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

0 mayureshs7821 over 7 years ago

@hinamnshun you mean to say you want to create CDT based on existing table? may I know which version of appian are you working on?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 himanshun over 7 years ago

mayureshs782, I am using 16.2. Yes I want to create a CDT on existing table without creating the synonym for it at DB
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mayureshs7821 over 7 years ago

@himanshun as per my understanding we no need to use schema name in xsd file. Can you try with below xsd configuration
<xsd:annotation>
<xsd:appinfo source="appian.jpa">@Table(name="your table name same as in DB")</xsd:appinfo>
</xsd:annotation>
hope this helps you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vijay over 7 years ago

@himanshun as per above post we don't need schema name in XSD. Since we will map schema name in datasource of datastore itself.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 himanshun over 7 years ago

@mayureshs782, I am also using the same annotations, however while verifying the DS it gives me the error mentioned in the query. Also I tried removing the schema name from the @Table annotation and the verify still gives the same error, this time without the schema_name
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mayureshs7821 over 7 years ago

@himanshun Can you attach xsd file and can you tell me your exact table name?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vijay over 7 years ago

@himanshun, Also you can also check is that particular table exist or not in that schema and same name have you given in XSD or not. So it can help you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Durgesh
A Score Level 2
over 7 years ago

Did you try something in XSD - @Table(name="<TABLE NAME>" schema="<SCHEMA>")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 7 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 6 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