Why do some (but not all) zip-Files greater than ~3.7GB fail to extract

Solution 1:

Something else to try, if the ZIP file is > 4 GB and was created by OneDrive or Windows, is a utility designed to fix-up the headers:
https://github.com/pmqs/Fix-OneDrive-Zip

Apparently, there's some disagreement about how to handle the "file count" header for Zip64 files. Microsoft products expect that the file count header should be 0 while other systems expect it to be 1. Newer versions of 7-zip for Windows (versions 19+) handle the issue fine but Linux only has an older POSIX port, p7zip, that is version 16 from 2016, and it does not have a way to handle this issue. The utility linked to above is a Perl-based script that changes the header information so that the file count changes from 0 to 1, so utilities can handle the files.

If you're curious, someone did a deep-dive on the issue here:
https://www.bitsgalore.org/2020/03/11/does-microsoft-onedrive-export-large-ZIP-files-that-are-corrupt