JBPM 4.x using Sybase ASE 11/12 on Jboss 5.1.0GA| JBoss.org Content Archive (Read Only)

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

kukeltje Sep 14, 2009 6:42 AM (in response to hellow)

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

hellow Sep 14, 2009 7:23 AM (in response to hellow)

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

hellow Sep 15, 2009 6:40 AM (in response to hellow)

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

hellow Sep 16, 2009 5:33 AM (in response to hellow)

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

kukeltje Sep 16, 2009 6:00 AM (in response to hellow)

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

hellow Sep 16, 2009 7:31 AM (in response to hellow)

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

kukeltje Sep 16, 2009 7:53 AM (in response to hellow)

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

jbarrez Sep 16, 2009 7:59 AM (in response to hellow)

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

hellow Sep 16, 2009 9:03 AM (in response to hellow)

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

jbarrez Sep 16, 2009 9:14 AM (in response to hellow)

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

kukeltje Sep 16, 2009 9:29 AM (in response to hellow)

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

hellow Sep 16, 2009 10:55 AM (in response to hellow)

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

hellow Sep 16, 2009 10:58 AM (in response to hellow)

"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

jbarrez Sep 17, 2009 4:18 AM (in response to hellow)

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 ...