<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
Google Workspace 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
Overview

Google Workspace 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
  • Google Workspace
  • Import
  • Provisioning
Cause

The error is related to special characters, including emojis, mathematical symbols, and/or foreign characters used in the group's name and description that were imported from Google Workspace.

Solution

Follow the steps or video below:

 

  1. Verify that all the groups that are trying to be imported from Google Workspace 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.

 

Related References

Loading
Google Workspace Import Error "JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1366]; could not execute statement"