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
Discussion posts and replies are publicly visible
Did you try publishing the data store?
Otherwise, you can try to run the generated SQL script.
Yes I published Data store a well.But still getting same error.
Is there any way to solve that
Can you post the contents of the XSD file and also the structure of the table in the database?
Hi Mathieu,thanks for the reply if possible can you share me the correct steps to deploy CDT from one environment to other?
Usually just have to push and then publish the Data Store in the target environment.
I'm assuming there's a naming mismatch for the column but can't really tell without more information.
Okay I will explain you the total scenerio I have added one column to the CDT by new version of XSD in one environment.I haven't done anything in the Target environment so while deploying this modified CDT to target environment I am getting the above error.Do I need to do anything in target environment before deploying?
If you don't want the warning, you need to run the SQL to make the modifications to the DB. You can also publish the Data Store after deploying.
I have to run the alter SQL in target environment right to remove that warning?
Yes, please try to run the DB scripts first in the target environment before deploying the package consists CDT.
Thanks for the update Lavanya. Unfortunately I have run the DB scripts in target Environmnet after deploying the package to Target environment.Is it Cause any issue?
I guess without the DB scripts package will not deployed successfully, if it has deployed please try to verify datastore once.