Error in Data store verification

Question

Hi, 
 
 I got this error when try to verify Data Store.

However it is working in Dev environment and fails in UAT. 
 
 Thanks

Mathieu Drouin · Answer

Looks like a permissions issue with the DB account Appian is using in UAT. I would suggest reaching out to your DBA and reviewing account permissions.

Mathieu Drouin · Answer

This might help: tableplus.com/.../illegal-mix-of-collations-mysql.html

Abhishek Karumuru · Answer

Hi Ammar Alhayki check data types you've mapped in Appian match the actual data types of the columns in your database table or other data store. Could you check if there have been any changes to the data source schema, such as column additions, deletions, or data type changes. Update your Appian type mappings to reflect these changes. Could you also please check the error logs in Appian for more detailed information about the issue. The logs may provide additional information about the mismatch that can help you in troubleshooting.