Skip to main content
P
premanandr344453
February 6, 2026
Question

Getting error when creating data store

  • February 6, 2026
  • 2 replies
  • 4 views

i am trying to create a data store , i have already created teh data type and i can see teh field from database , The data source schema does not match the type mappings: Schema-validation: missing table [`xxxx_LIST`] (APNX-x-xxx)

    2 replies

    S
    shivakanthreddyp0001
    February 6, 2026

    Which means table is not created or available in database. You can run the script manually or select generate table manually option while publishing your datastore.

    shubhama926776
    shubhama926776
    February 6, 2026

    Ensure the physical table xxxx_LIST exists in your data source's schema (matching CDT's @Table name exactly, case/schema-sensitive), or delete it and Verify data store to let Appian auto-create it.
    or
    Your CDT might contains a list field (multiple values).
    CDT list field requires xxxx_LIST child table (id, parent_id, list columns). Verify data store to auto-create or manually add it.

    Terms & ConditionsAccessibility statement