topic Re: Alfresco Explorer blocks properties when I change it? in Alfresco Archive

Alfresco Explorer blocks properties when I change it?

spilby — Mon, 26 May 2014 14:24:43 GMT

I have a problem after using the Alfresco Explorer. I have created a java webscript to create nodes and modify properties, into a transaction, oks? All works fine when I use the webscript. I create folders, subfolders, modify the properties, all ok. But then, I do the following… I go to the Alfresco

Re: Alfresco Explorer blocks properties when I change it?

marsbard — Mon, 26 May 2014 14:39:13 GMT

Can you paste the full stacktrace that you get when this error occurs? Should be in both alfresco.log and catalina.out

Re: Alfresco Explorer blocks properties when I change it?

spilby — Mon, 26 May 2014 15:18:15 GMT

Of course, here is:

org.springframework.dao.ConcurrencyFailureException: Failed to update node 291346
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.updateNodeImpl(AbstractNodeDAOImpl.java:1875)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.touchNode(AbstractNodeDAOImpl.java:1701)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.setNodePropertiesImpl(AbstractNodeDAOImpl.java:2283)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.addNodeProperties(AbstractNodeDAOImpl.java:2387)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.addAspectsAndProperties(DbNodeServiceImpl.java:542)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.addAspectsAndProperties(DbNodeServiceImpl.java:444)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1593)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:105)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)
        at com.sun.proxy.$Proxy42.setProperty(Unknown Source)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:252)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.enterprise.repo.sync.SyncPropertyInterceptor.invoke(SyncPropertyInterceptor.java:223)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:260)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
        at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.audit.DisableAuditableBehaviourInterceptor.invoke(DisableAuditableBehaviourInterceptor.java:113)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:161)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.transaction.RetryingTransactionInterceptor$1.execute(RetryingTransactionInterceptor.java:79)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:449)
        at org.alfresco.repo.transaction.RetryingTransactionInterceptor.invoke(RetryingTransactionInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
        at cat.aoc.alfresco.desal.service.AlfrescoService.updateCustomProperties(AlfrescoService.java:439)
        at cat.aoc.alfresco.desal.service.AlfrescoService.transactionUpdateCustomProperties(AlfrescoService.java:690)
        at cat.aoc.alfresco.desal.CarregaDocumentWebScript.insertaDocument(CarregaDocumentWebScript.java:773)
        at cat.aoc.alfresco.desal.CarregaDocumentWebScript.carregaDocument(CarregaDocumentWebScript.java:239)
        at cat.aoc.alfresco.desal.CarregaDocumentWebScript.execute(CarregaDocumentWebScript.java:127)
        at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:421)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:449)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:483)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:521)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:333)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:30)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:227)
        at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:347)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)

From the alfresco.log. It's thrown when my code call to getNodeService().setProperty. In catalina.log the trace is the same.

org.springframework.dao.ConcurrencyFailureException: Failed to update node 291346
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.updateNodeImpl(AbstractNodeDAOImpl.java:1875)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.touchNode(AbstractNodeDAOImpl.java:1701)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.setNodePropertiesImpl(AbstractNodeDAOImpl.java:2283)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.addNodeProperties(AbstractNodeDAOImpl.java:2387)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.addAspectsAndProperties(DbNodeServiceImpl.java:542)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.addAspectsAndProperties(DbNodeServiceImpl.java:444)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1593)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:105)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)
        at com.sun.proxy.$Proxy42.setProperty(Unknown Source)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:252)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.enterprise.repo.sync.SyncPropertyInterceptor.invoke(SyncPropertyInterceptor.java:223)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:260)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
        at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.audit.DisableAuditableBehaviourInterceptor.invoke(DisableAuditableBehaviourInterceptor.java:113)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:161)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.transaction.RetryingTransactionInterceptor$1.execute(RetryingTransactionInterceptor.java:79)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:449)
        at org.alfresco.repo.transaction.RetryingTransactionInterceptor.invoke(RetryingTransactionInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
        at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
        at cat.aoc.alfresco.desal.service.AlfrescoService.updateCustomProperties(AlfrescoService.java:439)
        at cat.aoc.alfresco.desal.service.AlfrescoService.transactionUpdateCustomProperties(AlfrescoService.java:690)
        at cat.aoc.alfresco.desal.CarregaDocumentWebScript.insertaDocument(CarregaDocumentWebScript.java:773)
        at cat.aoc.alfresco.desal.CarregaDocumentWebScript.carregaDocument(CarregaDocumentWebScript.java:239)
        at cat.aoc.alfresco.desal.CarregaDocumentWebScript.execute(CarregaDocumentWebScript.java:127)
        at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:421)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:449)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:483)
        at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:521)
        at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:333)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:30)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:227)
        at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:347)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:662)

