Skip to main content
A
ammara0001
June 21, 2023
Question

Error in Data store verification

  • June 21, 2023
  • 5 replies
  • 0 views

Hi,

I got this error when try to verify Data Store.

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

Thanks

5 replies

mathieud0001
mathieud0001
Brainy
June 21, 2023

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.

A
ammara0001Author
June 21, 2023

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 ?

A
ambrishs2768
Known Participant
December 6, 2023

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

karumurua531442
karumurua531442
December 16, 2023

Hi [mention:75b99e2a283443e3a34eebeecd3efce6:e9ed411860ed4f2ba0265705b8793d05]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.

Terms & ConditionsAccessibility statement