Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Deleting 0 KB files in SafeSync for Enterprise

    • Updated:
    • 3 May 2018
    • Product/Version:
    • SafeSync for Enterprise 3.2
    • Platform:
    • Android All
    • iOS 9.2
    • Macintosh Snow Leopard
    • macOS High Sierra
    • macOS Sierra
    • Ubuntu 11.04 64-bit
    • Ubuntu 12.04 64-bit
    • Windows 7 32-Bit
    • Windows 7 64-Bit
Summary

One or more files in SafeSync for Enterprise web console may show zero (0) file size. Additionally, the delete button does not show up when selecting the file.

File with 0 KB size

Details
Public

The issue may happen when an unexpected error occurred during the upload process.

To delete the 0 KB files, do the following:

Admin Solution 1: Delete a specific 0 KB file

  1. SSH login to SafeSync for Enterprise server (either appliance1 or appliance2).
  2. Go to SafeSync OSDP bin directory.
    cd /opt/TrendMicro/OSDP/bin
  3. Find the 0 KB file owner's user ID using the user's login name.
    sudo ./userTool.pl -u <user_login_name> show | grep "^ID:"
  4. Find the user's personal folder ID (displayed as "object_id") using the user ID taken from previous step.
    sudo ./objTool.pl -u <user_id> show | grep "object_id:"
  5. List all files under the user's personal folder using the user ID and object ID taken from the two previous steps. Find the file ID of 0 KB file, which is located at the beginning of the line containing the 0 KB file name.
    sudo ./objTool.pl -u <user_id>-<object_id> tree | less

    For example, if the 0 KB file name is "test.img", then its file ID is "5-111".

    5-11 folder !home
    5-111 file test.img
  6. Delete the file using the file ID.
    sudo /opt/TrendMicro/OSDP/Bin/objTool.pl -i <file_id> -f delete

Admin Solution 2: Delete all 0 KB files

  1. SSH login to SafeSync for Enterprise server (either appliance1 or appliance2).
  2. Run the command below to list all files with 0 byte size.
    mysql -uroot -psafesync -e "select concat(user_id, '-',  object_id) as object_id, name, (select name from osdp.users u where u.user_id = o.user_id) as belong_user_name from shard_1.objects o where size = 0 and type = 'file';"
  3. Find the file's object_id from the result above and use the command below to delete the files.
    sudo /opt/TrendMicro/OSDP/Bin/objTool.pl -f -i <object-id> delete

End-User Solution

  1. Log in to SafeSync User Portal.
  2. Re-upload the file (with the same file name) and choose to overwrite the existing one.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1119777
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.