Re: Alfresco Explorer blocks properties when I change it?

spilby — Mon, 26 May 2014 15:27:00 GMT

Re: Alfresco Explorer blocks properties when I change it?

sanket — Tue, 27 May 2014 05:40:07 GMT

Also, can you share the java code that you have written in your webscript ?

Re: Alfresco Explorer blocks properties when I change it?

spilby — Tue, 27 May 2014 07:14:02 GMT

Of course, here is the exception:

org.springframework.dao.ConcurrencyFailureException: Failed to update node 291346
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.updateNodeImpl(AbstractNodeDAOImpl.java:1875)
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.touchNode(AbstractNodeDAOImpl.java:1701)
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.setNodePropertiesImpl(AbstractNodeDAOImpl.java:2283)
at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.addNodeProperties(AbstractNodeDAOImpl.java:2387)
at org.alfresco.repo.node.db.DbNodeServiceImpl.addAspectsAndProperties(DbNodeServiceImpl.java:542)
at org.alfresco.repo.node.db.DbNodeServiceImpl.addAspectsAndProperties(DbNodeServiceImpl.java:444)
at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1593)
at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:105)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:215)
at com.sun.proxy.$Proxy42.setProperty(Unknown Source)
at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:252)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.enterprise.repo.sync.SyncPropertyInterceptor.invoke(SyncPropertyInterceptor.java:223)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.alfresco.repo.audit.DisableAuditableBehaviourInterceptor.invoke(DisableAuditableBehaviourInterceptor.java:113)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:161)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.alfresco.repo.transaction.RetryingTransactionInterceptor$1.execute(RetryingTransactionInterceptor.java:79)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:449)
at org.alfresco.repo.transaction.RetryingTransactionInterceptor.invoke(RetryingTransactionInterceptor.java:69)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy15.setProperty(Unknown Source)
at cat.aoc.alfresco.desal.service.AlfrescoService.updateCustomProperties(AlfrescoService.java:439)
at cat.aoc.alfresco.desal.service.AlfrescoService.transactionUpdateCustomProperties(AlfrescoService.java:690)
at cat.aoc.alfresco.desal.CarregaDocumentWebScript.insertaDocument(CarregaDocumentWebScript.java:773)
at cat.aoc.alfresco.desal.CarregaDocumentWebScript.carregaDocument(CarregaDocumentWebScript.java:239)
at cat.aoc.alfresco.desal.CarregaDocumentWebScript.execute(CarregaDocumentWebScript.java:127)
at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:421)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:449)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:483)
at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:521)
at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:333)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:30)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:227)
at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:347)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)

From the alfresco.log. It's thrown when my code call to getNodeService().setProperty. In catalina.log the trace is the same.

Re: Alfresco Explorer blocks properties when I change it?

spilby — Tue, 27 May 2014 07:30:00 GMT

This is the code of my webscript. Not all (is bigger), but the necessary.


public void execute(WebScriptRequest req, WebScriptResponse res) throws IOException, WebScriptException
{

   // AUTENTICATION
    getAuthenticationService().authenticate(usuario, password);

   // PATH WHERE BEGINS TO CREATE NODES
   NodeRef nodeRef = serviceRegistry.getFileFolderService().resolveNamePath(repository.getCompanyHome(), pathInicial).getNodeRef();

   // LIST OF PROPERTIES
   Map properties = new HashMap();
   properties.put(QName.createQName(Constantes.folder, Constants.numExpedienteProperty), numExpediente);
   properties.put(QName.createQName(Constantes.folder, Constants.autorProperty), autor);
   (…)

   // CREATE THE FOLDERS OF THE PATH THAT NOT EXISTS
   boolean newFolder = false;
   StringTokenizer tokenizer = new StringTokenizer(path, "/");
   while (tokenizer.hasMoreTokens()) {
      if (!newFolder) {
         List assocs = new ArrayList();
         assocs = getNodeService().getChildAssocsByPropertyValue(nodeRef, QName.createQName(Constantes.folder, Constants.numExpedienteProperty), numExpediente);
         if (existe) {
             nodeRef = assocs.get(0).getChildRef();
         } else {
             newFolder = true;
         }
    }

    if (newFolder) {
        UserTransaction trx = serviceRegistry.getTransactionService().getNonPropagatingUserTransaction();
       try {
      trx.begin();
           nodeRef = getNodeService().createNode(nodeRef,  ContentModel.ASSOC_CONTAINS, QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, name), tipo, properties).getChildRef();
           trx.commit();
        } catch(Throwable e) {
      trx.rollback();
      logger.error("ERROR: " + e);
      throw new WebScriptException(Status.STATUS_PROPERTIES_ERROR, e.getMessage());
   }    
    }

 } // while


