topic GroupEntityManager.findGroupsByUser() is invoked multiple times on taskQuery execution in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/groupentitymanager-findgroupsbyuser-is-invoked-multiple-times-on/m-p/11878#M5231 <HTML><HEAD></HEAD><BODY><P>The issue is pretty similar to the below one that was discussed many years ago and I'm&nbsp;unable to refer to the fixes&nbsp;provided to that issue.</P><P><A href="https://migration33.stage.lithium.com/thread/218782">GroupManager.findGroupsByUser called twice</A>&nbsp;</P><P>-----------------------------------------------------------------------------------------------------------------------------</P><P>GroupEntityManager.findGroupsByUser() is invoked 5 times on taskQuery execution. I'm using SpringBoot along with Activiti, I have provided the code snippets below. Please advise if I'm missing anything for the query to function correctly.</P><P></P><P>Query:</P><PRE style="color: #a9b7c6; background-color: #2b2b2b; font-size: 9.0pt;">List&lt;Task&gt; tasks = taskQuery.taskCandidateOrAssigned(userId)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .list()<SPAN style="color: #cc7832;">;</SPAN></PRE><P></P><P>Config:</P><PRE style="color: #a9b7c6; background-color: #2b2b2b; font-size: 9.0pt;"><SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #cc7832;">public </SPAN>ProcessEngineFactoryBean <SPAN style="color: #ffc66d;">processEngine</SPAN>(SpringProcessEngineConfiguration configuration) <SPAN style="color: #cc7832;">throws </SPAN>Exception{<BR />&nbsp;&nbsp;&nbsp; configuration.setIdGenerator(<SPAN style="color: #cc7832;">new </SPAN>StrongUuidGenerator())<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #808080;"><BR /></SPAN><SPAN style="color: #808080;">&nbsp;&nbsp;&nbsp; </SPAN>GroupManagerFactory groupManagerFactory = <SPAN style="color: #cc7832;">new </SPAN>GroupManagerFactory(custom<SPAN style="color: #9876aa;">GroupEntityManager</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>configuration.setCustomSessionFactories(CollectionUtil.<SPAN>createListOfOne</SPAN>(groupManagerFactory))<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>configuration.setGroupEntityManager(custom<SPAN style="color: #9876aa;">GroupEntityManager</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;"><BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>configuration.setDbIdentityUsed(<SPAN style="color: #cc7832;">false</SPAN>)<SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; return super</SPAN>.processEngine(configuration)<SPAN style="color: #cc7832;">;<BR /></SPAN>}</PRE><P></P><P>GroupEntityManager:</P><PRE style="color: #a9b7c6; background-color: #2b2b2b; font-size: 9.0pt;"><SPAN style="color: #bbb529;">@Component<BR /></SPAN><SPAN style="color: #cc7832;">public class Custom</SPAN>GroupEntityManager <SPAN style="color: #cc7832;">implements </SPAN>GroupEntityManager<SPAN style="color: #cc7832;">, </SPAN>Session{<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>List&lt;Group&gt; <SPAN style="color: #ffc66d;">findGroupsByUser</SPAN>(String userId) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">//ACTUAL IMPLEMENTATION AND THIS METHOD IS GETTING INVOKED "FIVE" TIMES</SPAN><SPAN style="color: #cc7832;"><BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<SPAN style="color: #cc7832;"><BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>Group <SPAN style="color: #ffc66d;">createNewGroup</SPAN>(String groupId) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>GroupQuery <SPAN style="color: #ffc66d;">createNewGroupQuery</SPAN>() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>List&lt;Group&gt; <SPAN style="color: #ffc66d;">findGroupByQueryCriteria</SPAN>(GroupQueryImpl query<SPAN style="color: #cc7832;">, </SPAN>Page page) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public long </SPAN><SPAN style="color: #ffc66d;">findGroupCountByQueryCriteria</SPAN>(GroupQueryImpl query) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return </SPAN><SPAN style="color: #6897bb;">0</SPAN><SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>List&lt;Group&gt; <SPAN style="color: #ffc66d;">findGroupsByNativeQuery</SPAN>(Map&lt;String<SPAN style="color: #cc7832;">, </SPAN>Object&gt; parameterMap<SPAN style="color: #cc7832;">, int </SPAN>firstResult<SPAN style="color: #cc7832;">, int </SPAN>maxResults) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public long </SPAN><SPAN style="color: #ffc66d;">findGroupCountByNativeQuery</SPAN>(Map&lt;String<SPAN style="color: #cc7832;">, </SPAN>Object&gt; parameterMap) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return </SPAN><SPAN style="color: #6897bb;">0</SPAN><SPAN style="color: #cc7832;">;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public boolean </SPAN><SPAN style="color: #ffc66d;">isNewGroup</SPAN>(Group group) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return false;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>GroupEntity <SPAN style="color: #ffc66d;">create</SPAN>() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>GroupEntity <SPAN style="color: #ffc66d;">findById</SPAN>(String entityId) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public void </SPAN><SPAN style="color: #ffc66d;">insert</SPAN>(GroupEntity entity) {<BR /><BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public void </SPAN><SPAN style="color: #ffc66d;">insert</SPAN>(GroupEntity entity<SPAN style="color: #cc7832;">, boolean </SPAN>fireCreateEvent) {<BR /><BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>GroupEntity <SPAN style="color: #ffc66d;">update</SPAN>(GroupEntity entity) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public </SPAN>GroupEntity <SPAN style="color: #ffc66d;">update</SPAN>(GroupEntity entity<SPAN style="color: #cc7832;">, boolean </SPAN>fireUpdateEvent) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #cc7832;">return null;<BR /></SPAN><SPAN style="color: #cc7832;">&nbsp;&nbsp;&nbsp; </SPAN>}<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public void </SPAN><SPAN style="color: #ffc66d;">delete</SPAN>(String id) {<BR /><BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public void </SPAN><SPAN style="color: #ffc66d;">delete</SPAN>(GroupEntity entity) {<BR /><BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public void </SPAN><SPAN style="color: #ffc66d;">delete</SPAN>(GroupEntity entity<SPAN style="color: #cc7832;">, boolean </SPAN>fireDeleteEvent) {<BR /><BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public void </SPAN><SPAN style="color: #ffc66d;">flush</SPAN>() {<BR />&nbsp;&nbsp;&nbsp; }<BR /><BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #bbb529;">@Override<BR /></SPAN><SPAN style="color: #bbb529;">&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="color: #cc7832;">public void </SPAN><SPAN style="color: #ffc66d;">close</SPAN>() {<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; <SPAN style="color: #808080;">// CLOVER:ON<BR /></SPAN>}</PRE></BODY></HTML> Thu, 10 May 2018 04:39:12 GMT sam_a 2018-05-10T04:39:12Z GroupEntityManager.findGroupsByUser() is invoked multiple times on taskQuery execution https://connect.hyland.com/t5/alfresco-forum/groupentitymanager-findgroupsbyuser-is-invoked-multiple-times-on/m-p/11878#M5231 The issue is pretty similar to the below one that was discussed many years ago and I'm&nbsp;unable to refer to the fixes&nbsp;provided to that issue.GroupManager.findGroupsByUser called twice&nbsp;---------------------------------------------------------------------------------------------------------------------- Thu, 10 May 2018 04:39:12 GMT https://connect.hyland.com/t5/alfresco-forum/groupentitymanager-findgroupsbyuser-is-invoked-multiple-times-on/m-p/11878#M5231 sam_a 2018-05-10T04:39:12Z Re: GroupEntityManager.findGroupsByUser() is invoked multiple times on taskQuery execution https://connect.hyland.com/t5/alfresco-forum/groupentitymanager-findgroupsbyuser-is-invoked-multiple-times-on/m-p/11879#M5232 <HTML><HEAD></HEAD><BODY><P>Any input on this issue is appreciated.</P></BODY></HTML> Tue, 15 May 2018 16:26:06 GMT https://connect.hyland.com/t5/alfresco-forum/groupentitymanager-findgroupsbyuser-is-invoked-multiple-times-on/m-p/11879#M5232 sam_a 2018-05-15T16:26:06Z Re: GroupEntityManager.findGroupsByUser() is invoked multiple times on taskQuery execution https://connect.hyland.com/t5/alfresco-forum/groupentitymanager-findgroupsbyuser-is-invoked-multiple-times-on/m-p/11880#M5233 <HTML><HEAD></HEAD><BODY><P>This is being called&nbsp;by mybatis as mentioned in the other thread. Did you try setting the candidate groups in the query? If you provide the candidate groups in query&nbsp;GroupEntityManager.findGroupsByUser will not be invoked (see <A class="link-titled" href="https://github.com/Activiti/Activiti/blob/6.x/modules/activiti-engine/src/main/java/org/activiti/engine/impl/TaskQueryImpl.java#L1158" title="https://github.com/Activiti/Activiti/blob/6.x/modules/activiti-engine/src/main/java/org/activiti/engine/impl/TaskQueryImpl.java#L1158" rel="nofollow noopener noreferrer">Activiti/TaskQueryImpl.java at 6.x · Activiti/Activiti · GitHub</A>). Your query might look like this.</P><P></P><PRE style="color: #a9b7c6; background-color: #2b2b2b; border: 0px; font-size: 9pt;">List&lt;Task&gt; tasks = taskQuery.taskCandidateOrAssigned(userId)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .or()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.taskCandidateGroupIn(groups)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.endOr()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.list()<SPAN style="color: #cc7832; border: 0px; font-weight: inherit; font-size: 12px;">;</SPAN></PRE><P>Hope this helps.</P></BODY></HTML> Fri, 25 May 2018 10:12:37 GMT https://connect.hyland.com/t5/alfresco-forum/groupentitymanager-findgroupsbyuser-is-invoked-multiple-times-on/m-p/11880#M5233 bassam_al-saror 2018-05-25T10:12:37Z