KNOWLEDGE BASE

'Commit failed' Error Message Importing or Exporting a Site


Published: 19 Jun 2017
Last Modified Date: 27 Mar 2018

Issue

Site Import / Export failed displaying following error message:
 
"ERROR: "org.springframework.orm.jpa.JpaSystemException: org.hibernate.TransactionException: commit failed; nested exception is javax.persistence.PersistenceException: org.hibernate.TransactionException: commit failed."

Environment

Tableau Server

Resolution

Option 1

As a Tableau Server Administrator, upgrade to Tableau Server 10.3.5. For more information, see Upgrading Tableau Server in Tableau Help. 

Option 2

  1. Correct the user mapping file to include the missing .com on the email domain.
  2. Add the local user account on the server before trying to add in Tableau Server import.

Cause

This behavior is related to a known issue (ID: 706291) which is resolved in Tableau Server 10.3.5.

Additionally, either one of these can cause the commit failed error:
  1. User was missing the .com on the email domain in the user mapping file.
  2. The local user did not have an account created for them on the server yet.

 
Did this article resolve the issue?