UserTransaction trx = serviceRegistry.getTransactionService().getNonPropagatingUserTransaction();
try {
    trx.begin();
    // CREATE DOCUMENT NODE
    nodeRef = getNodeService().createNode(nodeRef, ContentModel.ASSOC_CONTAINS, QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, nameDoc), tipo, properties).getChildRef();

    // DOCUMENT UPLOAD
    InputStream myInputStream = getFileAsStream(pathDoc);
    BufferedInputStream inputStream = new BufferedInputStream(myInputStream);
    writer = getContentService().getWriter(nodeRef, ContentModel.PROP_CONTENT, true);
    writer.putContent(inputStream);
    trx.commit();
} catch(Throwable e) {
   trx.rollback();
   logger.error("ERROR: " + e);
   throw new WebScriptException(Status.STATUS_CREATE_ERROR, e.getMessage());
}

 // POINTER AT THE PARENT NODE
 NodeRef parent = getNodeService().getPrimaryParent(nodeRef).getParentRef();

 UserTransaction trx = serviceRegistry.getTransactionService().getNonPropagatingUserTransaction();
       
 try {
   trx.begin();
         
       // UPDATE PROPERTIES FROM DOWN TO UP UNTIL A CONDITION X
       while (condition) {
          Long numDocuments = (Long) getNodeService().getProperty(nodeRef, QName.createQName(Constantes.folder, Constantes.numDocuments)) + 1;
          
          // THIS IS THE LINE THAT THROWS THE CONCURRENCY EXCEPTION WHEN SETS THE NODE THAT I CHANGE BEFORE WITH THE ALFRESCO EXPLORER
          getNodeService().setProperty(nodeRef, QName.createQName(Constantes.folder, Constants.numDocumentsProperty), numDocuments);

          nodeRef = getNodeService().getPrimaryParent(nodeRef).getParentRef();
       } // while
       
       trx.commit();
   } catch(Throwable e) {
   trx.rollback();
   logger.error("transactionUpdateCustomProperties - ERROR: " + e);
   throw new WebScriptException(Status.STATUS_PROPERTIES_ERROR, e.getMessage());
   }   

}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco Explorer blocks properties when I change it?

spilby — Tue, 27 May 2014 07:33:00 GMT

I try to put here the complete exception, but the administrators needs to check it before publishing.

This is a fragment of the exception:

org.springframework.dao.ConcurrencyFailureException: Failed to update node 291346
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.updateNodeImpl(AbstractNodeDAOImpl.java:1875)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.touchNode(AbstractNodeDAOImpl.java:1701)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.setNodePropertiesImpl(AbstractNodeDAOImpl.java:2283)
        at org.alfresco.repo.domain.node.AbstractNodeDAOImpl.addNodeProperties(AbstractNodeDAOImpl.java:2387)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.addAspectsAndProperties(DbNodeServiceImpl.java:542)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.addAspectsAndProperties(DbNodeServiceImpl.java:444)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1593)
        at sun.reflect.GeneratedMethodAccessor484.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
(…)

Re: Alfresco Explorer blocks properties when I change it?

sanket — Tue, 27 May 2014 09:04:29 GMT

Can you try this modified webscript code ?
Alfresco internally handles the transactions. I don't think everytime we need to begin and commit each and every transaction.
Do let me know the outcome of this code.


public void execute(WebScriptRequest req, WebScriptResponse res) throws IOException, WebScriptException
{
// AUTENTICATION
getAuthenticationService().authenticate(usuario, password);
// PATH WHERE BEGINS TO CREATE NODES
NodeRef nodeRef = serviceRegistry.getFileFolderService().resolveNamePath(repository.getCompanyHome(), pathInicial).getNodeRef();
// LIST OF PROPERTIES
Map properties = new HashMap();
properties.put(QName.createQName(Constantes.folder, Constants.numExpedienteProperty), numExpediente);
properties.put(QName.createQName(Constantes.folder, Constants.autorProperty), autor);
(…)
// CREATE THE FOLDERS OF THE PATH THAT NOT EXISTS
boolean newFolder = false;
StringTokenizer tokenizer = new StringTokenizer(path, "/");
while (tokenizer.hasMoreTokens()) {
if (!newFolder) {
List assocs = new ArrayList();
assocs = getNodeService().getChildAssocsByPropertyValue(nodeRef, QName.createQName(Constantes.folder, Constants.numExpedienteProperty), numExpediente);
if (existe) {
nodeRef = assocs.get(0).getChildRef();
} else {
newFolder = true;
}
}
if (newFolder) {

try {

nodeRef = getNodeService().createNode(nodeRef, ContentModel.ASSOC_CONTAINS, QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, name), tipo, properties).getChildRef();

} catch(WebScriptException e) {

logger.error("ERROR: " + e);
throw new WebScriptException(Status.STATUS_PROPERTIES_ERROR, e.getMessage());
}   
}
} // while

