Bad size of attachments

Situation: I have DB with archived mails, DB has DAOS enabled, there are about 130k docs, 15GB (logical, 8GB physical). A few day ago user noticed that he cannot open some of the attachments. Till today we have found 2 bad attachments.

What I have tried already (with one of the corrupted attachment):

fixup -J -D

fixup -J -F

DAOSMgr Resync

DAOSMgr Resync Force

  • none of them didn’t help

In the LN client (standard, 901) filesize (length) of the attachment is 42B, if I open doc using web access file size is 389kB. File is ZIP archive, so both I cannot open, zip archive is broken. I have wrote server agent which detach attachment on the server - with the access of the server it self. Detached file has 389kB - and still I cannot open.

Using black magic I found which NLO file is this attachment so I had decrypted it and download it from server - and … it is OK! It has file size 774kB.

Good thing is that file is safe, but bad thing is that I cannot find the way how to check whole DB for another bad attachments - all detached files look good until I tried to open them. And there are thousands of them.

Strange thing is that Notes client shows different size and may be different file than server.

I didn’t find any similar situation so please I somebody can help with this?