2 Replies Latest reply on Dec 17, 2013 9:44 AM by objectiser

bpel-console logging on error -class com.google.gwt.http.client.RequestException

hongdaw7 Dec 15, 2013 3:34 AM

Hi Team

I have just installed riftsaw-2.3.0.Final with the combination- jboss-5.1.0.GA, jbossesb-4.11, and JDK is jdk1.6.0_45.

The deploy script is ant deploy -Ddatabase=oracle -Dws.stack=cxf -Dws.version=3.4.0.GA

Oracle is 11g standalone.

Installation looks ok without error. but when I logs on http://localhost:8080/bpel-console, there are following error prompted,

URL: 'http://localhost:8080/gwt-console-server/rs/history/definitions'
Action: 'org.jboss.bpm.console.client.history.LoadProcessDefinitionsAction'
Exception: 'class com.google.gwt.http.client.RequestException'

HTTP 500:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

The server.log shows,

2013-12-15 16:17:48,219 WARN [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8080-6) SQL Error: 933, SQLState: 42000

2013-12-15 16:17:48,221 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-127.0.0.1-8080-6) ORA-00933: SQL command not properly ended

2013-12-15 16:17:48,222 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/gwt-console-server].[Resteasy]] (http-127.0.0.1-8080-6) Servlet.service() for servlet Resteasy threw exception

org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Failed to execute query

at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:319)

at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:230)

at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:206)

at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:360)

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:525)

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:662)

Caused by: java.lang.RuntimeException: Failed to execute query

at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.executeCommand(DefaultBPAFDataSource.java:73)

at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.getProcessDefinitions(DefaultBPAFDataSource.java:97)

at org.jboss.soa.bpel.console.ProcessHistoryPluginImpl.getProcessDefinitions(ProcessHistoryPluginImpl.java:114)

at org.jboss.bpm.console.server.ProcessHistoryFacade.getProcessDefinitionKeys(ProcessHistoryFacade.java:77)

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)

... 28 more

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)

at org.jboss.bpm.monitor.model.DefaultBPAFDataSource$1.execute(DefaultBPAFDataSource.java:104)

at org.jboss.bpm.monitor.model.DefaultBPAFDataSource$1.execute(DefaultBPAFDataSource.java:98)

at org.jboss.bpm.monitor.model.DefaultBPAFDataSource.executeCommand(DefaultBPAFDataSource.java:68)

... 41 more

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.loader.Loader.doList(Loader.java:2231)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)

at org.hibernate.loader.Loader.list(Loader.java:2120)

at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)

at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)

at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)

at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)

at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)

... 44 more

Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460)

at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)

at org.hibernate.loader.Loader.doQuery(Loader.java:697)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

at org.hibernate.loader.Loader.doList(Loader.java:2228)

... 51 more

2013-12-15 16:17:48,228 ERROR [org.jboss.web.tomcat.service.jca.CachedConnectionValve] (http-127.0.0.1-8080-6) Application error: Resteasy did not complete its transaction

I have added the entry on hibernate.cfg.xml

But still cannot show the sql statement....could anyone provide any solution on it... it's very appreciative.

Regards,

Hongda

1. Re: bpel-console logging on error -class com.google.gwt.http.client.RequestException

hongdaw7 Dec 16, 2013 11:22 PM (in response to hongdaw7)

I can see the same issue reported on https://issues.jboss.org/browse/RIFTSAW-470,and it's resolved on 2.3.2.Final. However, how can I get this version, as the download page only shows Version 2.3.0.Final as the latest.

Any help would be appreciated.... thanks
Actions
2. Re: bpel-console logging on error -class com.google.gwt.http.client.RequestException

objectiser Dec 17, 2013 9:44 AM (in response to hongdaw7)

Hi Hongda

You will need to build from source. There will be no more releases of the 2.x stream, and the 3.x version of riftsaw is only released as the BPEL component within the SwitchYard ESB (i.e. no longer as a separate installed technology).

Regards
Gary
Actions

Go to original post