1 2 Previous Next 21 Replies Latest reply on Sep 21, 2009 6:07 AM by R C

    JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA

    R C Newbie

      Hey Every1,

      I've installed and configured JBPM 4.1 using Sybase (yes yes I know...why) on JBoss 5.1.0GA.

      Everything seems ok but when I access the Reporting Screen (Process Reports) I get this error in the logs:

      java.sql.SQLException:
      Caused by: java.sql.SQLException: Login failed
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
      at net.sourceforge.jtds.jdbc.TdsCore.tdsLoginAckToken(TdsCore.java:2952)
      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2260)
      at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:602)
      at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:344)
      at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
      at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnec
      tion(LocalManagedConnectionFactory.java:207)

      I am using JTDS to connect to Sybase and wanted to know if this error is pertaining to DTM (Distributed Transaction Management). On a related note I added the "jbpmtest" user and pass to the jbpm.hibernate.cfg.xml contained in this directory jboss.home\server\default\deploy\jbpm\jbpm-service.sar

      ....
       <property name="hibernate.dialect">org.hibernate.dialect.SybaseDialect</property>
       <property name="hibernate.connection.datasource">java:JbpmDS</property>
       <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
       <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
       <property name="hibernate.connection.username">jbpmtest</property>
       <property name="hibernate.connection.password">jbpmtest</property>
      ....
      


      Yet I still get a Login Failed error which leads me to believe that the error is misleading??? Any ideas or feedback?

      Thanks

        • 1. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
          Ronald van Kuijk Master

          can you get access to the DB at all? I see no jBPM related line in the stacktrace so I suggest to make e.g. a very small test in the AS to check that (or test the connection from e.g. JOPR)

          • 2. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
            R C Newbie

            thanks for quick reply, kukeltje :)

            well I can login to the console using alex/password which is part of the test data inserted into the DB. All the other menu tabs seem to work fine and don't throw any errors.

            Once I get to the reporting tab then the error shows up in the log file. A similar error appeared when I tried JBPM 4.1 + mySQL + Jboss 5.1.0GA. It said user 'sa'@localhost was not valid, etc. That's when I inserted the jbpmtest user/pass into the jbpm.hibernate.cfg.xml (overriding the 'sa' user?). That solved it on mySQL but not for Sybase.

            I've attached more of the log, from the point where you click on the Reporting Tab -> Available Reports -> Processes

            2009-09-14 13:01:20,375 INFO [org.eclipse.birt.report.model.metadata.StructRefPropertyType] (http-127.0.0.1-8080-4) The value of the structure property is a string
            2009-09-14 13:01:20,422 INFO [org.eclipse.birt.report.model.metadata.StructRefPropertyType] (http-127.0.0.1-8080-4) The value of the structure property is a string
            2009-09-14 13:01:23,562 INFO [org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager] (http-127.0.0.1-8080-4) Found JDBC driverinfo extension: driverClass=org.apache.derby.jdbc.EmbeddedDriver, connectionFactory=null
            2009-09-14 13:01:23,578 INFO [org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager] (http-127.0.0.1-8080-4) Found JDBC driverinfo extension: driverClass=org.eclipse.birt.report.data.oda.sampledb.Driver, connectionFactory=org.eclipse.birt.report.data.oda.sampledb.SampleDBJDBCConnectionFactory
            2009-09-14 13:01:23,609 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (http-127.0.0.1-8080-4) Destroying connection that could not be successfully matched: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@1f9f777[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1a7125b handles=0 lastUse=1252926080375 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1a632f5 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@5b9ec1 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@1e5c671 txSync=null]
            2009-09-14 13:01:23,625 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (http-127.0.0.1-8080-4) Destroying connection that could not be successfully matched: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@23cda8[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@1139a51 handles=0 lastUse=1252926071376 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1a632f5 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@5b9ec1 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@1b84919 txSync=null]
            2009-09-14 13:01:23,641 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] (http-127.0.0.1-8080-4) Throwable while attempting to get a new connection: null
            org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Login failed)
             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:633)
             at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
             at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:622)
             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:284)
             at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:205)
             at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:179)
             at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:220)
             at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:151)
             at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
             at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)
             at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)
             at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)
             at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
             at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
             at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
             at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)
             at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
             at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
             at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
             at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:482)
             at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)
             at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
             at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
             at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
             at org.eclipse.birt.report.engine.executor.GridItemExecutor.execute(GridItemExecutor.java:64)
             at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
             at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
             at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
             at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
             at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
             at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
             at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
             at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
             at org.jboss.bpm.report.BirtService.render(BirtService.java:163)
             at org.jboss.bpm.report.ReportFacade.viewReportHtml(ReportFacade.java:139)
             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:597)
             at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
             at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
             at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
             at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
             at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
             at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
             at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
             at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
             at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
             at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
             at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
             at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
             at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
             at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
             at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
             at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
             at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
             at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
             at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
             at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
             at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
             at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
             at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
             at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
             at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
             at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
             at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
             at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
             at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
             at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
             at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
             at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
             at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
             at java.lang.Thread.run(Thread.java:619)
            Caused by: java.sql.SQLException: Login failed
             at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
             at net.sourceforge.jtds.jdbc.TdsCore.tdsLoginAckToken(TdsCore.java:2952)
             at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2260)
             at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:602)
             at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:344)
             at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
             at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
             at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)
             ... 81 more


            I suspect this line might allude to it being a DTM error:
            (http-127.0.0.1-8080-4) Throwable while attempting to get a new connection: null

            Here's a shot of the Datasource file: jbpm-sybase-ds.xml file

            <datasources>
             <local-tx-datasource>
             <jndi-name>JbpmDS</jndi-name>
             <connection-url>jdbc:jtds:sybase://{servername edited}:7550/jbpmdb</connection-url>
             <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
             <user-name>jbpmtest</user-name>
             <password>jbpmtest</password>
            
             <!-- reduce isolation from the default level (repeatable read) -->
             <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
             <!-- separate connections used with and without JTA transaction -->
             <no-tx-separate-pools />
             <!-- disable transaction interleaving -->
             <track-connection-by-tx />
             <metadata>
             <type-mapping>Sybase</type-mapping>
             </metadata>
             </local-tx-datasource>
            </datasources>
            


            I have tried it with an XA datasource and it doesn't even startup properly:

            13:16:54,328 ERROR [JDBCExceptionReporter] Unable to get managed connection for JbpmDS; - nested thr
            owable: (javax.resource.ResourceException: Unable to get managed connection for JbpmDS)


            • 3. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
              R C Newbie

              alas DTM is enabled on the DB (well according to the DBA) so i'm still unsure as to what is causing this error...

              • 4. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                R C Newbie

                Ok, this is insanely weird but it in Firefox & Chrome the error keeps popping up. I then tried IE and no error....so it's a browser issue?

                That makes me a sad panda :(

                • 5. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                  Ronald van Kuijk Master

                  A datasource not being able to get a connection on an AS being related to the type of browser being used??? Hmmm... I can hardly imagine that. (not that I know what the cause may be) Unless there is a bug in the pages, but since I know none of the developers working on the console/reports use Windows (Mac/Linux) I cannot imagine it is a bug in that area either.

                  You may want to try the console forum https://www.jboss.org/community/wiki/BPMConsole

                  • 6. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                    R C Newbie

                    Scratch that - IE finally succumbed and threw the error again.

                    Yeah I agree...it doesn't make sense.

                    • 7. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                      Ronald van Kuijk Master

                      phew..... hahaha....

                      The only thing I can think of is that the reporting uses a different connection and accompanying configuration then you and I think it does. But I don't have any knowledge in that area. As mentioned before, You might have more luck in the console forum

                      • 8. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                        Joram Barrez Master

                        The BIRT reporting engine uses a JNDI datasource: java:/JbpmDS. So you'll have to change the datasource file that is installed which point by default to the hsqldb.

                        • 9. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                          R C Newbie

                          kukeltje: hehehe. yep i think so as well
                          jbarrez: That's what i thought. do you mean this file -> {jboss.home}\server\default\deploy\jbpm\jbpm-service.sar\jbpm.hibernate.cfg.xml

                          my file currently looks like this:

                          <?xml version="1.0" encoding="utf-8"?>
                          
                          <!DOCTYPE hibernate-configuration PUBLIC
                           "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
                           "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
                          
                          <hibernate-configuration>
                           <session-factory>
                          
                           <property name="hibernate.dialect">org.hibernate.dialect.SybaseDialect</property>
                           <property name="hibernate.connection.datasource">java:JbpmDS</property>
                           <property name="hibernate.connection.username">jbpmtest</property>
                           <property name="hibernate.connection.password">jbpmtest</property>
                           <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
                           <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
                           <property name="jta.UserTransaction">UserTransaction</property>
                          
                           <mapping resource="jbpm.repository.hbm.xml" />
                           <mapping resource="jbpm.execution.hbm.xml" />
                           <mapping resource="jbpm.history.hbm.xml" />
                           <mapping resource="jbpm.task.hbm.xml" />
                           <mapping resource="jbpm.identity.hbm.xml" />
                          
                           </session-factory>
                          </hibernate-configuration>
                          


                          i added these two lines to try force the user but still no luck:
                          <property name="hibernate.connection.username">jbpmtest</property>
                           <property name="hibernate.connection.password">jbpmtest</property>
                          


                          Funny thing is that if I use mySQL (instead of sybase) then it appears to work save for a similar error. It complains of a user called 'sa'@localhost not existing. If I add the two lines to the hbm file then it either works with that user or I have to manually create a user 'sa' with no password and the error disappears.

                          I suspect the reporting engine is being a weird with the user/pass it uses for the db. Any clue how to force it to use a specific user/pass (apart from adding those two lines - assuming that is not the right solution)?

                          • 10. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                            Joram Barrez Master

                            I mean this file:

                            jboss-5.0.0.GA/server/default/deploy/jbpm/jbpm-hsqldb-ds.xml

                            You need to remove this file and replace it with one suited for your database. There are examples in the /doc folder of JBoss, I believe.

                            • 11. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                              Ronald van Kuijk Master

                              Just to make sure I did not interpret something wrong... you ARE able to use the console right? Start new processes, see process lists etc.. At least that was my (maybe wrong as it seems now) assumption by what you posted before.

                              • 12. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                                R C Newbie

                                jbarrez: yep i did replace it :) here's a few of the diff permutations I have tried

                                XA DS with Jconnect - (Tried jconn3.jar and jconnect60-exclude.jar separately)

                                <?xml version="1.0" encoding="UTF-8"?>
                                
                                <datasources>
                                 <xa-datasource>
                                 <jndi-name>JbpmDS</jndi-name>
                                 <xa-datasource-class>com.sybase.jdbc3.jdbc.SybXADataSource</xa-datasource-class>
                                 <xa-datasource-property name="NetworkProtocol">Tds</xa-datasource-property>
                                 <xa-datasource-property name="ServerName">xxxxxx</xa-datasource-property>
                                 <xa-datasource-property name="PortNumber">7550</xa-datasource-property>
                                 <xa-datasource-property name="DatabaseName">WORKFLOW_TEST</xa-datasource-property>
                                 <!-- reduce isolation from the default level (repeatable read) -->
                                 <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                                 <!-- separate connections used with and without JTA transaction -->
                                 <no-tx-separate-pools />
                                 <!-- disable transaction interleaving -->
                                 <track-connection-by-tx />
                                 <user-name>wflowuser</user-name>
                                 <password>newmed</password>
                                 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
                                 <type-mapping>Sybase</type-mapping>
                                 </xa-datasource>
                                </datasources>
                                


                                DS with jTDS (tried jtds.jar and jtds-1.2.3.jar separately)
                                <datasources>
                                 <local-tx-datasource>
                                 <jndi-name>JbpmDS</jndi-name>
                                 <connection-url>jdbc:jtds:sybase://xxxxx:7550/WORKFLOW_TEST</connection-url>
                                 <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
                                 <user-name>wflowuser</user-name>
                                 <password>newmed</password>
                                
                                 <!-- reduce isolation from the default level (repeatable read) -->
                                 <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                                 <!-- separate connections used with and without JTA transaction -->
                                 <no-tx-separate-pools />
                                 <!-- disable transaction interleaving -->
                                 <track-connection-by-tx />
                                 <metadata>
                                 <type-mapping>Sybase</type-mapping>
                                 </metadata>
                                 </local-tx-datasource>
                                </datasources>


                                kukeltje: Yep I can log onto the console using alex/password, which is part of the example.identities.sql script I used to insert test data. And can see process lists, etc. The only tab which causes the error is Reporting -> Available Reports -> Processes

                                Another piece of info: If I use jConnect then on that particular tab (Reporting) it shows:
                                System overview
                                
                                Report creation:
                                Wed Sep 16 16:13:16 CAT 2009
                                Process summary
                                Total Process Definitions:
                                
                                Active Instances:
                                
                                Total Instances:
                                
                                Process details
                                Process definition
                                # Total instances
                                # Active instances
                                Process definition usage metrics
                                Process performance metrics
                                
                                Report generated by jBPM console at 2009-09-16 16:13:16.978
                                The following items have errors:
                                
                                Grid (id = 353):
                                + Column binding "process_definition" has referred to a data set column "process_definition" which does not exist.
                                
                                Data (id = 309):
                                + Column binding "process_definition" has referred to a data set column "process_definition" which does not exist.
                                
                                Data (id = 311):
                                + Column binding "process_definition" has referred to a data set column "process_definition" which does not exist.
                                
                                Data (id = 310):
                                + Column binding "process_definition" has referred to a data set column "process_definition" which does not exist.
                                
                                Table process_counts_table:
                                + Column binding "process_definition" has referred to a data set column "process_definition" which does not exist.
                                
                                Chart NewChart:
                                + Column binding "process_definition" has referred to a data set column "process_definition" which does not exist.
                                
                                Chart NewChart1:
                                + Column binding "PROCESS_DEFINITION" has referred to a data set column "PROCESS_DEFINITION" which does not exist.
                                


                                Error in log with jTDS:
                                2009-09-16 16:20:31,106 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
                                org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Login failed)
                                 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
                                 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
                                 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
                                 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
                                 at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
                                 at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
                                 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
                                 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
                                 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:284)
                                 at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:205)
                                 at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:179)
                                 at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:220)
                                 at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:151)
                                 at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
                                 at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)
                                 at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)
                                 at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)
                                 at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
                                 at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
                                 at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
                                 at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)
                                 at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
                                 at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
                                 at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
                                 at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:482)
                                 at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)
                                 at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
                                 at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
                                 at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
                                 at org.eclipse.birt.report.engine.executor.GridItemExecutor.execute(GridItemExecutor.java:64)
                                 at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
                                 at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
                                 at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
                                 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
                                 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
                                 at org.jboss.bpm.report.BirtService.render(BirtService.java:163)
                                 at org.jboss.bpm.report.ReportFacade.viewReportHtml(ReportFacade.java:139)
                                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                                 at java.lang.reflect.Method.invoke(Method.java:597)
                                 at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
                                 at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
                                 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
                                 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
                                 at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
                                 at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
                                 at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
                                 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
                                 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
                                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
                                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
                                 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
                                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
                                 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
                                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                                 at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
                                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
                                 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
                                 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
                                 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
                                 at java.lang.Thread.run(Thread.java:619)
                                Caused by: java.sql.SQLException: Login failed
                                 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
                                 at net.sourceforge.jtds.jdbc.TdsCore.tdsLoginAckToken(TdsCore.java:2956)
                                 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2264)
                                 at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
                                 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:357)
                                 at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
                                 at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
                                 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:172)
                                


                                Reporting tab with jConnect:
                                
                                System overview
                                
                                Report creation:
                                Wed Sep 16 16:20:32 CAT 2009
                                Process summary
                                Total Process Definitions:
                                0
                                Active Instances:
                                
                                Total Instances:
                                
                                Process details
                                Process definition
                                # Total instances
                                # Active instances
                                Process definition usage metrics
                                Process performance metrics
                                
                                Report generated by jBPM console at 2009-09-16 16:20:32.513


                                Error in log with jConnect:
                                2009-09-16 16:27:42,938 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Destroying connection that could not be successfully matched: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@c028cc[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@5f6ac6 handles=0 lastUse=1253111251735 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@5b29e0 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@11a6bc7 xaResource=org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper@199f62e txSync=null]
                                2009-09-16 16:27:42,985 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
                                org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).)
                                 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:155)
                                 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
                                 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
                                 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
                                 at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
                                 at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
                                 at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
                                 at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
                                 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:284)
                                 at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:205)
                                 at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:179)
                                 at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:220)
                                 at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:151)
                                 at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
                                 at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)
                                 at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)
                                 at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)
                                 at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
                                 at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)
                                 at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)
                                 at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)
                                 at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
                                 at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
                                 at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
                                 at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:482)
                                 at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)
                                 at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
                                 at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
                                 at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
                                 at org.eclipse.birt.report.engine.executor.GridItemExecutor.execute(GridItemExecutor.java:64)
                                 at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
                                 at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
                                 at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
                                 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
                                 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
                                 at org.jboss.bpm.report.BirtService.render(BirtService.java:163)
                                 at org.jboss.bpm.report.ReportFacade.viewReportHtml(ReportFacade.java:139)
                                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                                 at java.lang.reflect.Method.invoke(Method.java:597)
                                 at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
                                 at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
                                 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
                                 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
                                 at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
                                 at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
                                 at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
                                 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
                                 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
                                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
                                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
                                 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
                                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
                                 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
                                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                                 at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
                                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
                                 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
                                 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
                                 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
                                 at java.lang.Thread.run(Thread.java:619)
                                Caused by: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
                                 at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:565)
                                 at com.sybase.jdbc3.tds.Tds.processLoginAckToken(Tds.java:3801)
                                 at com.sybase.jdbc3.tds.Tds.doLogin(Tds.java:576)
                                 at com.sybase.jdbc3.tds.Tds.login(Tds.java:459)
                                 at com.sybase.jdbc3.jdbc.SybConnection.tryLogin(SybConnection.java:247)
                                 at com.sybase.jdbc3.jdbc.SybConnection.regularConnect(SybConnection.java:223)
                                 at com.sybase.jdbc3.jdbc.SybConnection.<init>(SybConnection.java:198)
                                 at com.sybase.jdbc3.jdbc.SybPooledConnection.<init>(SybPooledConnection.java:72)
                                 at com.sybase.jdbc3.jdbc.SybXAConnection.<init>(SybXAConnection.java:77)
                                 at com.sybase.jdbc3.jdbc.SybXADataSource.createConnection(SybXADataSource.java:147)
                                 at com.sybase.jdbc3.jdbc.SybDriver.connect(SybDriver.java:488)
                                 at com.sybase.jdbc3.jdbc.SybDriver.connect(SybDriver.java:520)
                                 at com.sybase.jdbc3.jdbc.SybDataSource.getConnection(SybDataSource.java:259)
                                 at com.sybase.jdbc3.jdbc.SybXADataSource.getXAConnection(SybXADataSource.java:97)
                                 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:137)
                                 ... 78 more
                                2009-09-16 16:27:43,719 ERROR [STDERR] Sep 16, 2009 4:27:43 PM org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor execute
                                SEVERE: Column binding "process_definition" has referred to a data set column "process_definition" which does not exist.
                                org.eclipse.birt.data.engine.core.DataException: Column binding "process_definition" has referred to a data set column "process_definition" which does not exist.
                                 at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:311)
                                 at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:148)
                                 at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:176)
                                 at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
                                 at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
                                 at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
                                 at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:204)
                                 at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
                                 at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:61)
                                 at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
                                 at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
                                 at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
                                 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
                                 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
                                 at org.jboss.bpm.report.BirtService.render(BirtService.java:163)
                                 at org.jboss.bpm.report.ReportFacade.viewReportHtml(ReportFacade.java:139)
                                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                                 at java.lang.reflect.Method.invoke(Method.java:597)
                                 at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
                                 at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
                                 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
                                 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
                                 at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
                                 at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
                                 at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
                                 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
                                 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
                                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
                                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
                                 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
                                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
                                 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
                                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                                 at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
                                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
                                 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
                                 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
                                 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
                                 at java.lang.Thread.run(Thread.java:619)
                                2009-09-16 16:27:43,844 ERROR [STDERR] Sep 16, 2009 4:27:43 PM org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor execute
                                SEVERE: Column binding "PROCESS_DEFINITION" has referred to a data set column "PROCESS_DEFINITION" which does not exist.
                                org.eclipse.birt.data.engine.core.DataException: Column binding "PROCESS_DEFINITION" has referred to a data set column "PROCESS_DEFINITION" which does not exist.
                                 at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:311)
                                 at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:148)
                                 at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:176)
                                 at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92)
                                 at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:129)
                                 at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
                                 at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:204)
                                 at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
                                 at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:61)
                                 at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
                                 at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
                                 at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
                                 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
                                 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:151)
                                 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
                                 at org.jboss.bpm.report.BirtService.render(BirtService.java:163)
                                 at org.jboss.bpm.report.ReportFacade.viewReportHtml(ReportFacade.java:139)
                                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                                 at java.lang.reflect.Method.invoke(Method.java:597)
                                 at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
                                 at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
                                 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
                                 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
                                 at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
                                 at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
                                 at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
                                 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
                                 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
                                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
                                 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                                 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                                 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
                                 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
                                 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
                                 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
                                 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
                                 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
                                 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                                 at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
                                 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                                 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
                                 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
                                 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
                                 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
                                 at java.lang.Thread.run(Thread.java:619)
                                


                                Does the 0 by Total Process Definitions (using jTDS) indicate that it's working, even with the "Login Failure error"?

                                • 13. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                                  R C Newbie

                                  "Another piece of info: If I use jConnect then on that particular tab (Reporting) it shows:"

                                  is meant to read

                                  "Another piece of info: If I use jTDS then on that particular tab (Reporting) it shows:"

                                  Apologies...cannot seem to edit original post

                                  • 14. Re: JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA
                                    Joram Barrez Master

                                    mmm it seems that the SQL queries that are used are no 'sybase-compatible', which could be true since we don't have Sybase in our QA setup (yet). So I'm afraid it's a specific Sybase/driver issue here ...

                                    1 2 Previous Next