Uploaded image for project: 'Change Request Application'
  1. Change Request Application
  2. CRAPP-133

Errors in console when accessing the Profile page or Notification Settings page on Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.11
    • Fix Version/s: 0.13
    • Component/s: None
    • Labels:
    • Environment:
      Windows 11 Pro 64 bit, Edge 100, using a local instance of XWiki 14.2.1 on PostgreSQL 14, Tomcat 9.0.62
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      STEPS TO REPRODUCE

      1. Create an instance with Oracle 19c
      2. Install Change Request Application
      3. Go to own user profile page or go to Notification Preferences

      EXPECTED RESULTS

      No errors are displayed.

      ACTUAL RESULTS

      In the bottom of the page, the following error is displayed:

      Updating the entries failed for an unknown reason.

      In XWiki console, there is the following error:

      2022-04-11 16:45:40,432 [http-nio-1115-exec-10 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1649684740369&namespace=wiki%3Axwiki&sourceParams.translationPrefix=changerequest.livetable.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=ChangeRequest.Code.ChangeRequestClass&properties=doc.date&properties=doc.title&properties=authors&properties=status&properties=changedDocuments&offset=0&limit=10&filters.authors=undefined%3Axwiki%3AXWiki.ILIE&sort=doc.date&descending=true] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 932, SQLState: 42000
      2022-04-11 16:45:40,433 [http-nio-1115-exec-10 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1649684740369&namespace=wiki%3Axwiki&sourceParams.translationPrefix=changerequest.livetable.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=ChangeRequest.Code.ChangeRequestClass&properties=doc.date&properties=doc.title&properties=authors&properties=status&properties=changedDocuments&offset=0&limit=10&filters.authors=undefined%3Axwiki%3AXWiki.ILIE&sort=doc.date&descending=true] ERROR o.h.e.j.s.SqlExceptionHelper   - ORA-00932: tipuri de date inconsistente: se a?tepta -, s-a primit CLOB
      
      2022-04-11 16:45:40,437 [http-nio-1115-exec-10 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1649684740369&namespace=wiki%3Axwiki&sourceParams.translationPrefix=changerequest.livetable.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=ChangeRequest.Code.ChangeRequestClass&properties=doc.date&properties=doc.title&properties=authors&properties=status&properties=changedDocuments&offset=0&limit=10&filters.authors=undefined%3Axwiki%3AXWiki.ILIE&sort=doc.date&descending=true] ERROR o.a.v.d.null                   - Exception in macro #gridresult_buildTagCloudJSON called at xwiki:XWiki.LiveTableResults[line 475, column 1]
      2022-04-11 16:45:40,443 [http-nio-1115-exec-10 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1649684740369&namespace=wiki%3Axwiki&sourceParams.translationPrefix=changerequest.livetable.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=ChangeRequest.Code.ChangeRequestClass&properties=doc.date&properties=doc.title&properties=authors&properties=status&properties=changedDocuments&offset=0&limit=10&filters.authors=undefined%3Axwiki%3AXWiki.ILIE&sort=doc.date&descending=true] ERROR o.a.v.d.null                   - Exception in macro #gridresultwithfilter_buildJSON called at xwiki:XWiki.LiveTableResults[line 499, column 1]
      2022-04-11 16:45:40,444 [http-nio-1115-exec-10 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1649684740369&namespace=wiki%3Axwiki&sourceParams.translationPrefix=changerequest.livetable.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=ChangeRequest.Code.ChangeRequestClass&properties=doc.date&properties=doc.title&properties=authors&properties=status&properties=changedDocuments&offset=0&limit=10&filters.authors=undefined%3Axwiki%3AXWiki.ILIE&sort=doc.date&descending=true] ERROR o.a.v.d.null                   - Exception in macro #gridresultwithfilter called at xwiki:XWiki.LiveTableResults[line 26, column 1]
      2022-04-11 16:45:40,468 [http-nio-1115-exec-10 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1649684740369&namespace=wiki%3Axwiki&sourceParams.translationPrefix=changerequest.livetable.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=ChangeRequest.Code.ChangeRequestClass&properties=doc.date&properties=doc.title&properties=authors&properties=status&properties=changedDocuments&offset=0&limit=10&filters.authors=undefined%3Axwiki%3AXWiki.ILIE&sort=doc.date&descending=true] ERROR r.i.e.ExceptionExceptionMapper - A REST endpoint failed with an unmapped exception.
      org.xwiki.livedata.LiveDataException: Failed to execute the live data query.
              at org.xwiki.livedata.internal.livetable.LiveTableLiveDataEntryStore.get(LiveTableLiveDataEntryStore.java:116)
              at org.xwiki.livedata.internal.rest.DefaultLiveDataEntriesResource.getEntries(DefaultLiveDataEntriesResource.java:193)
              at org.xwiki.livedata.internal.rest.DefaultLiveDataEntriesResource.getEntries(DefaultLiveDataEntriesResource.java:79)
              at jdk.internal.reflect.GeneratedMethodAccessor943.invoke(Unknown Source)
              at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.base/java.lang.reflect.Method.invoke(Method.java:568)
              at org.restlet.ext.jaxrs.internal.wrappers.AbstractMethodWrapper.internalInvoke(AbstractMethodWrapper.java:162)
              at org.restlet.ext.jaxrs.internal.wrappers.ResourceMethod.invoke(ResourceMethod.java:281)
              at org.restlet.ext.jaxrs.JaxRsRestlet.invokeMethod(JaxRsRestlet.java:997)
              at org.restlet.ext.jaxrs.JaxRsRestlet.handle(JaxRsRestlet.java:746)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.routing.Router.doHandle(Router.java:422)
              at org.restlet.routing.Router.handle(Router.java:641)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:140)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
              at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:77)
              at org.restlet.Application.handle(Application.java:385)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.routing.Router.doHandle(Router.java:422)
              at org.restlet.routing.Router.handle(Router.java:641)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.routing.Router.doHandle(Router.java:422)
              at org.restlet.routing.Router.handle(Router.java:641)
              at org.restlet.routing.Filter.doHandle(Filter.java:150)
              at org.restlet.routing.Filter.handle(Filter.java:197)
              at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:202)
              at org.restlet.Component.handle(Component.java:408)
              at org.restlet.Server.handle(Server.java:507)
              at org.restlet.engine.connector.ServerHelper.handle(ServerHelper.java:63)
              at org.restlet.engine.adapter.HttpServerHelper.handle(HttpServerHelper.java:143)
              at org.restlet.ext.servlet.ServerServlet.service(ServerServlet.java:1117)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at com.xpn.xwiki.web.XWikiContextInitializationFilter.doFilter(XWikiContextInitializationFilter.java:82)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:132)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
              at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
              at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
              at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
              at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
              at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
              at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
              at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
              at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
              at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
              at java.base/java.lang.Thread.run(Thread.java:833)
      Caused by: com.fasterxml.jackson.core.JsonParseException: Unrecognized token 'Failed': was expecting (JSON String, Number, Array, Object or token 'null', 'true' or 'false')
       at [Source: (String)"Failed to execute the [velocity] macro. Cause: [ORA-00932: tipuri de date inconsistente: se a?tepta -, s-a primit CLOB ]. Click on this message for details.
      
      org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [## the $extra variable is passed to the call to #gridresultwithfilter below and is used to perform some default
      ## filtering on the LiveTable data even when the user has not performed any column filtering yet.
      ## When users start using column f"[truncated 24602 chars]; line: 1, column: 7]
              at com.fasterxml.jackson.core.JsonParser._constructError(JsonParser.java:2391)
              at com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(ParserMinimalBase.java:745)
              at com.fasterxml.jackson.core.json.ReaderBasedJsonParser._reportInvalidToken(ReaderBasedJsonParser.java:2961)
              at com.fasterxml.jackson.core.json.ReaderBasedJsonParser._handleOddValue(ReaderBasedJsonParser.java:2002)
              at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.nextToken(ReaderBasedJsonParser.java:802)
              at com.fasterxml.jackson.databind.ObjectMapper._readTreeAndClose(ObjectMapper.java:4703)
              at com.fasterxml.jackson.databind.ObjectMapper.readTree(ObjectMapper.java:3076)
              at org.xwiki.livedata.internal.livetable.LiveTableLiveDataEntryStore.getLiveTableResultsJSON(LiveTableLiveDataEntryStore.java:142)
              at org.xwiki.livedata.internal.livetable.LiveTableLiveDataEntryStore.get(LiveTableLiveDataEntryStore.java:107)
              ... 83 common frames omitted

      I think some part of the errors derives fromĀ XWIKI-14634 though.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              surli Simon Urli
              Reporter:
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: