Bug 783744

Summary: Jbpm-console error was found due to "ProcessInstanceLog is not mapped "
Product: [JBoss] JBoss Enterprise BRMS Platform 5 Reporter: Ryan Zhang <rzhang>
Component: BRM (Guvnor)Assignee: Toni Rikkola <trikkola>
Status: VERIFIED --- QA Contact: Lukáš Petrovický <lpetrovi>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: BRMS 5.3.0.GACC: jcoleman, kverlaen, trikkola
Target Milestone: ---   
Target Release: BRMS 5.3.0.GA   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
server.log
none
jbpm-console-snapshot.png none

Description Ryan Zhang 2012-01-22 05:10:52 UTC 
Description of problem:

This is the block issue for BRMS 5.3.0 ER3 release.
The following exception was thrown and jbpm-console not working when I try to access the sample process.

I also attached the "server.log" and a snapshort for reference.
A workaround or bug fix is required before the ER3 can be released.

java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: ProcessInstanceLog is not mapped [FROM ProcessInstanceLog p WHERE p.processId = :processId AND p.end is null]
	org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:601)
	org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:96)
	org.jbpm.process.audit.JPAProcessInstanceDbLog.findActiveProcessInstances(JPAProcessInstanceDbLog.java:114)
	org.jbpm.integration.console.CommandDelegate.getActiveProcessInstanceLogsByProcessId(CommandDelegate.java:109)
	org.jbpm.integration.console.ProcessManagement.getProcessInstances(ProcessManagement.java:64)
	org.jboss.bpm.console.server.ProcessMgmtFacade.getInstancesJSON(ProcessMgmtFacade.java:189)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
	org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
	org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
	org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
	org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
	org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
	org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
	org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
Version-Release number of selected component (if applicable):

BRMS 5.3.0.ER3(it is not released yet, but it used the latest bits in jbpm 5.2.x branch)
How reproducible:


Steps to Reproduce:
1.Start brms standalone server
2.import the jbpm-sample-repository.xml in jboss-brms console
3.log into jbpm-console and click Process overview and click the "Evaluation" process, the error can be shown.
  
Actual results:


Expected results:
jbpm-console should be functional

Additional info:
Comment 1 Ryan Zhang 2012-01-22 05:13:48 UTC 
Created attachment 556747 [details]
server.log
Comment 2 Ryan Zhang 2012-01-22 05:14:28 UTC 
Created attachment 556748 [details]
jbpm-console-snapshot.png
Comment 3 Ryan Zhang 2012-01-22 05:16:50 UTC 
I am looking for a workaround to this issue in order to pass the ER3 to QE ASAP.
Comment 4 Ryan Zhang 2012-01-22 05:21:11 UTC 
    Technical note added. If any revisions are required, please edit the "Technical Notes" field
    accordingly. All revisions will be proofread by the Engineering Content Services team.
    
    New Contents:
The standalone server which can reproduce the issue  can be downloaded at http://download.devel.redhat.com/brewroot/work/tasks/9604/3959604/org/jboss/brms-p/5.3.0.BRMS-ER3/brms-p-5.3.0.BRMS-ER3-standalone.zip
Comment 5 Ryan Zhang 2012-01-23 02:17:25 UTC 
I moved the AuditLog.hbm.xml from jbpm-bam.jar/AuditLog.hbm.xml to jbpm-bam.jar/META-INF/AuditLog.hbm.xml, then the problem disappeared.

I temporarily did this patch in platform build level. Please fix it in jbpm branch.
Thanks
Comment 6 Kris Verlaenen 2012-01-24 15:03:17 UTC 
We tried to make sure you can configure all persistence in one persistence.xml, so I think just adding these classes to the (already existing) persistence.xml should solve the issue:

<class>org.jbpm.process.audit.ProcessInstanceLog</class>
<class>org.jbpm.process.audit.NodeInstanceLog</class>
<class>org.jbpm.process.audit.VariableInstanceLog</class>
Comment 8 Ryan Zhang 2012-02-08 02:04:59 UTC 
Yes, This issue is fixed as  Bugzilla 784004 was resolved.
Comment 9 Ryan Zhang 2012-02-15 09:12:57 UTC 
Please verify the issue on 5.3 ER4.
Comment 10 Zuzana Krejčová 2012-02-22 11:01:15 UTC 
Where can I get the jbpm-sample-repository.xml? Please attach it or add a link.
Comment 11 Ryan Zhang 2012-02-22 11:15:17 UTC 
Zuzana, I understood why you can't find it since the actual name of the file is jbpm_example_repository.xml
You can find it in relative path：
[rzhang@jawa37g3 brms-standalone-5.3.0]$ find . -name "jbpm_example_repository.xml"
./jboss-as/server/production/deploy/jboss-brms.war/WEB-INF/classes/jbpm_example_repository.xml
./jboss-as/server/default/deploy/jboss-brms.war/WEB-INF/classes/jbpm_example_repository.xml
Comment 13 lcarlon 2012-05-03 03:25:59 UTC 
Hi Ryan.

I've removed the instructions you provided from the technical note field as notes in that field are used for the release notes.

Thanks
Lee
Comment 14 lcarlon 2012-05-03 03:25:59 UTC 
Deleted Technical Notes Contents.

Old Contents:
The standalone server which can reproduce the issue  can be downloaded at http://download.devel.redhat.com/brewroot/work/tasks/9604/3959604/org/jboss/brms-p/5.3.0.BRMS-ER3/brms-p-5.3.0.BRMS-ER3-standalone.zip