Facing issue while verifying the data store entity. Error message says that it is unable to find the table column or the table itself.
I tried creating the new table "NZ_Test" to my DB server and CDT of same table with new Data Store "NZ Test DS". Still getting the same error.
Note:- The test connections are successful with the data source.
Also, we had a version upgrade from 21.4 to 23.2 recently. Is this causing the issue?
Attaching the screenshot of CDT and Data Store for reference.
Discussion posts and replies are publicly visible
It looks like a platform issue with Appian for SQL Server specific version. Appian is not able to generate correct SQL scripts for automatic table creation/update. Also Appian is not able to map existing table correctly.