topic Scheduled Action Configuration - Transaction Mode in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/scheduled-action-configuration-transaction-mode/m-p/235589#M188719 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>I use Alfresco 3.0 and I have configured a scheduled action to transform documents tiff to pdf using Intelliant OCR. The problem is sometimes the Intelliant OCR can´t transform a document but it doesn´t return error. It stops and doesn´t continue processing the remaining files.</SPAN><BR /><BR /><SPAN>The configuration of scheduled actions is as follows:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;bean id="programTransformOCR" class="org.alfresco.repo.action.scheduled.CronScheduledQueryBasedTemplateActionDefinition"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="transactionMode"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;ISOLATED_TRANSACTIONS&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="compensatingActionMode"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;IGNORE&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="searchService"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="SearchService"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="templateService"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="TemplateService"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="queryLanguage"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;lucene&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="stores"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;workspace://SpacesStore&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/list&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Find all nodes that do not have the aspect –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="queryTemplate"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;+PATH:"/app:company_home/cm:Clientes/*//*" +TYPE:"{custom.model}Recorte" +@\{http\://<A href="http://www.alfresco.org/model/content/1.0\}content.mimetype:image/tiff" rel="nofollow noopener noreferrer">www.alfresco.org/model/content/1.0\}content.mimetype:image/tiff</A>&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="cronExpression"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;!–&lt;value&gt;0 */3 * * * ?&lt;/value&gt;–&gt;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;value&gt;0 0 21 * * ?&lt;/value&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!–&lt;value&gt;0 0 14 ? * SAT&lt;/value&gt;–&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="jobName"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;jobA&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="jobGroup"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;jobGroup&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="triggerName"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;triggerA&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="triggerGroup"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;triggerGroup&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;!– Inject the scheduler - the trigger will be registered with this scheduler –&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="scheduler"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="schedulerFactory"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="actionService"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="ActionService"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="templateActionModelFactory"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="templateActionModelFactory"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="templateActionDefinition"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="transformPdfOCR"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="transactionService"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ref bean="TransactionService"/&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="runAsUser"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;value&gt;admin&lt;/value&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/bean&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I saw the information explained in “</SPAN><A href="http://wiki.alfresco.com/wiki/Scheduled_Actions”" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Scheduled_Actions”</A><SPAN> and set the "transactionMode" property as ISOLATED_TRANSACTIONS so that the process could continue if a failure took place. It´s right? </SPAN><BR /><SPAN>The problem is the result is not the expected. The process stops and the log file hasn´t any error.</SPAN><BR /><BR /><SPAN>Can someone help me to configure well the scheduled action?</SPAN><BR /><BR /><SPAN>Thanks a lot in advance,</SPAN></BODY></HTML> Tue, 01 Jun 2010 08:05:13 GMT agey 2010-06-01T08:05:13Z Scheduled Action Configuration - Transaction Mode https://connect.hyland.com/t5/alfresco-archive/scheduled-action-configuration-transaction-mode/m-p/235589#M188719 Hi all,I use Alfresco 3.0 and I have configured a scheduled action to transform documents tiff to pdf using Intelliant OCR. The problem is sometimes the Intelliant OCR can´t transform a document but it doesn´t return error. It stops and doesn´t continue processing the remaining files.The configurati Tue, 01 Jun 2010 08:05:13 GMT https://connect.hyland.com/t5/alfresco-archive/scheduled-action-configuration-transaction-mode/m-p/235589#M188719 agey 2010-06-01T08:05:13Z Re: Scheduled Action Configuration - Transaction Mode https://connect.hyland.com/t5/alfresco-archive/scheduled-action-configuration-transaction-mode/m-p/235590#M188720 <HTML><HEAD></HEAD><BODY><SPAN>Can anybody help me? The last time when Scheduled action was ran, it failed. The error is this:</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">21:44:41,921 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Ejecutandose action automaticamente<BR />21:44:41,937 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] actionedUponNodeRef workspace://SpacesStore/a4bb1f04-cd94-4524-9171-e9b6560dcab8<BR />21:44:41,937 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] originalName OCR_E280610_elcorreo_6.tif<BR />21:44:41,937 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] newName OCR_E280610_elcorreo_6.pdf<BR />21:44:42,031 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Transformando …<BR />21:44:42,031 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Inicio transformacion<BR />21:44:49,390 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Fin transformacion<BR />21:44:49,390 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Fin action<BR />21:44:58,156 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Ejecutandose action automaticamente<BR />21:44:58,156 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] actionedUponNodeRef workspace://SpacesStore/c84dfd8c-fb81-4fea-aa97-3652dd9720ea<BR />21:44:58,171 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] originalName OCR_250610-el dia-6.tif<BR />21:44:58,171 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] newName OCR_250610-el dia-6.pdf<BR />21:44:58,640 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Transformando …<BR />21:44:58,640 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Inicio transformacion<BR />21:45:00,453 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Fin transformacion<BR />21:45:00,453 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Fin action<BR />21:45:01,484 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Ejecutandose action automaticamente<BR />21:45:01,484 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] actionedUponNodeRef workspace://SpacesStore/5f8e0d3c-91bf-4c62-a09d-18f343b78d91<BR />21:45:01,500 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] originalName OCR_250610-la provincia-7.tif<BR />21:45:01,500 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] newName OCR_250610-la provincia-7.pdf<BR />21:45:01,578 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Transformando …<BR />21:45:01,578 INFO&nbsp; [org.incis.model.actions.OCRTransformActionExecuter] Inicio transformacion<BR />22:24:12,109 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.userUsageTrackingJobDetail threw an unhandled Exception: <BR />org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not execute update query; SQL [delete from alf_usage_delta where node_id=?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:396)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:259)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1141)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO$2.doInHibernate(HibernateUsageDeltaDAO.java:161)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO.deleteDeltas(HibernateUsageDeltaDAO.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO.deleteDeltas(HibernateUsageDeltaDAO.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UsageServiceImpl.deleteDeltas(UsageServiceImpl.java:65)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor852.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy42.deleteDeltas(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$9.execute(UserUsageTrackingComponent.java:558)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$9.execute(UserUsageTrackingComponent.java:539)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:246)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.collapseUsage(UserUsageTrackingComponent.java:579)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.access$600(UserUsageTrackingComponent.java:60)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$8.doWork(UserUsageTrackingComponent.java:519)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$8.doWork(UserUsageTrackingComponent.java:517)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.collapseUsages(UserUsageTrackingComponent.java:515)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.execute(UserUsageTrackingComponent.java:143)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageCollapseJob.execute(UserUsageCollapseJob.java:48)<BR />&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:202)<BR />&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)<BR />22:25:53,125 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.userUsageTrackingJobDetail threw an exception.<BR />org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not execute update query; SQL [delete from alf_usage_delta where node_id=?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction]<BR />&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:213)<BR />&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)<BR />Caused by: org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not execute update query; SQL [delete from alf_usage_delta where node_id=?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:250)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO.deleteDeltas(HibernateUsageDeltaDAO.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO.deleteDeltas(HibernateUsageDeltaDAO.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UsageServiceImpl.deleteDeltas(UsageServiceImpl.java:65)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor852.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy42.deleteDeltas(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$9.execute(UserUsageTrackingComponent.java:558)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$9.execute(UserUsageTrackingComponent.java:539)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:246)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.collapseUsage(UserUsageTrackingComponent.java:579)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.access$600(UserUsageTrackingComponent.java:60)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$8.doWork(UserUsageTrackingComponent.java:519)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$8.doWork(UserUsageTrackingComponent.java:517)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.collapseUsages(UserUsageTrackingComponent.java:515)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.execute(UserUsageTrackingComponent.java:143)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageCollapseJob.execute(UserUsageCollapseJob.java:48)<BR />&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:202)<BR />&nbsp;&nbsp;&nbsp;… 1 more<BR />Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:396)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:259)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1141)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO$2.doInHibernate(HibernateUsageDeltaDAO.java:161)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)<BR />&nbsp;&nbsp;&nbsp;… 28 more<BR />23:02:56,406 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.userUsageTrackingJobDetail threw an unhandled Exception: <BR />org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not execute update query; SQL [delete from alf_usage_delta where node_id=?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:396)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:259)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1141)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO$2.doInHibernate(HibernateUsageDeltaDAO.java:161)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO.deleteDeltas(HibernateUsageDeltaDAO.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO.deleteDeltas(HibernateUsageDeltaDAO.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UsageServiceImpl.deleteDeltas(UsageServiceImpl.java:65)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor852.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy42.deleteDeltas(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$9.execute(UserUsageTrackingComponent.java:558)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$9.execute(UserUsageTrackingComponent.java:539)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:246)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.collapseUsage(UserUsageTrackingComponent.java:579)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.access$600(UserUsageTrackingComponent.java:60)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$8.doWork(UserUsageTrackingComponent.java:519)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$8.doWork(UserUsageTrackingComponent.java:517)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.collapseUsages(UserUsageTrackingComponent.java:515)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.execute(UserUsageTrackingComponent.java:143)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageCollapseJob.execute(UserUsageCollapseJob.java:48)<BR />&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:202)<BR />&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)<BR />23:02:56,421 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.userUsageTrackingJobDetail threw an exception.<BR />org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not execute update query; SQL [delete from alf_usage_delta where node_id=?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction]<BR />&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:213)<BR />&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)<BR />Caused by: org.springframework.dao.CannotAcquireLockException: Hibernate operation: could not execute update query; SQL [delete from alf_usage_delta where node_id=?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:250)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO.deleteDeltas(HibernateUsageDeltaDAO.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO.deleteDeltas(HibernateUsageDeltaDAO.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UsageServiceImpl.deleteDeltas(UsageServiceImpl.java:65)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor852.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy42.deleteDeltas(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$9.execute(UserUsageTrackingComponent.java:558)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$9.execute(UserUsageTrackingComponent.java:539)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:246)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.collapseUsage(UserUsageTrackingComponent.java:579)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.access$600(UserUsageTrackingComponent.java:60)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$8.doWork(UserUsageTrackingComponent.java:519)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent$8.doWork(UserUsageTrackingComponent.java:517)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.collapseUsages(UserUsageTrackingComponent.java:515)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageTrackingComponent.execute(UserUsageTrackingComponent.java:143)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.usage.UserUsageCollapseJob.execute(UserUsageCollapseJob.java:48)<BR />&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:202)<BR />&nbsp;&nbsp;&nbsp;… 1 more<BR />Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:396)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:259)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1141)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateUsageDeltaDAO$2.doInHibernate(HibernateUsageDeltaDAO.java:161)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)<BR />&nbsp;&nbsp;&nbsp;… 28 more<BR />23:16:01,265 ERROR [org.alfresco.repo.shutdown.ShutdownBackstop] Alfresco terminating via Shutdown Backstop<BR />23:16:11,046 ERROR [org.alfresco.repo.shutdown.ShutdownBackstop] Alfresco terminated</BLOCKQUOTE><BR /><SPAN>What happens? Perhaps there are too many files? This job begins at 21.00 and transforms over 100 files in about 30 minutes every day but this time there were over 306 files.</SPAN><BR /><BR /><SPAN>Thanks a lot in advance,</SPAN></BODY></HTML> Wed, 30 Jun 2010 07:49:54 GMT https://connect.hyland.com/t5/alfresco-archive/scheduled-action-configuration-transaction-mode/m-p/235590#M188720 agey 2010-06-30T07:49:54Z