Failed to get lastCheckpoint file

yasminemaximos — Mon, 15 Sep 2025 13:58:10 GMT

Following parquet files migration between environments, deleting the schema.table records from FILES_VERSIONS table in metadata db and performing a successful stage load.

DELETE from FILES_VERSIONS where NAME like 'Schema_Table.%';

Table is failing with be below error during the next incremental or full:

Failed to get lastCheckpoint file for Table: Fusion_Hist.Product_Process_Dependency [com.incorta.datamanagement.staging.TenantDataManagerImpl.getLastCheckpointOfCompactedVersion]
java.io.IOException: failed to read _last_checkpoint [com.incorta.datamanagement.staging.TenantDataManagerImpl.getLastCheckpointOfCompactedVersion]

Resolution:

Delete the last checkpoint parquet file located under schema.table → _delta_log > → _last_checkpoint
Set the compaction to 0 in the Files Version metadata
UPDATE FILES_VERSIONS SET COMPACTED_VERSION = 0 WHERE NAME LIKE 'Schema.%';
Rerun Stage Load
Resuming the increment or full loads.

topic Failed to get lastCheckpoint file in Administrative Discussions

Failed to get lastCheckpoint file