Cannot submit content to workflow

[mcmagi]

I am receiving the following error message when I attempt to submit a file that was part of a task that has since been rejected:

The following items cannot be submitted as they are already part of a workflow.

It seems Alfresco thinks it's still a part of some workflow process.  How can I remove it from the workflow?

Thanks,
- Michael C. Maggio
   NCS Technologies

[mcmagi]

Ok, that appeared to do the trick.  However, we now we receive an error when we attempt to complete some of the tasks.

     * A system error happened during the operation: Failed to signal transition '' from workflow task 'jbpm$129'‍

We have since made some changes to the sandbox that affects some of the articles which were in the workflow.  For example, we moved them by copying & pasting the files elsewhere and reverting the folders they were originally submitted in.  I believe that may be related to the above error.

So are these tasks now forever stuck here or is there some way we can get past the above error?

Note that the files we pasted are still missing the submit icon and still associated with a workflow task, so I'm hoping we'll be able to resubmit them once we complete these tasks.  The only reason why this is significant to us is we have a lot of content (about 50 generated files) in this status that would take a lot of time to re-enter.

[mcmagi]

Also, all the extra tasks are resulting in very long startup times for the virtualization server.  Since it creates a separate webapp for each workflow item, the restart time is now at about 15 minutes.

[edgar]

I have the same problem as reported.

Check the task list of the user who initially contributed the task and ensure that you click on the "Task Done" button.

However when I open my particular task there is no "Task Done" button. The only button is the Close button. In my completed task list the task in question  has the Outcome set to 'Approve' (and not Done).

In my case it may have something to do this issue: "Could not execute JDBC batch update" error but I'm not sure.

I seem to be a bit stuck now since I cannot get the items out of the workflow.

[davidc]

The JDBC update exception has now been investigated and oddly enough will be found on most databases except MySQL.  A fix will go into HEAD today.

[kvc]

A quick follow-up on Dave's behalf, who just checked in a fix for this.  This will roll into an updated Community build in the next two weeks.

Fix to fix for JBPM unique constraint issue.  SQL should work against all DBs now.
———————————————————————————-

                 Key: CHK-771
                 URL: http://issues.alfresco.com/browse/CHK-771
             Project: Check In
          Issue Type: Check In
      HEAD or Branch: HEAD
          Components: Installation

–Overview–
Fix to fix for JBPM unique constraint issue.  SQL should work against all DBs now.

You should no longer get:

15:18:26,524 ERROR [domain.schema.SchemaBootstrap] Statement
execution failed:
    SQL:  UPDATE JBPM_PROCESSINSTANCE SET KEY_ = '' || ID_ WHERE KEY_
IS NULL
    Error: Duplicate entry '1-5' for key 2

[mcmagi]

Hey guys.  Thanks for the replies, but unfortunately, this is not the same thing as what's happening in my case.  When I examine the tomcat logs for the Alfresco GUI (not the virtualization server) I see the following:

