Forums de discussion

Workflow portlet with Liferay 5.0.1 RC1

siddesh k kamath, modifié il y a 15 années.

Workflow portlet with Liferay 5.0.1 RC1

New Member Publications: 6 Date d'inscription: 20/05/08 Publications récentes
Goal : To use the workflow portlet with jbpm workflow engine

1. Downloaded and installed liferay 5.0.1 RC1 on glassfish. It comes up fine
2. Followed the document :
http://docs.huihoo.com/liferay/4.2/installation-guide/ch05s05.html
3. Downloaded liferay-portal-servicemix-4.2.x.war and liferay-portal-jbpm-4.2.x.war
4. Deploy this in glassfish
5. After this deploy, If I access http://localhost:8080, I am not able to get the liferay index page

Getting the following error in logs :

[#|2008-06-11T13:34:28.109+0530|INFO|sun-appserver9.1|javax.enterprise.system.st
ream.out|_ThreadID=14;_ThreadName=JbpmScheduler;|13:34:28,109 INFO [SchedulerTh
read:79] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.jav
a:88)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread
.java:106)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
using iterate
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:65)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:410)
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl
.java:310)
at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.j
ava:170)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1139)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:46)
at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.jav
a:82)
... 2 more
Caused by: java.sql.SQLException: Table not found in statement [select timer0_.I
D_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and ti
mer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:442)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:368)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
... 7 more
|#]

Questions :
1. do liferay-portal-servicemix-4.2.x.war and liferay-portal-jbpm-4.2.x.war work with liferay 5.0.1 RC ?
2. Does the workflow require any extra tables to be created in the db ?
Ganesh Ram, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

Regular Member Publications: 199 Date d'inscription: 05/02/08 Publications récentes
Hi Siddesh,

I have got the liferay-portal-mule-web-4.4.2.war, liferay-portal-servicemix-4.2.x.war and liferay-portal-jbpm-4.2.x.war work with liferay 5.0.1 RC. emoticon

LR workflow Portlet does not work when servicemix esb is used. It works with Mule.
See here http://support.liferay.com/browse/LEP-3551 for details.

Make sure that the jbi.workflow.url property in portal-impl/sc/portal.properties points to http://localhost:8080/mule-web/workflow. This means that we will use the mule esb (and not service mix ).

check out the plugins directory of jbpm from here https://lportal.svn.sourceforge.net/svnroot/lportal/plugins.

Go to trunk\webs\jbpm-web\docroot\WEB-INF\sql directory and run the appropriate sql script based on your DB choice. This will create the needed tables.
The error that you are getting is because the tables (JBPM_TIMER) are not created.

Modify the hibernate.cfg.xml in liferay-portal-jbpm-4.2.x.war, to point to your appropriate database. The default points to hsql. I used MySQL.

Now Deploy liferay-portal-mule-web-4.4.2.war and liferay-portal-jbpm-4.2.x.war with the context roots as mule-web and jbpm-web respectively. The defaults expects that your port is 8080.


You should be ready to go now !!!
siddesh k kamath, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

New Member Publications: 6 Date d'inscription: 20/05/08 Publications récentes
Hi Ganesh,

Thanks a lot!!!
It worked perfectly fine.
thumbnail
Laurent Dreuillat, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

Junior Member Publications: 78 Date d'inscription: 07/04/08 Publications récentes
Hi all,

