Error on display of "workflow Task"

[Patrick Patrick, geändert vor 11 Jahren.]

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, geändert vor 11 Jahren.]

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

[Patrick Patrick, geändert vor 11 Jahren.]

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, geändert vor 11 Jahren.]

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

[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, geändert vor 11 Jahren.]

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.

[Rashmi Rajappa, geändert vor 11 Jahren.]

I have tried this on Mysql and Hypersonic. But never faced this situation.
Which database are you using?
Was the deployment of kaleo successful?

[Patrick Patrick, geändert vor 11 Jahren.]

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

[Parikshit Sharma, geändert vor 11 Jahren.]

Hi,
I suggest you to check the workflowLog, using WorkflowLogManagerUtil class.

[Patrick Patrick, geändert vor 11 Jahren.]

Hi

I have not much knowledge in Java.

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

Thank You