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.

Discussion posts and replies are publicly visible

Parents

0 Sally Mason
Appian Employee
over 7 years ago

I'm surprised to hear you still have the property for "custom.teneo.properties" as it was used around Appian version 6.6 and was resolved. I would recommend cloning the secondary data source and seeing it you can correct the names from the Oracle side then remap in Appian to the cloned source? Alternatively, create a new datasource, remap all datatypes to it then via the database, merge the context from the existing ds with the issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sally Mason
Appian Employee
over 7 years ago

I'm surprised to hear you still have the property for "custom.teneo.properties" as it was used around Appian version 6.6 and was resolved. I would recommend cloning the secondary data source and seeing it you can correct the names from the Oracle side then remap in Appian to the cloned source? Alternatively, create a new datasource, remap all datatypes to it then via the database, merge the context from the existing ds with the issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data