When I try to compile the source code for jbpm-web (from SVN https://lportal.svn.sourceforge.net/svnroot/lportal/plugins) I got a lot of compilation problems with Liferay 5.0 and 5.1 (classes not found)!
Any ideas on this problem?

merge:
[mkdir] Created dir: D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\classes
[copy] Copying 5 files to D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\lib
[javac] Compiling 16 source files to D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\classes
[javac] D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\src\com\liferay\jbpm\db\GraphSession.java:33: package com.liferay.util.dao.hibernate does not exist
[javac] import com.liferay.util.dao.hibernate.QueryPos;
[javac] ^
[javac] D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\src\com\liferay\jbpm\db\GraphSession.java:34: package com.liferay.util.dao.hibernate does not exist
[javac] import com.liferay.util.dao.hibernate.QueryUtil;
[javac] ^
[javac] D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\src\com\liferay\jbpm\db\JbpmCustomSQLUtil.java:35: package com.liferay.util.dao.hibernate does not exist
[javac] extends com.liferay.util.dao.hibernate.CustomSQLUtil {
[javac] ^
[javac] D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\src\com\liferay\jbpm\db\GraphSession.java:189: cannot find symbol
[javac] symbol : class QueryPos
[javac] location: class com.liferay.jbpm.db.GraphSession
[javac] QueryPos qPos = QueryPos.getInstance(q);
[javac] ^
[javac] D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\src\com\liferay\jbpm\db\GraphSession.java:189: cannot find symbol
[javac] symbol : variable QueryPos
[javac] location: class com.liferay.jbpm.db.GraphSession
[javac] QueryPos qPos = QueryPos.getInstance(q);
[javac] ^
[javac] D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\src\com\liferay\jbpm\db\GraphSession.java:277: cannot find symbol
[javac] symbol : class QueryPos
[javac] location: class com.liferay.jbpm.db.GraphSession
[javac] QueryPos qPos = QueryPos.getInstance(q);
[javac] ^
[javac] D:\tmp\liferay-svn\trunk\webs\jbpm-web\docroot\WEB-INF\src\com\liferay\jbpm\db\GraphSession.java:277: cannot find symbol
[javac] symbol : variable QueryPos
[javac] location: class com.liferay.jbpm.db.GraphSession
[javac] QueryPos qPos = QueryPos.getInstance(q);
[javac] ^

Thanks,

Laurent
thumbnail
auditya manikanta vadrevu, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

Liferay Master Publications: 621 Date d'inscription: 06/05/08 Publications récentes
hi ganesh,

I have delpoyed mule-web and jbpm-web 4.4.2 war files and done all the work as u said i.e.., enabling mule-web in portal-ext.properties and changing hibernate.cfg.xml , Then also i got some errors


04:47:10,726 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
04:47:10,779 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Node]; using defaults.
04:47:11,036 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.instantiation.Delegation]; using defaults.
04:47:11,064 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
04:47:11,263 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
04:47:11,339 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
04:47:11,753 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.taskmgmt.def.Task]; using defaults.
04:47:11,870 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
04:47:12,054 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
04:47:12,167 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
04:47:12,285 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
04:47:12,557 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.taskmgmt.def.Task.exceptionHandlers]; using defaults.
04:47:12,564 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Transition.exceptionHandlers]; using defaults.
04:47:12,564 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.nodes]; using defaults.
04:47:12,566 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.actions]; using defaults.
04:47:12,566 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Node.arrivingTransitions]; using defaults.
04:47:12,567 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Node.exceptionHandlers]; using defaults.
04:47:12,567 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks]; using defaults.
04:47:12,568 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers]; using defaults.
04:47:12,568 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.action.Script.variableAccesses]; using defaults.
04:47:12,570 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Node.events]; using defaults.
04:47:12,570 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.definitions]; using defaults.
04:47:12,571 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.file.def.FileDefinition.processFiles]; using defaults.
04:47:12,571 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Node.leavingTransitions]; using defaults.
04:47:12,572 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.node.ProcessState.variableAccesses]; using defaults.
04:47:12,573 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.events]; using defaults.
04:47:12,574 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes]; using defaults.
04:47:12,574 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.taskmgmt.def.Task.events]; using defaults.
04:47:12,575 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.node.TaskNode.tasks]; using defaults.
04:47:12,575 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.node.Decision.decisionConditions]; using defaults.
04:47:12,576 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Transition.events]; using defaults.
04:47:12,576 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.taskmgmt.def.Swimlane.tasks]; using defaults.
04:47:12,577 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.ExceptionHandler.actions]; using defaults.
04:47:12,577 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.taskmgmt.def.TaskController.variableAccesses]; using defaults.
04:47:12,577 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.Event.actions]; using defaults.
04:47:12,578 WARN [EhCacheProvider:103] Could not find configuration [org.jbpm.graph.def.SuperState.nodes]; using defaults.
04:47:12,859 INFO [SessionFactoryObjectFactory:82] Not binding factory to JNDI, no JNDI name configured
04:47:12,860 INFO [SessionFactoryImpl:353] Checking 28 named HQL queries
04:47:13,166 INFO [SessionFactoryImpl:373] Checking 0 named SQL queries






and my portal page is not accessible now , it looks like this. Now what could be the problem

Pièces jointes:

thumbnail
Brant Levinson, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

