topic Re: trouble with query in our database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181257#M134387 <HTML><HEAD></HEAD><BODY><SPAN>we use 5.14 version of Activity.</SPAN><BR /><BR /><SPAN>ok. we'll try 5.17</SPAN><BR /><BR /><SPAN>thanks</SPAN></BODY></HTML> Thu, 14 May 2015 07:42:42 GMT neosss 2015-05-14T07:42:42Z trouble with query in our database https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181255#M134385 out DB is Oracle 11gwe see 1 trouble querySELECT *&nbsp; FROM (SELECT a.*, ROWNUM rnum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM (SELECT RES.*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM ACT_RU_JOB RES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp;&nbsp;&nbsp;&nbsp; (RETRIES_ &gt; 0)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (DUEDATE_ IS NULL OR DUEDATE_ &lt; :1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (LOCK_OWNER_ IS NU Fri, 08 May 2015 11:15:34 GMT https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181255#M134385 neosss 2015-05-08T11:15:34Z Re: trouble with query in our database https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181256#M134386 <HTML><HEAD></HEAD><BODY><SPAN>Which version of Activiti are you using? With Activiti 5.17 we introduced a new async job executor which improves the job queries a lot.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 13 May 2015 12:50:23 GMT https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181256#M134386 trademak 2015-05-13T12:50:23Z Re: trouble with query in our database https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181257#M134387 <HTML><HEAD></HEAD><BODY><SPAN>we use 5.14 version of Activity.</SPAN><BR /><BR /><SPAN>ok. we'll try 5.17</SPAN><BR /><BR /><SPAN>thanks</SPAN></BODY></HTML> Thu, 14 May 2015 07:42:42 GMT https://connect.hyland.com/t5/alfresco-archive/trouble-with-query-in-our-database/m-p/181257#M134387 neosss 2015-05-14T07:42:42Z