1 Reply Latest reply on Feb 6, 2012 10:14 AM by tcunning

    jboss-soa-p-5 platform: Not able to login to BPEL console, error screen attached

    girish_shivanigi

      All,

       

      Tyring to login to the BPEL console, getting below error. Anyone faced this issue before?

       

      Regards

      Girish

       

      15:03:51,883 WARN  [JDBCExceptionReporter] SQL Error: 933, SQLState: 42000

      15:03:51,883 ERROR [JDBCExceptionReporter] ORA-00933: SQL command not properly ended

       

       

      15:03:51,885 ERROR [[Resteasy]] 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:263)

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

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

              at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:456)

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

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

              at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:217)

              at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:159)

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

              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)

              at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)

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

              at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)

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

              at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:247)

              at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:212)

              at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:202)

              at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:441)

              ... 29 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:103)

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

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

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

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

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

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

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

              ... 44 more

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

       

       

              at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

              at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)

              at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)

              at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)

              at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)

              at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)

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

              at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)

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

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

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

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

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

              ... 52 more

      15:03:51,894 ERROR [CachedConnectionValve] Application error: Resteasy did not complete its transaction

       

       

      Regards

      Girish