Skip to main content
A
arshbirs0002
December 3, 2021
Question

Data Store Error - The data source schema does not match the type mappings: Missing column: a_id in "TABLE NAME" (APNX-2-4056-000)

  • December 3, 2021
  • 3 replies
  • 0 views

I have created a CDT and it has passed a verification too.

But when I try to insert that in the Data Store it throws below error:

The data source schema does not match the type mappings: Missing column: a_id in "table_name" (APNX-2-4056-000)

Please help

    3 replies

    stewart.burchell
    stewart.burchell
    December 3, 2021

    If you're trying to write data to a table using Appian the CDT needs to define one of the attributes as a Primary Key. The message you are getting is saying you do not have this defined as there MUST be a Primary Key defined for every table you're mapping to from Appian.

    A
    arshbirs0002Author
    December 3, 2021

    So I was adding a view, I need to put a primary key in a view, right?

    stewart.burchell
    stewart.burchell
    December 3, 2021

    AFAIK you cannot write to a VIEW. But yes, even a VIEW should have one of the columns defined as a Primary key.

    Terms & ConditionsAccessibility statement