KNOWLEDGE BASE

Error "SiteImportExportException org.hibernate.exception.GenericJDBCException: could not extract ResultSet" From tsm sites export


Published: 28 Feb 2022
Last Modified Date: 02 Nov 2022

Issue

When running the "tsm sites export" command, an error is received:

SiteImportExportException org.hibernate.exception.GenericJDBCException: could not extract ResultSet

Environment

  • Tableau Server 2021.3.6 or later
  • Windows Server 2016

Resolution

Upgrade to the Tableau Server versions shown below or newer:
  • 2022.3 
  • 2022.1.4
  • 2021.4.9
  • 2021.3.14
  • 2021.2.15

Cause

Resolved in higher versions of Tableau Server under defect ID 1366825.

Additional Information

The below error shows in the siteimportexport_node-0.log:
 
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "workbook_extension_connections" violates foreign key constraint "workbook_fk"
  Detail: Key (workbook_id)=(###) is not present in table "workbooks".
 
Did this article resolve the issue?