topic Transfer Service failing on large volume in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/transfer-service-failing-on-large-volume/m-p/290562#M243692 <HTML><HEAD></HEAD><BODY><BR /><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>We've implemented transfer service to publish documents to an external Alfresco instance. We're using Alfresco 4.0.e. </SPAN><BR /><BR /><SPAN>Now the volume of our publications is increasing, the transfers are failing. First, i hit an AJP timeout between de Apache reverse proxy and the tomcat on the destination instance. After increasing these timeout settings, i'm hitting the next timeout, in MySQL: </SPAN><BR /><BR /><SPAN>&lt;blockcode&gt;</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction</SPAN><BR /><SPAN>&lt;/blockcode&gt;</SPAN><BR /><BR /><SPAN>I'm willing to try to increase these as well, but I fear the transfer service might not be designed to handle large volume, although i was under the impression it was designed to sync to the Alfresco Cloud (?).</SPAN><BR /><BR /><SPAN>If i would be able to set a batch size for the total amout, the problem would be solved. But I'm not sure these settings exist.</SPAN><BR /><BR /><SPAN>Anyone solved this problem?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Koen</SPAN></BODY></HTML> Tue, 14 Jan 2014 11:01:21 GMT kbonnet 2014-01-14T11:01:21Z Transfer Service failing on large volume https://connect.hyland.com/t5/alfresco-archive/transfer-service-failing-on-large-volume/m-p/290562#M243692 Hi all,We've implemented transfer service to publish documents to an external Alfresco instance. We're using Alfresco 4.0.e. Now the volume of our publications is increasing, the transfers are failing. First, i hit an AJP timeout between de Apache reverse proxy and the tomcat on the destination inst Tue, 14 Jan 2014 11:01:21 GMT https://connect.hyland.com/t5/alfresco-archive/transfer-service-failing-on-large-volume/m-p/290562#M243692 kbonnet 2014-01-14T11:01:21Z Re: Transfer Service failing on large volume https://connect.hyland.com/t5/alfresco-archive/transfer-service-failing-on-large-volume/m-p/290563#M243693 <HTML><HEAD></HEAD><BODY><SPAN>&lt;blockquote&gt;i was under the impression it was designed to sync to the Alfresco Cloud (?).&lt;/blockquote&gt;</SPAN><BR /><SPAN>Not really.&nbsp; We actually wrote another service for that.</SPAN><BR /><SPAN>Currently we are working on a revamped, general purpose sync service that will eventually encompass server-server transfers at a granular level.</SPAN><BR /><SPAN>For now, we don't have a way of breaking the transfer into batches (I'll get that confirmed) but you can increase your DB connection timeout.&nbsp; Of course, that'll just take you to the next limit.</SPAN></BODY></HTML> Tue, 14 Jan 2014 11:27:18 GMT https://connect.hyland.com/t5/alfresco-archive/transfer-service-failing-on-large-volume/m-p/290563#M243693 derek 2014-01-14T11:27:18Z