Skip to main content
May 26, 2023
Question

Hi all I added new column to CDT by new version of XSD but getting this error when I tried to move that CSD to other environment

  • May 26, 2023
  • 14 replies
  • 0 views

The data store "ISR Data Store" [id=163216, uuid=_a-0000e3b5-3910-8000-9ba5-011c48011c48_35304] will be saved, but will not be published: The data source schema does not match the type mappings: APNX-2-4056-000{Schema-validation: missing column [fundingSource] in table [`ISR_StudyMedicalReview`]} (APNX-2-4053-006

Here:ISR Data store in Data store object,

 fundingSource is new column,

ISR_StudyMedicalReview is CDT.

When I tried to move to another environment during inspection I am getting this error .How can I solve this?

Thanks

    14 replies

    mikes0011
    Brainy
    May 26, 2023

    This error is usually caused by the SQL DB table in the target environment not yet being modified to reflect the new column (as noted in the error message you posted).  Can you verify whether the DB in the target environment correctly shows that column already?

    The Expression Guru
    May 27, 2023

    in the source environment I have made changes to CDT.So in the Target environment those updated column is not yet updated. So for that only I am deploying from source.

    IF possible, can you please explain me the correct steps for deploying CDT from  one environment to other?

    mikes0011
    Brainy
    May 30, 2023
    correct steps for deploying CDT from  one environment to other

    You need to deploy any changes to the table / columns directly to the target environment's Database, and then deploy the updated CDT.

    The Expression Guru
    mathieud0001
    Brainy
    May 27, 2023

    Did you try publishing the data store?

    Otherwise, you can try to run the generated SQL script.

    [View:https://docs.appian.com/suite/help/23.2/Data_Stores.html]

    May 27, 2023

    Yes I published Data store a well.But still getting same error.

    Is there any way to solve that

    mathieud0001
    Brainy
    May 27, 2023

    Can you post the contents of the XSD file and also the structure of the table in the database?