Help

PermissionService.deletePermissions throwing DataIntegrityViolationException

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
drive954
Member II
‎31 Jul 2023 11:32 PM

PermissionService.deletePermissions throwing DataIntegrityViolationException

Usage of permissionService.deletePermissions started throwing DataIntegrityViolationException in certain cases when calling this method prior to setting permissions:

permissionService.deletePermissions(nodeRef)

Detailed exception message also contains following information:

Cause: org.postgresql.util.PSQLException: ERROR: update or delete on table "alf_access_control_list" violates foreign key constraint "fk_alf_node_acl" on table "alf_node"
Detail: Key (id)=(38685) is still referenced from table "alf_node".
Querying the database returns valid related nodes that are content, thumbnails etc. of the folder that is having permissions set.

Any pointers?
0 Kudos
Reply
1 Reply
abhinavmishra14
Advanced
‎1 Aug 2023 3:08 PM

Re: PermissionService.deletePermissions throwing DataIntegrityViolationException

Can you inspect the permissions of the nodeRef in question? Did you also tried this manually?

~Abhinav
(ACSCE, AWS SAA, Azure Admin)
0 Kudos
Reply
Alfresco Content Services Forum

Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.

Related links:

We use cookies on this site to enhance your user experience

By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods).   If you are not ok with these terms, please do not use this website.