1 2 Previous Next 16 Replies Latest reply on Nov 17, 2009 8:29 AM by renaud staessens

    Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA

    Fred Mac Newbie

      Hi !

      Maybe I missed something, but I have some basic problems with jbpm 3.3.1 GA/JBoss AS 5.0.0 GA (Java 6)

      1) http://localhost:8080/jbpm-console/app/processes.jsf produces an empty page with a stack trace already posted in that group : http://www.jboss.com/index.html?module=bb&op=viewtopic&t=146972
      I read in https://jira.jboss.org/jira/browse/JBPM-1913 that this issue should be fixed in 3.3.1 but it's not what I observe. Upgrading the jsf-facelets jar improves the situation a little bit, but it crashed when you click on 'examine'.

      2) the server upload path in the deployment tab of GPD does not work anymore (i.e. /jbpm-console/upload). I tried /jbpm-console/app/upload. It seems to work for the connection testing but I got the same stack trace as for 1)
      Moreover, the deployment of the PD does not work with /jbpm-console/app/upload : I got an HTTP 403 in the Eclipse's Server Log, even with the new jsf-facelet.jar

      java.io.IOException: Server returned HTTP response code: 403 for URL: http://localhost:8080/jbpm-console/app/upload
      at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1170)
      at org.jbpm.gd.jpdl.util.ProcessDeployer.deployProcessWithServlet(Unknown Source)
      at org.jbpm.gd.jpdl.util.ProcessDeployer.access$3(Unknown Source)
      at org.jbpm.gd.jpdl.util.ProcessDeployer$1.run(Unknown Source)
      ...



      3) the new GWT console requires a login/password. Does someone know them ? If yes, could you tell me where it is documented (I spent hours browsing jboss docs and googling but I did not find anything)

      Thanks in advance !

      Fred


        • 1. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
          Fred Mac Newbie

          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
            Ronald van Kuijk Master

            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
              Jong Tenerife Newbie

              >> 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
                Harshit Kapoor Newbie

                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
                  Harshit Kapoor Newbie

                  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_ ,&apos;Roles&apos; FROM JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g
                  WHERE g.TYPE_=&apos;security-role&apos; 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
                    Fred Mac Newbie

                    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
                      Harshit Kapoor Newbie

                      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
                        Harshit Kapoor Newbie

                        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
                          Ronald van Kuijk Master

                           

                          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

                          • 11. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
                            Harshit Kapoor Newbie

                            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
                              Harshit Kapoor Newbie

                              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)


                              • 14. Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA
                                Andrew Newbie

                                 

                                "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?

                                1 2 Previous Next