Zendesk import fails with the following error:
An error occurred during import
JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1366]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
- Zendesk
- Provisioning
- Import
The error code [1366]; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement related to the special characters, including emojis, mathematical symbols, and/or foreign characters that are used in the group's name and description imported from Zendesk.
Follow the steps or video below.
- Verify that all the groups that are trying to be imported from Zendesk do not have any special characters, including emojis, mathematical symbols, and/or foreign characters in the name or description.
- Once the group name or description is corrected, attempt the import again.
