https://connect.hyland.com/t5/alfresco-forum/permissionservice-deletepermissions-throwing/m-p/124437#M34003 <P>Usage of&nbsp;permissionService.deletePermissions started throwing&nbsp;DataIntegrityViolationException in certain cases when calling this method prior to setting permissions:</P><DIV><PRE><SPAN>permissionService</SPAN>.deletePermissions(nodeRef)</PRE><P>Detailed exception message also contains following information:</P><DIV><DIV><PRE>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".</PRE></DIV><DIV>Querying the database returns valid related nodes that are content, thumbnails etc. of the folder that is having permissions set.<BR /><BR />Any pointers?</DIV></DIV></DIV> Mon, 31 Jul 2023 22:32:16 GMT drive954 2023-07-31T22:32:16Z https://connect.hyland.com/t5/alfresco-forum/permissionservice-deletepermissions-throwing/m-p/124437#M34003 <P>Usage of&nbsp;permissionService.deletePermissions started throwing&nbsp;DataIntegrityViolationException in certain cases when calling this method prior to setting permissions:</P><DIV><PRE><SPAN>permissionService</SPAN>.deletePermissions(nodeRef)</PRE><P>Detailed exception message also contains following information:</P><DIV><DIV><PRE>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".</PRE></DIV><DIV>Querying the database returns valid related nodes that are content, thumbnails etc. of the folder that is having permissions set.<BR /><BR />Any pointers?</DIV></DIV></DIV> Mon, 31 Jul 2023 22:32:16 GMT https://connect.hyland.com/t5/alfresco-forum/permissionservice-deletepermissions-throwing/m-p/124437#M34003 drive954 2023-07-31T22:32:16Z https://connect.hyland.com/t5/alfresco-forum/permissionservice-deletepermissions-throwing/m-p/124438#M34004 <P>Can you inspect the permissions of the nodeRef in question? Did you also tried this manually?</P> Tue, 01 Aug 2023 14:08:42 GMT https://connect.hyland.com/t5/alfresco-forum/permissionservice-deletepermissions-throwing/m-p/124438#M34004 abhinavmishra14 2023-08-01T14:08:42Z