Junior Member Publications: 48 Date d'inscription: 12/07/08 Publications récentes
I followed the above info and was able to get the workflow to work. All of my other components are using servicemix. I tried using servicemix for this and it gave me several errors. Any way to get this working?
Ganesh Ram, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

Regular Member Publications: 199 Date d'inscription: 05/02/08 Publications récentes
Brant,

I dont think it works on ServiceMix.
Lets keep tracking LEP-3551
abed alrahman M.F alrbeei, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

New Member Publications: 2 Date d'inscription: 28/12/08 Publications récentes
hello

i was do the step that where explain above, but i get this error in log file

com.liferay.portal.kernel.jbi.WorkflowComponentException: org.dom4j.DocumentException: Unexpected end of file from server Nested exception: Unexpected end of file from server
at com.liferay.portlet.workflow.service.impl.WorkflowComponentServiceImpl.deploy(WorkflowComponentServiceImpl.java:98)
at com.liferay.portlet.workflow.service.impl.WorkflowDefinitionServiceImpl.addDefinition(WorkflowDefinitionServiceImpl.java:81)
at com.liferay.portlet.workflow.service.impl.WorkflowDefinitionServiceImpl.addDefinition(WorkflowDefinitionServiceImpl.java:65)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
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 $Proxy456.addDefinition(Unknown Source)
at com.liferay.portlet.workflow.service.WorkflowDefinitionServiceUtil.addDefinition(WorkflowDefinitionServiceUtil.java:62)
at com.liferay.portlet.workflow.action.EditDefinitionAction.addDefinition(EditDefinitionAction.java:120)
at com.liferay.portlet.workflow.action.EditDefinitionAction.processAction(EditDefinitionAction.java:63)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:178)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:197)
at com.sun.portal.portletcontainer.appengine.filter.FilterChainImpl.doFilter(FilterChainImpl.java:93)
at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:57)
at com.liferay.portlet.InvokerPortlet.invoke(InvokerPortlet.java:548)
at com.liferay.portlet.InvokerPortlet.invokeAction(InvokerPortlet.java:577)
at com.liferay.portlet.InvokerPortlet.processAction(InvokerPortlet.java:313)
at com.liferay.portal.action.LayoutAction.processPortletRequest(LayoutAction.java:618)
at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:403)
at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:188)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:164)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:444)
at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationDispatcher.doInvoke(ApplicationDispatcher.java:855)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:542)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:474)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:366)
at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:117)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.compression.CompressionFilter.processFilter


before this error i get duplicate file error, and i delete the jackrabbit folder ,

how to fix this problem?

and if you please tell me how to set the jbi.workflow.url to http://localhost:8080/mule-web/workflow in glassfish liferay portal , i can do that on tomcat , but i can't find the portal.properties at L.R.glassfish folder

thanks
abed alrahman M.F alrbeei, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

New Member Publications: 2 Date d'inscription: 28/12/08 Publications récentes
after i add portal-ext.properties file to L.R classes folder, i get this message in log file :



********************************************************************************
* Message received in component: workflowInbound. Content is: '{cmd=deploy, *
* userId=2, xml=<?xml version="1.0"?><process-definition *
* name="datatypes"><!-- Event Logg...[100 of 2003]' *
********************************************************************************
|#]

