When attempting to verify data store mappings for a data store containing a parent CDT with PK type char() and a child CDT with FK type char() the following error occurs:
The data source schema does not match the type mappings: Wrong column type in <CDT_NAME> for column <FOREIGN_KEY_COLUMN>. Found: char, expected: nvarchar(255) (APNX-2-4056-000)
This issue has been reported to the Appian product team. The reference number for this issue is AN-85413.
Edit the data source and the CDT in Appian to type varchar(x) as opposed to char(x).
This article applies to all versions of Appian.
Last Reviewed: May 2017