You are currently reviewing an older revision of this page.

KB-1346 Char() datatype does not map as a foreign key

Symptoms

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)

Cause

This issue has been reported to the Appian product team. The reference number for this issue is AN-85413.

Action

Edit the data source and the CDT in Appian to type varchar(x) as opposed to char(x)

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: May 2017