I am using 'Compare and Deploy' feature to export package from one environment to deploy it into another environment. At 'Inspect package step, I am facing the below warning:
The data store “abc” [id=, uuid=_a-0000e247-b746-8000-9ba2-011c48011c48_72780] will be saved, but will not be published: The data source schema does not match the type mappings: APNX-2-4056-000{Missing table: xyz} (APNX-2-4053-006)'
I have verified the data store in the source environment and it is verifying successfully without any error in the source environment. So as per my understanding there is no discrepancy between data entities and respective CDTs.
Please help me to understand how can I resolve this warning.
Discussion posts and replies are publicly visible
Table xyz does not exist in your target environment. Depending of how you normally approach database table creation, you may have to execute some SQL scripts prior to deploying that package or publishing the data store after deployment (making Appian creating the missing tables for you)
Thanks Pedro for your response.
From where can I get these SQL scripts and how to execute these in target environment as I am not the developer of the application. I just have to deploy it in another environment.
ayushimittal, I advise you to connect with your development team on how to proceed regarding this matter since it really depends on their development approach and what they have done database wise.
In the meantime, I suggest you read https://docs.appian.com/suite/help/20.3/Data_Stores.html#create This address how automatic database schema updates works and how you can download/run DDL scripts.
Thanks Pedro.