-
1. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
the_fredo Jan 20, 2009 11:56 AM (in response to the_fredo)1) is solved by adding a patch I found in the JIRA (a few .xhtml files)
2) the pb remains even with JBoss AS 4.2.3, so it's a pb with jbpm, not with AS.
It's impossible to deploy a process through the deployment' tab of GPD, even with jbpm 3.2.5. The and task does not work either. The only working solution is to save locally a process archive and then upload it through the web console (it works even with the gwt console)
3) I can now login (with manager/manager) in the gwt console but it crashes as long as it requires Birt : could not create connection : user JBPMTEST not found:17:41:52,236 WARN [Parameters] Parameters: Invalid chunk ignored. 17:41:52,453 INFO [ReportFacade] BIRT home: /Developer/Archives/jboss-5.0.0.GA/server/jbpm/data/birt/ReportEngine 17:41:52,456 INFO [ReportFacade] Output dir: /Developer/Archives/jboss-5.0.0.GA/server/jbpm/data/birt/output/ 17:41:52,456 INFO [ReportFacade] Report dir: /Developer/Archives/jboss-5.0.0.GA/server/jbpm/data/birt/ 17:41:52,760 INFO [ReportFacade] BIRT home: /Developer/Archives/jboss-5.0.0.GA/server/jbpm/data/birt/ReportEngine 17:41:52,765 INFO [ReportFacade] Output dir: /Developer/Archives/jboss-5.0.0.GA/server/jbpm/data/birt/output/ 17:41:52,765 INFO [ReportFacade] Report dir: /Developer/Archives/jboss-5.0.0.GA/server/jbpm/data/birt/ 17:41:57,067 INFO [BirtService] Service created: org.eclipse.birt.report.engine.api.impl.ReportEngine@f8a1a13 17:41:57,069 INFO [BirtService] Service created: org.eclipse.birt.report.engine.api.impl.ReportEngine@5573d88b 17:42:04,539 WARN [JBossManagedConnectionPool] Destroying connection that could not be successfully matched: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@5d8a64f3[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@f4681fb handles=0 lastUse=1232469714936 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@5dff8d92 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@34a79c74 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@5ae8300f txSync=null] 17:42:04,544 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: User not found: JBPMTEST) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:611) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:257) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:607) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:104) at org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getDataSourceConnection(JndiDataSource.java:159) at org.eclipse.birt.report.data.oda.jdbc.JndiDataSource.getConnection(JndiDataSource.java:133) at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getJndiDSConnection(JDBCDriverManager.java:227) at ... at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:637) Caused by: java.sql.SQLException: User not found: JBPMTEST at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) at org.hsqldb.jdbcDriver.getConnection(Unknown Source) at org.hsqldb.jdbcDriver.connect(Unknown Source) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207) ... 92 more
Fred -
2. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
kukeltje Jan 20, 2009 2:56 PM (in response to the_fredo)2: look in the server log.... 403 means you do not have access. e.g. because the jbpm user tables are empty.... search the forum and wiki on how to populate these.
-
3. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
jongdakkel Jan 29, 2009 5:34 AM (in response to the_fredo)>> is solved by adding a patch I found in the JIRA (a few .xhtml files)
hi the_fredo may i ask the exact url for the patch you mentioned.
Thanks -
4. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
hkapoor Feb 4, 2009 6:28 AM (in response to the_fredo)I am facing the same problem.
Any body has a solution
Thanks,
Harshit -
5. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
hkapoor Feb 4, 2009 6:37 AM (in response to the_fredo)Upon further investigation I found that JBPM uses following 2 queries
<jaas:module-option name='principalsQuery'>
SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_=? </jaas:module-option>****<jaas:module-option name='rolesQuery'>
SELECT g.NAME_ ,'Roles' FROM JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g
WHERE g.TYPE_='security-role' AND m.GROUP_ = g.ID_ AND m.USER_ = u.ID_ AND u.NAME_=? </jaas:module-option>
</jaas:login-module>
The first query return result if any of admin, user, manager or shipper is used, however the second query does not return any record as tables JBPM_ID_MEMBERSHIP and JBPM_ID_GROUP are empty. -
6. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
the_fredo Feb 4, 2009 7:31 AM (in response to the_fredo)sorry to come back that late, but meanwhile I decided to give up (regarding the installation of those new versions), since I could not be able to find the SQL scripts mentioned by kukeltje to populate the JBPM tables. (nothing had to be done in 3.2.3 but in 3.3.1, SQL scripts have to be executed ?!)
I'll come back when all that stuff is stable and documented (I keep my 3.2.3/AS4 for now !)
Regarding the deployment with GPD's deploy tab : it still does not work, but I succeded in making an Ant task that does the job.
jongdakkel : I'm sorry but this patch was so hard to find that I'm not able to tell you where it is today :-( -
7. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
hkapoor Feb 4, 2009 10:13 AM (in response to the_fredo)Hi!!
I have figured out the scripts that have to be used.
I started by configuring jbpm-3.3.1.GA with jboss-5.0.0.GA with hypersonic as database.
I accessed the installation through http://localhost:8080/jbpm-console and logged in using admin/admin.
This was successfull.
I had a look at the jbpm-hsqldb-ds.xml which stated that temporary data was kept at the following location
jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB
which implies
jboss-5.0.0.GA\server\default\data\hypersonic
There I found jbpmDB.script which contains insert statements to add values to database.
I executed the script against MySQL database that I was using otherwise.
THe insertion failed due to constraints violation, I followed following to get around this problem:
Created Tables only and not constraints and index(from first 32 queries jbpm.jpdl.mysql.sql)
Altered table JBPM_NODE to change datatype of ENDTASKS_ from BIT(1) to INTEGER
Inserted data in database
Created index and constraints (from remainder of jbpm.jpdl.mysql.sql)
Please do not forget to remove all record in JBPM_ID_USER table before inserting records, otherwise primarykey violation will be generated.
Restarted jboss-5.0.0.GA and accessed the installation through http://localhost:8080/jbpm-console thereafter logged in using admin/admin -
8. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
hkapoor Feb 4, 2009 10:17 AM (in response to the_fredo)Hi,
I am still not able to deploy using GPD. Can someone point me to information that for alternate means of deployment.
Regards,
Harshit -
9. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
kukeltje Feb 4, 2009 10:51 AM (in response to the_fredo)I am still not able to deploy using GPD
what are the errors? Oh, the JBPM_ID_MEMBERSHIP and JBPM_ID_GROUP should not be empty.
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4171023#4171023 -
10. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
the_fredo Feb 4, 2009 12:15 PM (in response to the_fredo)Harshit, you can try Kurt Stam's Ant task : http://kurtstam.blogspot.com/2008/01/jbpm-ant-task-to-deploy-process.html
It worked for me
Fred -
11. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
hkapoor Feb 5, 2009 9:14 AM (in response to the_fredo)Thanks for the link Fred.
I tried it out, however I am getting the following error
couldn't deploy process archives : Server returned HTTP response code: 403 for URL: http://localhost:8080/jbpm-console/app/upload
When I use http://localhost:8080/jbpm-console/upload ping to the server fails.
Please help!
Regards,
Harshit -
12. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
hkapoor Feb 5, 2009 9:31 AM (in response to the_fredo)I also tried uploading par file created as a result of failed deployment through web console. It produced following error.
exception
javax.servlet.ServletException: java.lang.String
javax.faces.webapp.FacesServlet.service(FacesServlet.java:277)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
root cause
java.lang.ClassCastException: java.lang.String
javax.faces.component.UISelectBoolean.isSelected(UISelectBoolean.java:106)
com.sun.faces.renderkit.html_basic.CheckboxRenderer.getEndTextToRender(CheckboxRenderer.java:137)
com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:160)
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:861)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:937)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
javax.faces.render.Renderer.encodeChildren(Renderer.java:148)
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
org.jboss.gravel.common.renderer.RendererBase.doEncode(RendererBase.java:80)
org.jboss.gravel.common.renderer.RendererBase.doEncode(RendererBase.java:96)
org.jboss.gravel.simple.renderer.SimpleRenderer.encodeChildren(SimpleRenderer.java:53)
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:837)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:930)
javax.faces.component.UIComponent.encodeAll(UIComponent.java:933)
com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:189)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) -
13. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
hkapoor Feb 5, 2009 11:00 AM (in response to the_fredo)Hi All,
It seems that this is a known issue. Anybody has a fix for it.
https://jira.jboss.org/jira/browse/SOA-1052?focusedCommentId=12442611#action_12442611
Regards,
Harshit -
14. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
asrickard Feb 21, 2009 3:13 AM (in response to the_fredo)"hkapoor@ciber.com" wrote:
There I found jbpmDB.script which contains insert statements to add values to database.
I executed the script against MySQL database that I was using otherwise.
Interestingly I was unable to find a file with the same name. I am (attempting to) using jBpm 3.3.1GA, on an existing JBoss 5.0.0GA installation with Seam 2.1.0. Instead of the file, I eventually found the insert statements in the User Guide (section 8.1.5).
Separately, I have been getting the same errors reported elsewhere about taglibs missing."Missing Built-in Tag Libraries! Make sure they are included within the META-INF directory of Facelet s' Jar"
This is apparently fixed by updating to a later version of facelets (jsf-facelets-1.1.15.B1.jar). After much mucking around and time-wasting, I found that Seam needs to be updated as well as the jBpm. Maybe this is obvious to some, but it was not to me. Hopefully my experience will assist someone else.
Maybe someone could start a "How To" to get jBPM running on something other than the default installation suite?