failed to decompress the backup file

[sthiyagarajan]

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?

[john_wang]

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.

[lyka]

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

[Barb_Fill21]

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. 

[Dana_Baldwin]

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