Hi,
I got this error when try to verify Data Store.
However it is working in Dev environment and fails in UAT.
Thanks
Discussion posts and replies are publicly visible
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.
Everything looks good related permissions. However, from system logs I notice that this is the error.
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
How to know the date entity that cause this ? and how to resolve ?
Hi Ammar,
We are facing the same issue, qurious to know if you were able to find the root cause of this?
Thanks in advance
Ambrish
This might help: tableplus.com/.../illegal-mix-of-collations-mysql.html
Hi Ammar Alhaykicheck 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.