Skip to main content
saifalik8679
Known Participant
Jun 21, 2023 1:06 PM UTC
Question

Foreign Key Implementation Error Because of DataType Mismatch

Hi All, I am getting a datatype mismatch erro when I am connecting and creating a fk from a pk from another table.
Each and every confirguation is same for both the columns except the following:

  • PK column is default none with auto increment
  • FK column is default null 

Can you please guide me on what mismatch I am missing as this is a usual case and easily implementable.

4 replies

stefanhelzle0001
Brainy
Jun 21, 2023 1:21 PM UTC

Did you try to find an answer outside of Appian as this is not an Appian issue?

sanchitg0002
Inspiring
Jun 21, 2023 2:20 PM UTC

Please check that you haven't given same foreign key name to multiple relations, if yes then make it unique. Also check that the data types are same in both tables.

saifalik8679
Known Participant
Jun 22, 2023 12:24 PM UTC

You got the right answer sanchit. Thanks for the directions.

sanchitg0002
Inspiring
Jun 22, 2023 12:39 PM UTC

Please consider marking the answer as correct so that anyone else having the same issue in future can find this working solution.