[#|2008-12-30T10:58:34.216+0200|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-2;|10:58:34,216 INFO [MuleClient:228] There is already a manager available to this client locally, no need to create a new one
|#]

[#|2008-12-30T10:58:34.216+0200|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=22;_ThreadName=httpSSLWorkerThread-8080-2;|10:58:34,216 INFO [LogComponent:42]
********************************************************************************
* Message received in component: workflowInbound. Content is: *
* '{cmd=getDefinitionXml, userId=2, definitionId=0, timeZoneId=GMT}' *
********************************************************************************
|#]

[#|2008-12-30T10:58:34.247+0200|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=23;_ThreadName=httpSSLWorkerThread-8080-0;|10:58:34,247 ERROR [EditDefinitionAction:77] com.liferay.portal.kernel.jbi.WorkflowComponentException: java.lang.NullPointerException
com.liferay.portal.kernel.jbi.WorkflowComponentException: java.lang.NullPointerException
at com.liferay.portlet.workflow.service.impl.WorkflowComponentServiceImpl.getDefinition(WorkflowComponentServiceImpl.java:111)
at com.liferay.portlet.workflow.service.impl.WorkflowDefinitionServiceImpl.getDefinition(WorkflowDefinitionServiceImpl.java:158)
at com.liferay.portlet.workflow.service.impl.WorkflowDefinitionServiceImpl.addDefinition(WorkflowDefinitionServiceImpl.java:117)
at com.liferay.portlet.workflow.service.impl.WorkflowDefinitionServiceImpl.addDefinition(WorkflowDefinitionServiceImpl.java:65)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
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 $Proxy456.addDefinition(Unknown Source)
at com.liferay.portlet.workflow.service.WorkflowDefinitionServiceUtil.addDefinition(WorkflowDefinitionServiceUtil.java:62)
at com.liferay.portlet.workflow.action.EditDefinitionAction.addDefinition(EditDefinitionAction.java:120)
at com.liferay.portlet.workflow.action.EditDefinitionAction.processAction(EditDefinitionAction.java:63)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:178)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:197)
at com.sun.portal.portletcontainer.appengine.filter.FilterChainImpl.doFilter(FilterChainImpl.java:93)
at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:57)
at com.liferay.portlet.InvokerPortlet.invoke(InvokerPortlet.java:548)
at com.liferay.portlet.InvokerPortlet.invokeAction(InvokerPortlet.java:577)
at com.liferay.portlet.InvokerPortlet.processAction(InvokerPortlet.java:313)
at com.liferay.portal.action.LayoutAction.processPortletRequest(LayoutAction.java:618)
at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:403)
at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:188)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:164)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:444)
at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationDispatcher.doInvoke(ApplicationDispatcher.java:855)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:542)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:474)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:366)
at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:117)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.compression.CompressionFilter.processFilter(CompressionFilter.java:141)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:282)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:74)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.layoutcache.LayoutCacheFilter.processFilter(LayoutCacheFilter.java:422)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:199)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.sso.opensso.OpenSSOFilter.processFilter(OpenSSOFilter.java:73)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.doFilter(VirtualHostFilter.java:185)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198|#]

[#|2008-12-30T10:58:34.247+0200|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=23;_ThreadName=httpSSLWorkerThread-8080-0;|)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:132)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:74)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
Caused by: java.lang.NullPointerException
at com.liferay.portlet.workflow.jbi.WorkflowXMLUtil.parseDefinition(WorkflowXMLUtil.java:91)
at com.liferay.portlet.workflow.jbi.WorkflowXMLUtil.parseDefinition(WorkflowXMLUtil.java:87)
at com.liferay.portlet.workflow.service.impl.WorkflowComponentServiceImpl.getDefinition(WorkflowComponentServiceImpl.java:108)
... 117 more



can someone tell me what to do now ?

regards
Khoa Dang TU, modifié il y a 15 années.

RE: Workflow portlet with Liferay 5.0.1 RC1

New Member Publications: 6 Date d'inscription: 05/01/09 Publications récentes
I have the same probs, can you help me

siddesh k kamath:
Goal : To use the workflow portlet with jbpm workflow engine

1. Downloaded and installed liferay 5.0.1 RC1 on glassfish. It comes up fine
2. Followed the document :
http://docs.huihoo.com/liferay/4.2/installation-guide/ch05s05.html
3. Downloaded liferay-portal-servicemix-4.2.x.war and liferay-portal-jbpm-4.2.x.war
4. Deploy this in glassfish
5. After this deploy, If I access http://localhost:8080, I am not able to get the liferay index page

Getting the following error in logs :

[#|2008-06-11T13:34:28.109+0530|INFO|sun-appserver9.1|javax.enterprise.system.st
ream.out|_ThreadID=14;_ThreadName=JbpmScheduler;|13:34:28,109 INFO [SchedulerTh
read:79] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.jav
a:88)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread
.java:106)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:70)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
using iterate
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:65)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:410)
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl
.java:310)
at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.j
ava:170)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1139)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:46)
at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.jav
a:82)
... 2 more
Caused by: java.sql.SQLException: Table not found in statement [select timer0_.I
D_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and ti
mer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:442)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:368)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
... 7 more
|#]

Questions :
1. do liferay-portal-servicemix-4.2.x.war and liferay-portal-jbpm-4.2.x.war work with liferay 5.0.1 RC ?
2. Does the workflow require any extra tables to be created in the db ?
th