16:32:37,624 WARN  [alfresco.missingProperties] Failed to find property 'wcmwf:label' for node: workspace://SpacesStore/89b63fd4-29a4-11dc-92f3-dd0c4e84196f
16:32:39,680 ERROR [graph.def.GraphElement] action threw exception: Path /www/avm_webapps/ROOT/article_library/exercise/benefits_of_fitness/belly_fat_1 not found.
org.alfresco.service.cmr.avm.AVMNotFoundException: Path /www/avm_webapps/ROOT/article_library/exercise/benefits_of_fitness/belly_fat_1 not found.
        at org.alfresco.repo.avm.AVMStoreImpl.hasAspect(AVMStoreImpl.java:1262)
        at org.alfresco.repo.avm.AVMRepository.hasAspect(AVMRepository.java:2211)
        at org.alfresco.repo.avm.AVMServiceImpl.hasAspect(AVMServiceImpl.java:1312)
        at sun.reflect.GeneratedMethodAccessor490.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
        at org.alfresco.repo.transaction.RetryingTransactionAdvice.invoke(RetryingTransactionAdvice.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
        at $Proxy57.hasAspect(Unknown Source)
        at org.alfresco.repo.avm.wf.AVMSubmittedAspect.clearSubmitted(AVMSubmittedAspect.java:93)
        at org.alfresco.repo.avm.wf.AVMClearSubmittedHandler.execute(AVMClearSubmittedHandler.java:104)
        at org.jbpm.graph.def.Action.execute(Action.java:123)
        at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:235)
        at org.jbpm.graph.def.GraphElement.executeActions(GraphElement.java:212)
        at org.jbpm.graph.def.GraphElement.fireAndPropagateEvent(GraphElement.java:182)
        at org.jbpm.graph.def.GraphElement.fireEvent(GraphElement.java:166)
        at org.jbpm.graph.def.GraphElement$$FastClassByCGLIB$$7a7d6aa6.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:163)
        at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
        at org.jbpm.graph.def.ProcessDefinition$$EnhancerByCGLIB$$55df8199.fireEvent(<generated>)
        at org.jbpm.graph.exe.ProcessInstance.end(ProcessInstance.java:257)
        at org.jbpm.graph.exe.ProcessInstance$$FastClassByCGLIB$$5167cc59.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:163)
        at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
        at org.jbpm.graph.exe.ProcessInstance$$EnhancerByCGLIB$$1ca47168.end(<generated>)
        at org.jbpm.graph.exe.Token.notifyParentOfTokenEnd(Token.java:261)
        at org.jbpm.graph.exe.Token.end(Token.java:233)
        at org.jbpm.graph.exe.Token.end(Token.java:193)
        at org.jbpm.graph.node.EndState.execute(EndState.java:46)
        at org.jbpm.graph.def.Node.enter(Node.java:316)
        at org.jbpm.graph.def.Node$$FastClassByCGLIB$$d187eeda.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:163)
        at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
        at org.jbpm.graph.def.Node$$EnhancerByCGLIB$$f326d529.enter(<generated>)
        at org.jbpm.graph.def.Transition.take(Transition.java:119)
        at org.jbpm.graph.def.Node.leave(Node.java:383)
        at org.jbpm.graph.node.TaskNode.leave(TaskNode.java:198)
        at org.jbpm.graph.node.TaskNode$$FastClassByCGLIB$$923668a4.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:163)
        at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
        at org.jbpm.graph.node.TaskNode$$EnhancerByCGLIB$$2d6ccb73.leave(<generated>)
        at org.jbpm.graph.exe.Token.signal(Token.java:174)
        at org.jbpm.graph.exe.Token.signal(Token.java:145)
        at org.jbpm.graph.exe.Token$$FastClassByCGLIB$$74df1c6e.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:163)
        at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:161)
        at org.jbpm.graph.exe.Token$$EnhancerByCGLIB$$9fb57bbd.signal(<generated>)
        at org.jbpm.taskmgmt.exe.TaskInstance.end(TaskInstance.java:444)
        at org.alfresco.repo.workflow.jbpm.WorkflowTaskInstance.end(WorkflowTaskInstance.java:126)
        at org.jbpm.taskmgmt.exe.TaskInstance.end(TaskInstance.java:383)
        at org.alfresco.repo.workflow.jbpm.JBPMEngine$19.doInJbpm(JBPMEngine.java:1049)
        at org.springmodules.workflow.jbpm31.JbpmTemplate$1.doInHibernate(JbpmTemplate.java:87)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)
        at org.springmodules.workflow.jbpm31.JbpmTemplate.execute(JbpmTemplate.java:80)
        at org.alfresco.repo.workflow.jbpm.JBPMEngine.endTask(JBPMEngine.java:1017)
        at org.alfresco.repo.workflow.WorkflowServiceImpl.endTask(WorkflowServiceImpl.java:347)
        at sun.reflect.GeneratedMethodAccessor1362.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:116)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
        at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentImpl.java:219)
        at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:165)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
        at $Proxy22.endTask(Unknown Source)
        at org.alfresco.web.bean.workflow.ManageTaskDialog.transition(ManageTaskDialog.java:389)
        at sun.reflect.GeneratedMethodAccessor7901.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129)
        at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
        at javax.faces.component.UICommand.broadcast(UICommand.java:106)
        at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
        at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
        at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
        at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
        at javax.faces.webapp.FacesServlet.service(FacesServlet.java:105)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I see an addition exception below it which contains the error we see on the front-end.  (truncated here due to length)

16:32:39,691 ERROR [ui.common.Utils] A system error happened during the operation: Failed to signal transition '' from workflow task 'jbpm$129'
org.alfresco.service.cmr.workflow.WorkflowException: Failed to signal transition '' from workflow task 'jbpm$129'
        at org.alfresco.repo.workflow.jbpm.JBPMEngine.endTask(JBPMEngine.java:1064)
        at org.alfresco.repo.workflow.WorkflowServiceImpl.endTask(WorkflowServiceImpl.java:347)
        at sun.reflect.GeneratedMethodAccessor1362.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
‍‍‍‍‍‍‍‍‍

If you need more info or the full set of stack traces, please let me know.

[kvc]

Can you file a support case here?  This warrants investigation.

[mcmagi]

Thanks Kevin.  This is filed as support case WCM-624