Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+1
person also asked this
people also asked this
Replies
10 replies
Subscribers
7 subscribers
Views
7892 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
Unable to access table without synonyms
himanshun
over 8 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
OriginalPostID-270142
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 8 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
Reply
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
Children
No Data