try {

// CREATE DOCUMENT NODE
nodeRef = getNodeService().createNode(nodeRef, ContentModel.ASSOC_CONTAINS, QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, nameDoc), tipo, properties).getChildRef();
// DOCUMENT UPLOAD
InputStream myInputStream = getFileAsStream(pathDoc);
BufferedInputStream inputStream = new BufferedInputStream(myInputStream);
writer = getContentService().getWriter(nodeRef, ContentModel.PROP_CONTENT, true);
writer.putContent(inputStream);

} catch(WebScriptException e) {

logger.error("ERROR: " + e);
throw new WebScriptException(Status.STATUS_CREATE_ERROR, e.getMessage());
}
// POINTER AT THE PARENT NODE
NodeRef parent = getNodeService().getPrimaryParent(nodeRef).getParentRef();


try {


// UPDATE PROPERTIES FROM DOWN TO UP UNTIL A CONDITION X
while (condition) {
Long numDocuments = (Long) getNodeService().getProperty(nodeRef, QName.createQName(Constantes.folder, Constantes.numDocuments)) + 1;

// THIS IS THE LINE THAT THROWS THE CONCURRENCY EXCEPTION WHEN SETS THE NODE THAT I CHANGE BEFORE WITH THE ALFRESCO EXPLORER
getNodeService().setProperty(nodeRef, QName.createQName(Constantes.folder, Constants.numDocumentsProperty), numDocuments);
nodeRef = getNodeService().getPrimaryParent(nodeRef).getParentRef();
} // while


} catch(WebScriptException e) {

logger.error("transactionUpdateCustomProperties - ERROR: " + e);
throw new WebScriptException(Status.STATUS_PROPERTIES_ERROR, e.getMessage());
}
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco Explorer blocks properties when I change it?

spilby — Tue, 27 May 2014 09:43:00 GMT

At first, I had the code like you recommend me, without transactions. But I had one problem plus.

When I didn't use the transactions, the concurrency exception appeared in two cases: when I delete a node with the Alfresco Explorer, and when I change a property with the Alfresco Explorer. In both cases, the exception was thrown at the same line: when do the setProperty of the node.

An user recommends me put the transactions in the code, each time I do a createNode or addProperties, to solve this. The solution go ok on the first case. Now, with the transactions, if I delete a node with the explorer, the webscript don't give me the exception when my webscript creates the node again and modify the properties. But on the second case (the case that I explain in this thread of the forum) the problem persists.

In resume: the transactions solve one of the two problems, but not all.

This is my webscript xml, for more information:


<webscript>
  <shortname>Web script to create and upload</shortname>
  <description>Return a JSON</description>
  <url>/own/APD/createdocument</url>
  <authentication>user</authentication>
  <format default="json">argument</format>
  <family>Alfresco Java-Backed WebScripts</family>
</webscript>
‍‍‍‍‍‍‍‍‍‍

Re: Alfresco Explorer blocks properties when I change it?

sanket — Tue, 27 May 2014 11:29:48 GMT

Any specific reason of using


UserTransaction trx = serviceRegistry.getTransactionService().getNonPropagatingUserTransaction();
‍‍‍

instead of

 
UserTransaction tx=serviceRegistry.getTransactionService().getUserTransaction();
‍‍‍

Re: Alfresco Explorer blocks properties when I change it?

spilby — Tue, 27 May 2014 11:57:00 GMT

No, simply he recommends me the nonpropagating method, to use a new transaction. Is better option the other? Other users specify the transactionality with the XML.

Anyway, the problem appears using each of this two methods. I don't know what causes the exceptions. Seems that Alfresco Explorer blocks the node and I can't update the properties, until I restart the server. But how can I resolve this?

Re: Alfresco Explorer blocks properties when I change it?

sanket — Tue, 27 May 2014 12:28:30 GMT

Can you try embedding your entire webscript code within a single UserTransaction block


