topic Re: Troubles with remove unnecessary operations while flush in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/troubles-with-remove-unnecessary-operations-while-flush/m-p/96500#M66313 <HTML><HEAD></HEAD><BODY><SPAN>I also have an issue where in a certain scenario, I have a create task listener that tries to immediately complete the task.&nbsp; The call to removeUnnecessaryOperations does not do the task insert, and then the identity links which were not removed create a foreign key error.</SPAN></BODY></HTML> Tue, 01 May 2012 13:25:59 GMT ptrepag 2012-05-01T13:25:59Z Troubles with remove unnecessary operations while flush https://connect.hyland.com/t5/alfresco-archive/troubles-with-remove-unnecessary-operations-while-flush/m-p/96499#M66312 Hello.In my case I have business process that has callActivity. In some way subrocess ends in transaction where it was created. And when activiti flush transaction I see errors in database (incorrect foreign keys). That occurs because DbSqlSession.flushTransaction() calls removeUnnecessaryOperations Tue, 07 Feb 2012 15:36:35 GMT https://connect.hyland.com/t5/alfresco-archive/troubles-with-remove-unnecessary-operations-while-flush/m-p/96499#M66312 dooman 2012-02-07T15:36:35Z Re: Troubles with remove unnecessary operations while flush https://connect.hyland.com/t5/alfresco-archive/troubles-with-remove-unnecessary-operations-while-flush/m-p/96500#M66313 <HTML><HEAD></HEAD><BODY><SPAN>I also have an issue where in a certain scenario, I have a create task listener that tries to immediately complete the task.&nbsp; The call to removeUnnecessaryOperations does not do the task insert, and then the identity links which were not removed create a foreign key error.</SPAN></BODY></HTML> Tue, 01 May 2012 13:25:59 GMT https://connect.hyland.com/t5/alfresco-archive/troubles-with-remove-unnecessary-operations-while-flush/m-p/96500#M66313 ptrepag 2012-05-01T13:25:59Z Re: Troubles with remove unnecessary operations while flush https://connect.hyland.com/t5/alfresco-archive/troubles-with-remove-unnecessary-operations-while-flush/m-p/96501#M66314 <HTML><HEAD></HEAD><BODY><SPAN>I got around my problem by calling flush on dbsqlsession before completing the task.&nbsp; Is it OK to call flush from within a event listener?&nbsp; I looked at the code and all it seems to do is just execute the pending database statements and leave the current transaction alone.&nbsp; With this being the case, I am assuming that flush can safely be called.</SPAN></BODY></HTML> Tue, 01 May 2012 13:35:27 GMT https://connect.hyland.com/t5/alfresco-archive/troubles-with-remove-unnecessary-operations-while-flush/m-p/96501#M66314 ptrepag 2012-05-01T13:35:27Z