Displaying metadata problem

zladuric — Mon, 07 Dec 2009 20:29:33 GMT

Hello, I have a community install, version 3.0 of Alfrecso. I have some custom metadata (amounts), and there are some problems. The metadata for certain types of documents of this type seems fine, both in database and when i view the properties in the web client. But in the Share, when the users lo

Re: Displaying metadata problem

mikeh — Mon, 07 Dec 2009 21:27:41 GMT

Load-up Firefox and add the JSONview add-on. Then point it at your pay-tasks-list.json.ftl URL (the one in the /alfresco webapp). This will highlight the error in your JSON syntax.

By the way, the reason you're seeing thousand separators is because you've forgotten to add the Freemarker built-in "?c" when rendering numbers. See the Freemarker documentation for further information.

Thanks,
Mike

Re: Displaying metadata problem

zladuric — Mon, 07 Dec 2009 21:51:52 GMT

Thanks Mike, this sounds reeealy encouraging! For the ?c part, I have an excuse - I just got to work here, I didn't make these scripts

Anyway, one more question, if you're still around: what would be a path to my script?

http://server/alfresco/service/what? How could I find out?

Re: Displaying metadata problem

zladuric — Mon, 07 Dec 2009 22:00:51 GMT

The original script is at: extensions/templates/webscripts/protenus-pay/pay-tasks.get.json.ftl…how would I call it? Can I copy it somewhere?

Re: Displaying metadata problem

mikeh — Mon, 07 Dec 2009 22:14:19 GMT

Find the .desc.xml file ("next to" the .json.ftl) - then add the URL specified within that descriptor file to http://server/alfresco/service/

Thanks,
Mike

Re: Displaying metadata problem

zladuric — Mon, 07 Dec 2009 22:18:37 GMT

Thank you bunches and bunches, Mike!

The more I learn about Alfresco, the more I love/hate its complexity

Re: Displaying metadata problem

zladuric — Mon, 07 Dec 2009 23:28:21 GMT

Mike, your hints were really helpfull, I found out that when the filter=today the json I get is valid, but with filter=all, the script does some skipping and things.

Can you answer one more question to help me out, please?

How would I find out what content is connected to what tasks so I can clean out a bit? In the database or in the workflow console (which I just discovered by googling)?

Thanks again!

Re: Displaying metadata problem

zladuric — Tue, 08 Dec 2009 00:17:38 GMT

I mean, I found workflows with no resources attached. How do I kill those workflows?

P.S. Or tasks?

When I try (admin workflow console), I get:
org.alfresco.error.AlfrescoRuntimeException: Failed to execute transaction-level behaviour public abstract void org.alfresco.repo.node.NodeServicePolicies$OnUpdatePropertiesPolicy.onUpdateProperties(org.alfresco.service.cmr.repository.NodeRef,java.util.Map,java.util.Map) in transaction 149b34ea-c9b9-48cf-b039-c9b672fb64d8

And of course, catalina.out:
02:15:54,773 User:admin DEBUG [alfresco.repo.workflow] Detached (rollback) JBPM Context from transaction 149b34ea-c9b9-48cf-b039-c9b672fb64d8
02:15:54,855 User:admin DEBUG [repo.transaction.RetryingTransactionHelper]
Transaction commit failed:
   Thread: TP-Processor6
   Txn:    UserTransaction[object=org.alfresco.util.transaction.SpringAwareUserTransaction@67df5608, status=4]
   Iteration: 0
   Exception follows:
