Loading

Tableau Server: Extract Data Source Fails with "LZ4 decompression error" / "database has invalid checksum" (SQLSTATE XXS01) After a Successful Refresh

Publiceringsdatum: Oct 14, 2026
Beskrivning
Applies To
  • Tableau Server on Linux, multi-node.
  • Hyper extracts (.hyper), refreshed incrementally or fully

 

Issue
Queries against an extract-based data source or workbook fail intermittently with:

An error occurred while communicating with data source '<data source name>' [SQLSTATE:XXS01] LZ4 decompression error: generic - -1. The database is corrupt and needs to be re-created. database has invalid checksum: Expected checksum 0. DataServiceFailure.
 

What Does Error Mean ?

"[SQLSTATE:XXS01] LZ4 decompression error: generic - -1. The database is corrupt and needs to be re-created. database has invalid checksum: Expected checksum 0. The database is corrupt and needs to be re-created.\n"

  • The extract refresh job that produced the file reported success, with no failures or warnings.
  • The error can affect several workbooks and data sources, whether they come from databases or flat files on network storage.
  • A later incremental or full refresh temporarily clears the error, but it can come back.
 
SQLSTATE XXS01 means DataPhysicallyInvalid corruption — valid checksums but internally invalid structure, or LZ4 decompression failure inside Hyper 

Cause
The behavior is consistent with on-disk corruption of the extract file after it was written, not a failed refresh. The corruption usually happens but not limited to at the storage/OS level: interrupted write, disk error, incomplete upload, or filesystem corruption 
  • Storage media or filesystem errors
  • Interruptions or instability on network-attached storage (NAS) or the underlying volume
  • Check disk health, NFS/SAN errors, or whether the file was transferred/copied while the extract was being written.
Lösning

The Only Fix forward:

Re-create or Replace with fresh or valid non-corrupt data extract options to fix discussed

1. Desktop: Re-extract the data source (Data → Extract → Refresh), or re-publish the workbook/datasource.

2. Server: Trigger a full extract refresh on the datasource. 

 

Knowledge-artikelnummer

005461753

 
Laddar
Salesforce Help | Article