Can't edit property/upload new version/delete doc in share

[ashwini]

Hello There,
When user try to add document as new version, edit properties or even delete document .

Uploading as a new version
1.Click on upload as a new version
2. it ask to select the file 
3. After selecting file, when I click on "upload files " , it responds really slow and after long wait , it show message "undefined (25 KB) Success", (it changes files name name with  undefined )
4. Here when I click on "Ok" , and check the uploaded file , it shows old version of that file.

edit properties
After entering new values into edit properties form and click on save. It throws exception as below :

org.springframework.dao.ConcurrencyFailureException: Failed to update node 313092; nested exception is org.springframework.dao.CannotAcquireLockException: 
   ### Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
   ### The error may involve alfresco.node.update_Node-Inline
   ### The error occurred while setting parameters
   ### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
   ; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction‍‍‍‍‍‍‍

Delete:
It does not allow to delete some file.
Users, who tries to upload document as new version and edit properties has collaborator permission on the space. Even When I tried to perform these operation with admin account, nothing has been changed.

My environment is:

OS Ubuntu 10.04
Alfresco 4.0.c with tomcat 1.6 and Mysql 5.1
When I checked log file I found below error message.

2012-07-26 12:12:10,785  ERROR [extensions.webscripts.AbstractRuntime] [http-8080-59] Exception from executeScript - redirecting to status template error: 06260678 Wrapped Exception (with status template): 06264439 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 06264438 Content conversion failed: 
   reader: ContentAccessor[ contentUrl=store://2012/7/26/12/12/80d388b7-1774-457e-ab25-0392177f7392.bin, mimetype=application/pdf, size=59298, encoding=UTF-8, locale=de_DE]
   writer: ContentAccessor[ contentUrl=store://2012/7/26/12/12/480ac513-c709-4429-a007-d0dda74d62a7.bin, mimetype=application/x-shockwave-flash, size=0, encoding=UTF-8, locale=de_DE]
   options: org.alfresco.service.cmr.repository.TransformationOptions@349b4e8a
 org.springframework.extensions.webscripts.WebScriptException: 06260678 Wrapped Exception (with status template): 06264439 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 06264438 Content conversion failed: 
   reader: ContentAccessor[ contentUrl=store://2012/7/26/12/12/80d388b7-1774-457e-ab25-0392177f7392.bin, mimetype=application/pdf, size=59298, encoding=UTF-8, locale=de_DE]
   writer: ContentAccessor[ contentUrl=store://2012/7/26/12/12/480ac513-c709-4429-a007-d0dda74d62a7.bin, mimetype=application/x-shockwave-flash, size=0, encoding=UTF-8, locale=de_DE]
   options: org.alfresco.service.cmr.repository.TransformationOptions@349b4e8a
   at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:971)
   at org.alfresco.repo.web.scripts.content.StreamContent.execute(StreamContent.java:211)
   at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:400)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:462)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:500)
   at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:316)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:372)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
   at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   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:58)
   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 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
   at java.lang.Thread.run(Thread.java:662)
