Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

exception filtering audit log with qb 6.0.11 #3203

mvuser ·
We use Quickbuild 6.0.11. We did an update from QB 5.0.41.
We have a problem filtering audit log entries. Entering a filter criterion and pressing the button leads to following exception:

Error Details:

Message: Error attaching this container for rendering: [WebMarkupContainer [Component id = body]]

Root cause:

java.sql.SQLSyntaxErrorException: ORA-00932: Inkonsistente Datentypen: CHAR erwartet, LONG erhalten

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
at com.pmease.quickbuild.entitymanager.impl.AbstractEntityManager.countEntities(AbstractEntityManager.java:149)
at com.pmease.quickbuild.persistence.SessionInterceptor.invoke(SessionInterceptor.java:116)
at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.count(DefaultDataManager.java:712)
at com.pmease.quickbuild.persistence.SessionInterceptor.invoke(SessionInterceptor.java:91)
at com.pmease.quickbuild.web.component.datatablesupport.hibernate.HibernateDataProvider$1.getObject(HibernateDataProvider.java:48)
at com.pmease.quickbuild.web.component.datatablesupport.hibernate.HibernateDataProvider$1.getObject(HibernateDataProvider.java:40)
at com.pmease.quickbuild.web.component.datatablesupport.hibernate.HibernateDataProvider.size(HibernateDataProvider.java:75)
at org.apache.wicket.markup.repeater.data.DataViewBase.internalGetItemCount(DataViewBase.java:141)
at org.apache.wicket.markup.repeater.AbstractPageableView.getItemCount(AbstractPageableView.java:233)
at org.apache.wicket.markup.repeater.AbstractPageableView.getRowCount(AbstractPageableView.java:215)
at org.apache.wicket.markup.repeater.AbstractPageableView.getViewSize(AbstractPageableView.java:309)
at org.apache.wicket.markup.repeater.AbstractPageableView.getItemModels(AbstractPageableView.java:99)
at org.apache.wicket.markup.repeater.RefreshingView.onPopulate(RefreshingView.java:93)
at org.apache.wicket.markup.repeater.AbstractRepeater.onBeforeRender(AbstractRepeater.java:119)
at org.apache.wicket.markup.repeater.AbstractPageableView.onBeforeRender(AbstractPageableView.java:115)
at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
at org.apache.wicket.Component.beforeRender(Component.java:1022)
at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
at org.apache.wicket.Component.beforeRender(Component.java:1022)
at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
at org.apache.wicket.Component.beforeRender(Component.java:1022)
at org.apache.wicket.Component.internalPrepareForRender(Component.java:2191)
at org.apache.wicket.Component.prepareForRender(Component.java:2228)
at org.apache.wicket.ajax.AjaxRequestTarget.respondComponent(AjaxRequestTarget.java:960)
at org.apache.wicket.ajax.AjaxRequestTarget.respondComponents(AjaxRequestTarget.java:794)
at org.apache.wicket.ajax.AjaxRequestTarget.constructResponseBody(AjaxRequestTarget.java:672)
at org.apache.wicket.ajax.AjaxRequestTarget.respond(AjaxRequestTarget.java:633)
at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:719)
at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:63)
at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:96)
at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:210)
at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:253)
at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:162)
at org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:159)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at com.pmease.quickbuild.web.MainServlet.service(MainServlet.java:124)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at org.eclipse.equinox.http.helper.FilterServletAdaptor$FilterChainImpl.doFilter(FilterServletAdaptor.java:56)
at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:82)
at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:243)
at org.eclipse.equinox.http.helper.FilterServletAdaptor.service(FilterServletAdaptor.java:37)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
at com.pmease.quickbuild.Quickbuild$DisableTraceFilter.doFilter(Quickbuild.java:1048)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:365)
at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53)
at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72)
at org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(SocketConnector.java:264)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
at java.lang.Thread.run(Thread.java:745)


Complete stack:

