Forums

Home » Liferay Portal » English » 2. Using Liferay » General

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Patrick Patrick
Error on display of "workflow Task"
January 9, 2013 1:39 PM
Answer

Patrick Patrick

Rank: New Member

Posts: 8

Join Date: December 23, 2012

Recent Posts

Hi
I followed the example described in this link to create a workflow in the portlet " Documents and Media ".
http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/lp-6-1-ugen10-using-workflow-with-other-applications-0

I subject a document with an account administrato.. This account receives an email with the message " You have has new submission waiting for your review in the workflow. "

When I go to Control Panel = > Test Test = > My Workflow Tasks = > Pending
The list is empty. It generates the message following in catalina.out :
21:14:44,942 ERROR [http-bio-8080-exec-7][JDBCExceptionReporter:76] invalid ORDER BY expression
21:14:44,945 WARN [http-bio-8080-exec-7][view_workflow_tasks_jspf:2620] Error retrieving tasks for user 2
com.liferay.portal.kernel.workflow.WorkflowException: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
at com.liferay.portal.workflow.kaleo.WorkflowTaskManagerImpl.search(WorkflowTaskManagerImpl.java:560)
at sun.reflect.GeneratedMethodAccessor757.invoke(Unknown Source)

When I go to Control Panel = > Test Test = > My Workflow Tasks = > Completed
Or Control Panel = > Test Test = > My Submissions = > Pending or
Control Panel = > Test Test = > My Submissions = > Completed
I have the error message :"An error occurred while retrieving the list of publication requests. Please contact an administrator. ".

When I search on the Net, I find this message for a bug which was corrected in 2010.
I installed(settled) " kaleo-web-6.1.0.1-ce-ga1-20120106155615 760.war " in "liferay-portal-6.1.1-ce-ga2 / deploy"
Would anybody have the solution?

Thank you for your help
Patrick
Vishal Panchal
RE: Error on display of "workflow Task"
January 9, 2013 6:35 PM
Answer

Vishal Panchal

Rank: Expert

Posts: 280

Join Date: May 20, 2012

Recent Posts

Hi Patric,

It looks like because of exception below your whole workflow is getting messed up.

com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query

So AFAIK this exception comes when hibernate is not able to find the same column names in tables as ones listed in mapping file.

Try after clearing database cache. and if not

So , All you can do is
Stop your server.
delete temp and work directories from tomcat.
from webapps folder romove kaleo related portlets.
from your database drop all the (Kaleo related) tables starting by kaleo_
start your server
deploy kaleo portlets
test it again.

Thanks&Regards,
Vishal R. Panchal
Rashmi Rajappa
RE: Error on display of "workflow Task"
January 14, 2013 1:43 PM
Answer

Rashmi Rajappa

Rank: New Member

Posts: 23

Join Date: April 27, 2009

Recent Posts

I have tried this on Mysql and Hypersonic. But never faced this situation.
Which database are you using?
Was the deployment of kaleo successful?
Parikshit Sharma
RE: Error on display of "workflow Task"
January 17, 2013 4:57 AM
Answer

Parikshit Sharma

Rank: New Member

Posts: 21

Join Date: January 16, 2013

Recent Posts

Hi,
I suggest you to check the workflowLog, using WorkflowLogManagerUtil class.
Patrick Patrick
RE: Error on display of "workflow Task"
January 17, 2013 1:45 PM
Answer

Patrick Patrick

Rank: New Member

Posts: 8

Join Date: December 23, 2012

Recent Posts

Hi
I install "Liferay Portal 6.1 Community Edition Bundled with tomcat".
http://www.liferay.com/downloads/liferay-portal/available-releases

Database :
Postgre is installed on my server but I have never indicated to Liferay a base, an account and a password.
I think this installation of Liferay use "Liferay's built-in data source" As indicated here :
http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/lp-6-1-ugen11-installing-liferay-on-tomcat-7-0 Chapter Database Configuration
My ROOT.xml is As attachment.
Can be that it is the reason so that Kaelo does not find SGBD ?

Kaleo instalation
To install(settle) kaleo, I just have to copy the file "kaleo-web-6.1.0.1-ce-ga1-20120106155615760.war" to .../liferay-portal-6.1.1-ce-ga2/deploy
So I don't know if the deployment of kaleo was successful. Just I can configure the workflow for control panel

That have to I make?
Thank you
Attachments: ROOT.xml (0.6k)
Patrick Patrick
RE: Error on display of "workflow Task"
January 17, 2013 1:47 PM
Answer

Patrick Patrick

Rank: New Member

Posts: 8

Join Date: December 23, 2012

Recent Posts

Hi

I have not much knowledge in Java.

Can You indicate me the line of comman to use WorkflowLogManagerUtil class ?

Thank You
Patrick Patrick
RE: Error on display of "workflow Task"
January 17, 2013 1:58 PM
Answer

Patrick Patrick

Rank: New Member

Posts: 8

Join Date: December 23, 2012

Recent Posts

Hi Vishal Panchal

Thank you for your answer.
At the moment, I do not know where is my database and how to reach it as I explained it in another comment.
That I shall can I shall follow your advice

Patrick
Jacques Traore
RE: Error on display of "workflow Task"
January 28, 2013 7:24 AM
Answer

Jacques Traore

Rank: Junior Member

Posts: 46

Join Date: January 21, 2013

Recent Posts

Hi there,
I am facing the same problem and can't figure it out.
I noticed the problem also appears with Oracle 11g (with both servers Tomcat 7.0.27 and Weblogic 10.3.5).
The first error about this in liferay.log is
1[http-bio-8081-exec-10][JDBCExceptionReporter:76] invalid ORDER BY expression

I guest something wrongs in a hibernate query but don't how to catch the query.
I am going to consider the WorkflowTaskManagerImpl.java class.
I'll let you know if I find something.


Jacques
Jacques Traore
RE: Error on display of "workflow Task"
January 29, 2013 1:30 PM
Answer

Jacques Traore

Rank: Junior Member

Posts: 46

Join Date: January 21, 2013

Recent Posts

Hi all,
Finally I could figure out the kaleo-web problem.
In fact there is 2 possibilities:
1- modify the kaleo-web source by adding the 2 following fields in the select clause in kaleotaskinstancetoken.xml (kaleotaskinstancetoken.duedate, kaleotaskinstancetoken.kaleotaskid ) and redeploy the war (drag and drop in hot deploy folder)
2- I think this one is the best solution, download the latest version of kaleo plugin from liferay website via "Control panel --> plugins installation --> (button) Install more plugins --> Apps tab (on left)" and click on "see all" of the second pane. Then search for "Kaleo Workflow CE". Follow the directives.
I also attached the latest version of kaleo plugin to this post.

Note: the extension is lpkg, but it must be deployed like a war file. ie drag and drop into the hot-deploy folder.

Patrick, please let me know if this helps you.
Attachments: 15193893_17458604_17458606.lpkg (2,554.9k)