Caused by: org.alfresco.scripts.ScriptException: 06264439 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js': 06264438 Content conversion failed: 
   reader: ContentAccessor[ contentUrl=store://2012/7/26/12/12/80d388b7-1774-457e-ab25-0392177f7392.bin, mimetype=application/pdf, size=59298, encoding=UTF-8, locale=de_DE]
   writer: ContentAccessor[ contentUrl=store://2012/7/26/12/12/480ac513-c709-4429-a007-d0dda74d62a7.bin, mimetype=application/x-shockwave-flash, size=0, encoding=UTF-8, locale=de_DE]
   options: org.alfresco.service.cmr.repository.TransformationOptions@349b4e8a
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:195)
   at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)
   at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:174)
   at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)
   at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1194)
   at org.alfresco.repo.web.scripts.content.StreamContent.execute(StreamContent.java:155)
   … 25 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 06264438 Content conversion failed: 
   reader: ContentAccessor[ contentUrl=store://2012/7/26/12/12/80d388b7-1774-457e-ab25-0392177f7392.bin, mimetype=application/pdf, size=59298, encoding=UTF-8, locale=de_DE]
   writer: ContentAccessor[ contentUrl=store://2012/7/26/12/12/480ac513-c709-4429-a007-d0dda74d62a7.bin, mimetype=application/x-shockwave-flash, size=0, encoding=UTF-8, locale=de_DE]
   options: org.alfresco.service.cmr.repository.TransformationOptions@349b4e8a
   at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:177)
   at org.alfresco.repo.content.ContentServiceImpl.transform(ContentServiceImpl.java:569)
   at sun.reflect.GeneratedMethodAccessor968.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 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.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:125)
   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:147)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy52.transform(Unknown Source)
   at org.alfresco.repo.rendition.executer.AbstractTransformationRenderingEngine.render(AbstractTransformationRenderingEngine.java:71)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeRenditionImpl(AbstractRenderingEngine.java:504)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine$1.doWork(AbstractRenderingEngine.java:428)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine$1.doWork(AbstractRenderingEngine.java:408)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeImpl(AbstractRenderingEngine.java:407)
   at org.alfresco.repo.rendition.executer.AbstractRenderingEngine.executeImpl(AbstractRenderingEngine.java:369)
   at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:196)
   at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:780)
   at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:700)
   at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:538)
   at sun.reflect.GeneratedMethodAccessor744.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.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
   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:147)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy37.executeAction(Unknown Source)
   at org.alfresco.repo.rendition.RenditionServiceImpl.executeRenditionAction(RenditionServiceImpl.java:281)
   at org.alfresco.repo.rendition.RenditionServiceImpl.render(RenditionServiceImpl.java:183)
   at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnailNode(ThumbnailServiceImpl.java:588)
   at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.access$000(ThumbnailServiceImpl.java:67)
   at org.alfresco.repo.thumbnail.ThumbnailServiceImpl$1.doWork(ThumbnailServiceImpl.java:262)
   at org.alfresco.repo.thumbnail.ThumbnailServiceImpl$1.doWork(ThumbnailServiceImpl.java:259)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:519)
   at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnail(ThumbnailServiceImpl.java:258)
   at org.alfresco.repo.thumbnail.ThumbnailServiceImpl.createThumbnail(ThumbnailServiceImpl.java:222)
   at sun.reflect.GeneratedMethodAccessor1104.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.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
   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:147)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy123.createThumbnail(Unknown Source)
   at org.alfresco.repo.jscript.ScriptNode.createThumbnail(ScriptNode.java:2744)
   at sun.reflect.GeneratedMethodAccessor785.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
   at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
   at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)
   at org.mozilla.javascript.gen.c11._c1(file:/opt/alfresco-4.0.c/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js:68)
   at org.mozilla.javascript.gen.c11.call(file:/opt/alfresco-4.0.c/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
   at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
   at org.mozilla.javascript.gen.c11._c0(file:/opt/alfresco-4.0.c/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js:109)
   at org.mozilla.javascript.gen.c11.call(file:/opt/alfresco-4.0.c/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
   at org.mozilla.javascript.gen.c11.call(file:/opt/alfresco-4.0.c/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
   at org.mozilla.javascript.gen.c11.exec(file:/opt/alfresco-4.0.c/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/repository/thumbnail/thumbnail.get.js)
   at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:483)
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:191)
   … 30 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: 06264437 Transformation failed - status indicates an error: 
Execution result: 
   os:         Linux
   command:    [/opt/alfresco-4.0.c/common/bin/pdf2swf, -T, 9, -s, zoom=72, -s, ppmsubpixels=1, -s, poly2bitmap=1, -s, bitmapfonts=1, /opt/alfresco-4.0.c/tomcat/temp/Alfresco/RuntimeExecutableContentTransformerWorker_source_2255821533099230658.pdf, -o, /opt/alfresco-4.0.c/tomcat/temp/Alfresco/RuntimeExecutableContentTransformerWorker_target_6355238359773754281.swf]
   succeeded:  false
   exit code:  1
   out:        ERROR   Couldn't open /opt/alfresco-4.0.c/tomcat/temp/Alfresco/RuntimeExecutableContentTransformerWorker_source_2255821533099230658.pdf

   err:        Error: Incorrect password

   at org.alfresco.repo.content.transform.RuntimeExecutableContentTransformerWorker.transform(RuntimeExecutableContentTransformerWorker.java:272)
   at sun.reflect.GeneratedMethodAccessor787.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:65)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy11.transform(Unknown Source)
   at org.alfresco.repo.content.transform.ProxyContentTransformer.transformInternal(ProxyContentTransformer.java:68)
   at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:161)
   … 119 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Could anybody help me to resolve this issue.

Thanks in advance!!

Regards,
Ashwini

[kevinr]

Maybe it is because the PDF is password protected?
>err:        Error: Incorrect password

Can you try a non-password protected version - does that work? if so, it sounds like a bug as it should allow you to upload the document even if the transformer is not allowed to generate a preview due to the password protection. Please raise an issues on issues.alfresco.com if this is the case.

Thanks,

Kev

[ashwini]

Thanks for a reply Kev.

I am aware about below error, and this exceptions gets throwed if someone tried to view Password Protected file

Maybe it is because the PDF is password protected?
>err: Error: Incorrect password

And Below exception I am getting for normal files(Files which are not protected by password)

org.springframework.dao.ConcurrencyFailureException: Failed to update node 313092; nested exception is org.springframework.dao.CannotAcquireLockException: 
   ### Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
   ### The error may involve alfresco.node.update_Node-Inline
   ### The error occurred while setting parameters
   ### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
   ; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction‍‍‍‍‍‍

After getting above exception If I click on Repository I gets message in red strip "No Item"

but after tomcat restart sometimes I can able to perform some operations.

Let me raise issue in for this
Regards,
Ashwini

[kevinr]

This was a known MySQL issue to do with locks being held more than they should:
https://issues.alfresco.com/jira/browse/ALF-9978

It's been fixed on the various Enterprise branches - and will be fixed in the next Community release which is coming soon.

Kev