<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
Zendesk Import Error "JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1366]; could not execute statement"
Okta Integration Network
Okta Classic Engine
Okta Identity Engine
Overview

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


Import error 

 
Applies To
  • Zendesk
  • Provisioning
  • Import
Cause

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.

Solution

Follow the steps or video below.

 

  1. 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.
  2. Once the group name or description is corrected, attempt the import again.
Loading
Zendesk Import Error "JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1366]; could not execute statement"