UserTransaction tx=serviceRegistry.getTransactionService().getUserTransaction();
try {
      trx.begin();
            // all your code
           trx.commit();
} catch(WebScriptException e) {
      trx.rollback();
      logger.error("ERROR: " + e);
      throw new WebScriptException(Status.STATUS_PROPERTIES_ERROR, e.getMessage());
   }
‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco Explorer blocks properties when I change it?

mrogers — Tue, 27 May 2014 12:37:08 GMT

One reason to use Alfresco's RetryingTransactionHelper is that it will not leak transactions.     And will retry.

The following code is incorrect and dangerous
try {

      trx.begin();

            // all your code

           trx.commit();

} catch(WebScriptException e) {

The above transaction handling is incorrect and dangerous, what happens if there's something other than a WebScriptException thrown?

Re: Alfresco Explorer blocks properties when I change it?

spilby — Tue, 27 May 2014 14:41:00 GMT

Sorry, my mistake when write the code here. The real catch in my code is Throwable, not WebScriptException.

But how can I use the RetryingTransactionHelper in my code? Is a better option than the begin and commit transaction? I don't use the RetryingTransactionHelper because although I read about this, I don't understand how use it in my code.

Anyway, I understand that the RetryingTransactionHelper can help me if my code blocks a node. But if I don't use the Alfresco Explorer all go without problems. Seems that is the modification with the explorer that blocks the node. But is someone could tell me how I can use the RetryingTransactionHelper in my code, I would be very grateful to test it and comment the results. I don't understand how can I use it, sorry.

Re: Alfresco Explorer blocks properties when I change it?

spilby — Tue, 27 May 2014 14:43:49 GMT

No works, doing it I have another time the exception. I think that use the transaction on each node operation forces the commit and the block that appears when use the Alfresco Explorer dissapears. But I'm not sure if it's the real reason.

Re: Alfresco Explorer blocks properties when I change it?

spilby — Wed, 28 May 2014 06:47:36 GMT

Any help with the RetryingTransactionHelper? Someone who use it? I don't know if it resolves the problem, but I must test it. I try to put in my code but don't works, I think I don't put it ok.

Re: Alfresco Explorer blocks properties when I change it?

sanket — Wed, 28 May 2014 10:46:44 GMT

http://wiki.alfresco.com/wiki/Java_Foundation_API
http://forums.alfresco.com/forum/developer-discussions/repository-services/how-write-code-transactions-06242008-0941

Re: Alfresco Explorer blocks properties when I change it?

spilby — Wed, 28 May 2014 11:52:06 GMT

Yes, this is the post that I had read, but I don't understand how can I adapt it to my code.

For example… I have this simple method:


public NodeRef transactionCreateNode(NodeRef parent, Map<QName, Serializable> properties, String name) throws Exception {
       NodeRef nodeRef = null;
       UserTransaction trx = serviceRegistry.getTransactionService().getNonPropagatingUserTransaction();
      
       try {
         trx.begin();
         nodeRef = this.createNode(parent, properties, name);
         trx.commit();
      } catch(Throwable e) {
         trx.rollback();
         logger.error("transactionCreateNode- ERROR: " + e);
         throw new Exception(e);
      }   
       
       return nodeRef;
    }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Who call the method that creates a node, into a transaction. But if I try to integrate the RetryingTransactionHelper, I suppose that I must do something like this:


public NodeRef transactionCreateNode(NodeRef parent, Map<QName, Serializable> properties, String name) throws Exception {
Boolean result = transactionService.getRetryingTransactionHelper().doInTransaction(new RetryingTransactionHelper.RetryingTransactionCallback<Boolean>(){
    public Boolean execute() throws Throwable {
 
      boolean success= this.createNode(parent, properties, name);
      if (!success)
         throw new IllegalStateException("Error creating node");
 
      return true;
    }   

}, false, true);
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

But the Eclipse give me compilation errors because don't know the createNode method, and parent, properties, name vars. What's incorrect?

Re: Alfresco Explorer blocks properties when I change it?

sanket — Wed, 28 May 2014 12:33:17 GMT

Use this :


RetryingTransactionCallback<Object> txnWork = new RetryingTransactionCallback<Object>()
                {
                    public Object execute() throws Exception
                    {
                        // Your code goes here
                        return result; //return null atleast if you have nothing to return to prevent compilation errors.
                    }
                };
                TransactionService transactionService = serviceRegistry.getTransactionService();
                Object result = transactionService.getRetryingTransactionHelper().doInTransaction(txnWork, true);

‍‍‍‍‍‍‍‍‍‍‍‍‍