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
Replies
3 replies
Subscribers
10 subscribers
Views
1590 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Secondary Datasource Sucessfully validated after Upgrade to 16.3 but none of the tables are accessible
mohammedi
Certified Lead Developer
over 7 years ago
Hi All,
Has anybody came across an issue where successful validation of secondary datasource is logged and none of the tables, views and query results work.
Says Table or view doesn't exist, but I can use the same username password encoded and query the database.
OriginalPostID-262461
Discussion posts and replies are publicly visible
Parents
0
mohammedi
Certified Lead Developer
over 7 years ago
We figure out what is causing the problem but the solution has not been identified. Appian 16.3 converts username and table names to lower case and double quotes it, it is oracle case sensitivity problem. We used to use custom.teneo.properties now I am not sure what the solution is.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mohammedi
Certified Lead Developer
over 7 years ago
We figure out what is causing the problem but the solution has not been identified. Appian 16.3 converts username and table names to lower case and double quotes it, it is oracle case sensitivity problem. We used to use custom.teneo.properties now I am not sure what the solution is.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data