javax.transaction.RollbackException: Transaction didn't commit: Failed to execute transaction-level behaviour public abstract void org.alfresco.repo.node.NodeServicePolicies$OnUpdatePropertiesPolicy.onUpdateProperties(org.alfresco.service.cmr.repository.NodeRef,java.util.Map,java.util.Map) in transaction 149b34ea-c9b9-48cf-b039-c9b672fb64d8
        at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:477)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:336)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:229)
        at org.alfresco.repo.admin.BaseInterpreter$1.doWork(BaseInterpreter.java:164)
        at org.alfresco.repo.admin.BaseInterpreter$1.doWork(BaseInterpreter.java:154)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)
        at org.alfresco.repo.admin.BaseInterpreter.interpretCommand(BaseInterpreter.java:153)
        at org.alfresco.web.bean.workflow.WorkflowConsoleBean.interpretCommand(WorkflowConsoleBean.java:196)
        at org.alfresco.web.bean.workflow.WorkflowConsoleBean.submitCommand(WorkflowConsoleBean.java:161)
        at sun.reflect.GeneratedMethodAccessor1011.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
        at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
        at javax.faces.component.UICommand.broadcast(UICommand.java:109)
        at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
        at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
        at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
        at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
        at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
        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.AdminAuthenticationFilter.doFilter(AdminAuthenticationFilter.java:80)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
        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.core.StandardHostValve.invoke(StandardHostValve.java:128)
        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:286)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.alfresco.error.AlfrescoRuntimeException: Failed to execute transaction-level behaviour public abstract void org.alfresco.repo.node.NodeServicePolicies$OnUpdatePropertiesPolicy.onUpdateProperties(org.alfresco.service.cmr.repository.NodeRef,java.util.Map,java.util.Map) in transaction 149b34ea-c9b9-48cf-b039-c9b672fb64d8
        at org.alfresco.repo.policy.TransactionBehaviourQueue.execute(TransactionBehaviourQueue.java:201)
        at org.alfresco.repo.policy.TransactionBehaviourQueue.beforeCommit(TransactionBehaviourQueue.java:133)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:710)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:690)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:650)
        at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:835)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:645)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:467)
        … 41 more
Caused by: org.alfresco.repo.security.permissions.AccessDeniedException: Access Denied. You do not have the appropriate permissions to perform this operation.
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:53)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy7.hasAspect(Unknown Source)
        at org.alfresco.repo.thumbnail.ThumbnailedAspect.onUpdateProperties(ThumbnailedAspect.java:144)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.policy.JavaBehaviour$JavaMethodInvocationHandler.invoke(JavaBehaviour.java:179)
        at $Proxy11.onUpdateProperties(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor872.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.policy.TransactionBehaviourQueue.execute(TransactionBehaviourQueue.java:189)
        … 51 more
Caused by: net.sf.acegisecurity.AccessDeniedException: Access is denied.
        at net.sf.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:86)
        at net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:394)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:77)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        … 70 more

Re: Displaying metadata problem

mikeh — Tue, 08 Dec 2009 14:33:56 GMT

The root cause of the exception is "Access Denied" - are you sure you're trying with the local admin user account?

Thanks,
Mike

Re: Displaying metadata problem

zladuric — Tue, 08 Dec 2009 15:03:38 GMT

I was logged in with admin - admin workflow console wouldn't load any other way, but ni there I had set the 'user' variable. Anyway, I solved that problem, finally. It was really dirty but it was also urgent, and I'm still trying to find my way around here.
So, what I did is located all those workflows that didn't have any resources attached, went to the mysql, and changed the bpm:assignee (to a test user) for all the JBPM_TASKINSTANCE instances. Then I was left with only the double-quotes in JSON, which I could deal with by editing metadata. I know this was risky, the database thing, but I was on a short notice, I had backups, it was night, and I needed to try something
And I figured that I changed the assignee, then I wouldn't get the error with the original user. The logic I used is that those extra workflows are some misconfiguration too, as my installation (well, it will be my installation when I get to know it a bit) is not supposed to have ANY tasks that have no resources. I just hope it doesn't backfire (didn't for now, the testing and one whole production day are over).

topic Displaying metadata problem in Alfresco Archive

Displaying metadata problem

Re: Displaying metadata problem

Re: Displaying metadata problem

Re: Displaying metadata problem

Re: Displaying metadata problem

Re: Displaying metadata problem

Re: Displaying metadata problem

Re: Displaying metadata problem

Re: Displaying metadata problem

Re: Displaying metadata problem