I got this error when try to verify Data Store.
However it is working in Dev environment and fails in UAT.
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 ?
We are facing the same issue, qurious to know if you were able to find the root cause of this?
Thanks in advance
This might help: tableplus.com/.../illegal-mix-of-collations-mysql.html
© 2024 Appian. All rights reserved.