Can't open files and attachments after copying tenant

This page is for MYOB Acumatica consultants

Check all changes in a test environment before taking them live. Make sure all related features still work as expected and that your data is unaffected.

When you copy a tenant to a new tenant, and you try to open an attachment that was from an original tenant, you will get an error: "Error#0 The file is not found, or you don't have enough rights to see this file."

image2022-2-8 11_59_29
Why the error occurs

The error occurs by design. When an attachment is uploaded to any screen, there are two parts:

  • The reference to that attachment, which is stored in the database.

  • The actual file, which is stored in the AmazonS3 server.

When you copy a tenant, only the reference to the attachment is copied (the data in the database). However, the actual files are not copied. This is because some sites have a very large number of files. Copying the file would be very resource intensive, and also consume the storage of the site. And when doing copy tenants, normally it’s for testing purposes, therefore only the data is copied. Because the data still reference of the file still point to the old tenant, when you access the page, you see the error. This stops users from editing a file in a test tenant and affecting the same file in the live tenant.

Working around the error
  1. Go to the Search In Files screen, where you can see which screen contains what file.

  2. Delete the reference to that file in the Search in File screen.

  3. Go back to the screen where you need to attach the attachment.

  4. Re-upload that attachment.