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

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

    Girish Shivanigi Newbie

      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