org.apache.wicket.WicketRuntimeException: Error attaching this container for rendering: [WebMarkupContainer [Component id = body]]
at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1797)
at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
at org.apache.wicket.Component.beforeRender(Component.java:1022)
at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
at org.apache.wicket.Component.beforeRender(Component.java:1022)
at org.apache.wicket.Component.internalPrepareForRender(Component.java:2191)
at org.apache.wicket.Component.prepareForRender(Component.java:2228)
at org.apache.wicket.ajax.AjaxRequestTarget.respondComponent(AjaxRequestTarget.java:960)
at org.apache.wicket.ajax.AjaxRequestTarget.respondComponents(AjaxRequestTarget.java:794)
at org.apache.wicket.ajax.AjaxRequestTarget.constructResponseBody(AjaxRequestTarget.java:672)
at org.apache.wicket.ajax.AjaxRequestTarget.respond(AjaxRequestTarget.java:633)
at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:719)
at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:63)
at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:96)
at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:210)
at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:253)
at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:162)

org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369)
at com.pmease.quickbuild.entitymanager.impl.AbstractEntityManager.countEntities(AbstractEntityManager.java:149)
at com.pmease.quickbuild.persistence.SessionInterceptor.invoke(SessionInterceptor.java:116)
at com.pmease.quickbuild.entitymanager.impl.DefaultDataManager.count(DefaultDataManager.java:712)
at com.pmease.quickbuild.persistence.SessionInterceptor.invoke(SessionInterceptor.java:91)
at com.pmease.quickbuild.web.component.datatablesupport.hibernate.HibernateDataProvider$1.getObject(HibernateDataProvider.java:48)
at com.pmease.quickbuild.web.component.datatablesupport.hibernate.HibernateDataProvider$1.getObject(HibernateDataProvider.java:40)
at com.pmease.quickbuild.web.component.datatablesupport.hibernate.HibernateDataProvider.size(HibernateDataProvider.java:75)
at org.apache.wicket.markup.repeater.data.DataViewBase.internalGetItemCount(DataViewBase.java:141)
at org.apache.wicket.markup.repeater.AbstractPageableView.getItemCount(AbstractPageableView.java:233)
at org.apache.wicket.markup.repeater.AbstractPageableView.getRowCount(AbstractPageableView.java:215)
at org.apache.wicket.markup.repeater.AbstractPageableView.getViewSize(AbstractPageableView.java:309)
at org.apache.wicket.markup.repeater.AbstractPageableView.getItemModels(AbstractPageableView.java:99)
at org.apache.wicket.markup.repeater.RefreshingView.onPopulate(RefreshingView.java:93)
at org.apache.wicket.markup.repeater.AbstractRepeater.onBeforeRender(AbstractRepeater.java:119)
at org.apache.wicket.markup.repeater.AbstractPageableView.onBeforeRender(AbstractPageableView.java:115)
at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
at org.apache.wicket.Component.beforeRender(Component.java:1022)
at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
at org.apache.wicket.Component.beforeRender(Component.java:1022)
at org.apache.wicket.MarkupContainer.onBeforeRenderChildren(MarkupContainer.java:1785)
at org.apache.wicket.Component.onBeforeRender(Component.java:3798)
at org.apache.wicket.Component.internalBeforeRender(Component.java:986)
at org.apache.wicket.Component.beforeRender(Component.java:1022)
at org.apache.wicket.Component.internalPrepareForRender(Component.java:2191)
at org.apache.wicket.Component.prepareForRender(Component.java:2228)
at org.apache.wicket.ajax.AjaxRequestTarget.respondComponent(AjaxRequestTarget.java:960)
at org.apache.wicket.ajax.AjaxRequestTarget.respondComponents(AjaxRequestTarget.java:794)
at org.apache.wicket.ajax.AjaxRequestTarget.constructResponseBody(AjaxRequestTarget.java:672)
at org.apache.wicket.ajax.AjaxRequestTarget.respond(AjaxRequestTarget.java:633)
at org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:719)
at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:63)
at org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:96)
at org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:210)
at org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:253)
at org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:162)

best regards
Friedhelm
  • replies 1
  • views 1640
  • stars 0
robinshen ADMIN ·
This has been fixed in 6.0.12