topic Re: failed to decompress the backup file in Qlik Replicate

failed to decompress the backup file

sthiyagarajan — Tue, 24 Aug 2021 11:14:44 GMT

Qlik replicate task failed with the below error message.

Failed to decompress the backup file 'UncomprsTemp_FASTDOCPREPtoDLAll-INCR.bak' (at offset 30362380, compressed size 0, decompressed size 65536), decompression status 'C0000242' [1020448] (sqlserver_drd_utl_common.c:2320)

Any idea what would be causing this?

Re: failed to decompress the backup file

john_wang — Thu, 26 Aug 2021 14:36:31 GMT

Hello @sthiyagarajan ,

Many factors may lead this error in SQL Server source endpoint, for example you wrongly enabling the option "Replicate has file-level access to the backup files" or other configuration issue, or the backup file cannot be read correctly by Replicate etc.

I'd like suggest you open a support case with:

1. Set source_capture to Verbose;

2. Reproduce the error, and then attach the diagnostics package to the case.

3. Please mark if your environment is an AlwaysOn Availability Group.

Regards,

John.

Re: failed to decompress the backup file

lyka — Tue, 26 Oct 2021 18:45:49 GMT

Hello,

If you are using file-level access and compressed files, then you need to have an available disk space on the drive that has the Replicate BIN folder that is 6x the size of the trn file.

Thanks

Lyka

Re: failed to decompress the backup file

Barb_Fill21 — Thu, 05 Jun 2025 13:17:19 GMT

Hello All,

Also, I have located a patch for a decompression error- it was fixed in May 2024.

With one of my customers, they upgraded to latest NOV 2024 SR1 and the issue is now gone.

Sincerely,

Barb

Consider upgrading to Nov 2024 SR1 or the most current version May 2025.

Re: failed to decompress the backup file

Dana_Baldwin — Thu, 05 Jun 2025 15:15:21 GMT

Earlier versions decompressed the backup transaction log to the bin directory. Current versions use the disk the data directory resides on.