Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

After Zurich upgrade, user tried to upload 2 images from other instance as xml

Soma Nadarajah
Tera Contributor

After upgrade to Zurich  , user tried to upload images to db_image table from other instance using xml and found following error message

Skipping record for table db_image and id 235e18620f610110580c95758b767e69 - permission denied

Skipping record for table db_image and id 40e63f9deb703610e585fe2fbad0cd7e - permission denied

 

how can I resolve this issue

1 ACCEPTED SOLUTION

maliksneha9
Tera Guru

Hi,

After upgrading to Zurich, stricter security controls were introduced around some system tables, including the db_image table. Because of this, importing records directly into db_image via XML can result in the “permission denied” message even if the user has admin privileges.

This typically happens because the table now has restricted ACLs that prevent direct insert/update operations through imports.

How to resolve it

1. Verify ACLs on the db_image table

  • Navigate to System Security → Access Control (ACL).

  • Filter for table = db_image.

  • Check if there are create or write ACLs restricting access.

  • If necessary, update the ACL to allow the required role (for example admin) to perform the insert.

2. Check if the table is protected by system restrictions
Some system tables are protected to prevent direct imports. In that case, the recommended approach is to upload the images using the UI or API instead of XML import.

3. Use the Image upload mechanism
Instead of importing XML records into db_image, upload the images through:

  • System UI → Images

  • Or use a script/API that inserts the image through the supported platform mechanism.

4. Confirm user roles
Ensure the user performing the import has sufficient roles such as admin and that no scoped application restrictions are blocking access.

 

Hope this helps!

View solution in original post

1 REPLY 1

maliksneha9
Tera Guru

Hi,

After upgrading to Zurich, stricter security controls were introduced around some system tables, including the db_image table. Because of this, importing records directly into db_image via XML can result in the “permission denied” message even if the user has admin privileges.

This typically happens because the table now has restricted ACLs that prevent direct insert/update operations through imports.

How to resolve it

1. Verify ACLs on the db_image table

  • Navigate to System Security → Access Control (ACL).

  • Filter for table = db_image.

  • Check if there are create or write ACLs restricting access.

  • If necessary, update the ACL to allow the required role (for example admin) to perform the insert.

2. Check if the table is protected by system restrictions
Some system tables are protected to prevent direct imports. In that case, the recommended approach is to upload the images using the UI or API instead of XML import.

3. Use the Image upload mechanism
Instead of importing XML records into db_image, upload the images through:

  • System UI → Images

  • Or use a script/API that inserts the image through the supported platform mechanism.

4. Confirm user roles
Ensure the user performing the import has sufficient roles such as admin and that no scoped application restrictions are blocking access.

 

Hope this helps!