Skip to content

No tasks are displayed in Gantt Diagram or LiveTable and TaskManagerPanel displays velocity error on Oracle #269

New issue
New issue
Open
Bug
Open
No tasks are displayed in Gantt Diagram or LiveTable and TaskManagerPanel displays velocity error on Oracle#269
Bug
Assignees
snazare
Labels
ToScheduleType: Bug
@ilieandriuta

Description

@ilieandriuta
ilieandriuta
opened on Jul 23, 2025

Steps to reproduce

  1. Open an XWiki instance using Oracle DB (tested with XWiki 17.4.2 on Oracle 19c)
  2. Install Task Manager Pro (tested with 3.9.0)
  3. Obtain a (trial) license
  4. Go to Task Manager main page from Applications Panel
  5. Observe the TaskManagerPanel from the right side
  6. Click 'Create' button and create a new task
  7. Save it
  8. Observe the LiveTable and the Gantt Diagram

Expected results

The panel is displayed properly without any errors.
The task created is displayed in the LiveTable and Gantt Diagram.

Actual results

Nothing is displayed in the LiveTable on main page and Gantt Diagram.

The panel displays a velocity error:

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.

When clicking on it, the following stacktrace is displayed:

org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [  #panelheader($services.localization.render('taskmanager.panel.paneltitle'))
  #if(!$isGuest)
  #set($query = "from doc.object(TaskManager.TaskManagerClass) as document where doc.fullName <> 'TaskManager.TaskManagerTemplate' and document.assignee=:currentUser and document.status <> 'Done' order by document.duedate asc")
  #set($results = $services.query.xwql("$query").bindValue("currentUser", $services.model.serialize($xcontext.userReference,'compactwiki')).setLimit(5).execute())
  #foreach($result in $results)
    #set($object = $xwiki.getDocument($result).getObject('TaskManager.TaskManagerClass'))
    * $services.icon.render('accept') **[[$services.rendering.escape($object.getProperty('name').value, 'xwiki/2.1')>>$services.rendering.escape($result, 'xwiki/2.1')]]**
    (% class="text-muted small" %)##
    #if ($object.getProperty('duedate').value)
      $services.localization.render('taskmanager.panel.untildate') $datetool.format('HH:mm dd/MMM/yyyy',$object.getProperty('duedate').value)
    #else
      $services.localization.render('taskmanager.panel.untildate.nodate')
    #end
  #end
  #if($results.size() == 0)
    (% class="pull-left"%)$services.localization.render('taskmanager.panel.noactivetasks')
  #else
    (% class="pull-right"%)[[$services.localization.render('taskmanager.panel.fulltasklist')>>TaskManager.WebHome]]
  #end
  #else
    {{info}}$escapetool.xml($services.localization.render('taskmanager.panel.guest')){{/info}}
  #end
  #panelfooter()]

 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:186)

 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:60)

 at org.xwiki.rendering.macro.script.AbstractScriptMacro.evaluateBlock(AbstractScriptMacro.java:279)

 at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:182)

 at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:58)

 at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:441)

 at org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)

 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.transform(AbstractBlockAsyncRenderer.java:76)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRenderer.tranform(DefaultBlockAsyncRenderer.java:154)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRenderer.execute(DefaultBlockAsyncRenderer.java:137)

 at org.xwiki.rendering.async.internal.block.AbstractBlockAsyncRenderer.render(AbstractBlockAsyncRenderer.java:157)

 at org.xwiki.panels.internal.PanelWikiUIExtension.render(PanelWikiUIExtension.java:132)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor$DecoratorWrapper.render(DefaultBlockAsyncRendererExecutor.java:67)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor$DecoratorWrapper.render(DefaultBlockAsyncRendererExecutor.java:49)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)

 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.execute(DefaultBlockAsyncRendererExecutor.java:125)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.execute(DefaultBlockAsyncRendererExecutor.java:113)

 at org.xwiki.uiextension.internal.AbstractWikiUIExtension.execute(AbstractWikiUIExtension.java:101)

 at org.xwiki.uiextension.internal.AbstractWikiUIExtension.execute(AbstractWikiUIExtension.java:89)

 at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)

 at java.base/java.lang.reflect.Method.invoke(Method.java:580)

 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)

 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)

 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)

 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)

 at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:704)

 at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:75)

 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:167)

 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)

 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)

 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)

 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)

 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)

 at org.apache.velocity.runtime.directive.Foreach.renderBlock(Foreach.java:309)

 at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:279)

 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)

 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)

 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)

 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)

 at org.apache.velocity.Template.merge(Template.java:358)

 at org.apache.velocity.Template.merge(Template.java:262)

 at org.xwiki.velocity.internal.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)

 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)

 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:907)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:869)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:856)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:811)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:803)

 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:79)

 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:73)

 at org.xwiki.template.script.TemplateScriptService.render(TemplateScriptService.java:54)

 at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)

 at java.base/java.lang.reflect.Method.invoke(Method.java:580)

 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)

 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)

 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)

 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)

 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)

 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)

 at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:217)

 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)

 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)

 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)

 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)

 at org.apache.velocity.Template.merge(Template.java:358)

 at org.apache.velocity.Template.merge(Template.java:262)

 at org.xwiki.velocity.internal.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)

 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)

 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:907)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:869)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:856)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:811)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:803)

 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:79)

 at com.xpn.xwiki.internal.template.DefaultTemplateManager.renderNoException(DefaultTemplateManager.java:73)

 at org.xwiki.template.script.TemplateScriptService.render(TemplateScriptService.java:54)

 at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)

 at java.base/java.lang.reflect.Method.invoke(Method.java:580)

 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)

 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)

 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)

 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)

 at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:492)

 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)

 at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:217)

 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:331)

 at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:261)

 at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:304)

 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)

 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)

 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:190)

 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)

 at org.apache.velocity.Template.merge(Template.java:358)

 at org.apache.velocity.Template.merge(Template.java:262)

 at org.xwiki.velocity.internal.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)

 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:107)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.evaluateContent(TemplateAsyncRenderer.java:219)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.renderVelocity(TemplateAsyncRenderer.java:174)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:135)

 at com.xpn.xwiki.internal.template.TemplateAsyncRenderer.render(TemplateAsyncRenderer.java:54)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.lambda$syncRender$0(DefaultAsyncRendererExecutor.java:284)

 at com.xpn.xwiki.internal.security.authorization.DefaultAuthorExecutor.call(DefaultAuthorExecutor.java:98)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.syncRender(DefaultAsyncRendererExecutor.java:284)

 at org.xwiki.rendering.async.internal.DefaultAsyncRendererExecutor.render(DefaultAsyncRendererExecutor.java:267)

 at org.xwiki.rendering.async.internal.block.DefaultBlockAsyncRendererExecutor.render(DefaultBlockAsyncRendererExecutor.java:154)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:907)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:869)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:849)

 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:835)

 at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:91)

 at com.xpn.xwiki.internal.template.DefaultTemplateManager.render(DefaultTemplateManager.java:85)

 at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:2570)

 at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:180)

 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:650)

 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:338)

 at com.xpn.xwiki.web.LegacyActionServlet.service(LegacyActionServlet.java:111)

 at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130)

 at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:123)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:72)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:66)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:135)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:211)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.xwiki.container.servlet.filters.internal.SafeRedirectFilter.doFilter(SafeRedirectFilter.java:106)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.xwiki.container.servlet.filters.internal.ResolveRelativeRedirectFilter.doFilter(ResolveRelativeRedirectFilter.java:129)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:120)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)

 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)

 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79)

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

 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116)

 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)

 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:666)

 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)

 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)

 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)

 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903)

 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1773)

 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)

 at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

 at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637)

 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59)

 at java.base/java.lang.Thread.run(Thread.java:1583)

Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with namespace [xwiki:TaskManager.TaskManagerPanel]

 at org.xwiki.velocity.internal.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:235)

 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:168)

 ... 173 more

Caused by: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'execute' in  class org.xwiki.query.internal.ScriptQuery threw exception org.xwiki.query.QueryException: Exception while executing query. Query statement = [ select doc.fullName from XWikiDocument as doc , BaseObject as document , com.xpn.xwiki.objects.LargeStringProperty as document_assignee1, com.xpn.xwiki.objects.StringProperty as document_status2, com.xpn.xwiki.objects.DateProperty as document_duedate3 where ( doc.fullName <> 'TaskManager.TaskManagerTemplate' and document_assignee1.value = :currentUser and document_status2.value <> 'Done' ) and doc.fullName=document.name and document.className='TaskManager.TaskManagerClass' and document_assignee1.id.id=document.id and document_assignee1.id.name='assignee' and document_status2.id.id=document.id and document_status2.id.name='status' and document_duedate3.id.id=document.id and document_duedate3.id.name='duedate' order by document_duedate3.value asc ] at xwiki:TaskManager.TaskManagerPanel[line 4, column 151]

 at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:308)

 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:235)

 at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:368)

 at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:704)

 at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:75)

 at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:242)

 at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:147)

 at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:171)

 at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:439)

 at org.apache.velocity.Template.merge(Template.java:358)

 at org.apache.velocity.Template.merge(Template.java:262)

 at org.xwiki.velocity.internal.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:233)

 ... 174 more

Caused by: org.xwiki.query.QueryException: Exception while executing query. Query statement = [ select doc.fullName from XWikiDocument as doc , BaseObject as document , com.xpn.xwiki.objects.LargeStringProperty as document_assignee1, com.xpn.xwiki.objects.StringProperty as document_status2, com.xpn.xwiki.objects.DateProperty as document_duedate3 where ( doc.fullName <> 'TaskManager.TaskManagerTemplate' and document_assignee1.value = :currentUser and document_status2.value <> 'Done' ) and doc.fullName=document.name and document.className='TaskManager.TaskManagerClass' and document_assignee1.id.id=document.id and document_assignee1.id.name='assignee' and document_status2.id.id=document.id and document_status2.id.name='status' and document_duedate3.id.id=document.id and document_duedate3.id.name='duedate' order by document_duedate3.value asc ]

 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:222)

 at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)

 at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:306)

 at org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:117)

 at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)

 at org.xwiki.query.internal.SecureQueryExecutorManager.execute(SecureQueryExecutorManager.java:67)

 at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:306)

 at org.xwiki.query.internal.ScriptQuery.execute(ScriptQuery.java:278)

 at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)

 at java.base/java.lang.reflect.Method.invoke(Method.java:580)

 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:571)

 at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:554)

 at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:221)

 ... 184 more

Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute

 at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:860)

 at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:927)

 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:207)

 ... 196 more

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

 at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)

 at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1626)

 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.lambda$execute$0(HqlQueryExecutor.java:210)

 at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:851)

 ... 198 more

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

 at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

 at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)

 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)

 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)

 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)

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

 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2075)

 at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2037)

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

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

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

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

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

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

 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:540)

 at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)

 at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:218)

 at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1459)

 at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1649)

 at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)

 ... 200 more

Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: tipuri de date inconsistente: se aştepta -, s-a primit CLOB


 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)

 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)

 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1231)

 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:772)

 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)

 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:512)

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

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

 at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1271)

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

 at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1661)

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

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

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

 at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1102)

 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)

 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)

 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)

 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)

 ... 215 more

Caused by: Error : 932, Position : 294, Sql = select xwikidocum0_.XWD_FULLNAME as col_0_0_ from xwikidoc xwikidocum0_ cross join xwikiobjects baseobject1_ cross join xwikilargestrings largestrin2_ cross join xwikistrings stringprop3_ cross join xwikidates dateproper4_ where xwikidocum0_.XWD_FULLNAME<>'TaskManager.TaskManagerTemplate' and largestrin2_.XWL_VALUE=:1  and stringprop3_.XWS_VALUE<>'Done' and xwikidocum0_.XWD_FULLNAME=baseobject1_.XWO_NAME and baseobject1_.XWO_CLASSNAME='TaskManager.TaskManagerClass' and largestrin2_.XWL_ID=baseobject1_.XWO_ID and largestrin2_.XWL_NAME='assignee' and stringprop3_.XWS_ID=baseobject1_.XWO_ID and stringprop3_.XWS_NAME='status' and dateproper4_.XWS_ID=baseobject1_.XWO_ID and dateproper4_.XWS_NAME='duedate' order by dateproper4_.XWS_VALUE asc fetch first :2  rows only, OriginalSql = select xwikidocum0_.XWD_FULLNAME as col_0_0_ from xwikidoc xwikidocum0_ cross join xwikiobjects baseobject1_ cross join xwikilargestrings largestrin2_ cross join xwikistrings stringprop3_ cross join xwikidates dateproper4_ where xwikidocum0_.XWD_FULLNAME<>'TaskManager.TaskManagerTemplate' and largestrin2_.XWL_VALUE=? and stringprop3_.XWS_VALUE<>'Done' and xwikidocum0_.XWD_FULLNAME=baseobject1_.XWO_NAME and baseobject1_.XWO_CLASSNAME='TaskManager.TaskManagerClass' and largestrin2_.XWL_ID=baseobject1_.XWO_ID and largestrin2_.XWL_NAME='assignee' and stringprop3_.XWS_ID=baseobject1_.XWO_ID and stringprop3_.XWS_NAME='status' and dateproper4_.XWS_ID=baseobject1_.XWO_ID and dateproper4_.XWS_NAME='duedate' order by dateproper4_.XWS_VALUE asc fetch first ? rows only, Error Msg = ORA-00932: tipuri de date inconsistente: se aştepta -, s-a primit CLOB


 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)

 ... 233 more

Also, in XWiki logs, the following stacktrace is present:

2025-07-23 13:46:52,940 [http-nio-1115-exec-5 - http://localhost:1115/xwiki/bin/get/TaskManager/TaskManagerLiveTableResults?outputSyntax=plain&transprefix=taskmanager.livetable.&classname=TaskManager.TaskManagerClass&collist=name%2Cproject%2Cstatus%2Cseverity%2Creporter%2Cassignee%2Cduedate&queryFilters=currentlanguage%2Chidden&tagcloud=true&offset=1&limit=15&reqNo=1&sort=name&dir=asc] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 932, SQLState: 42000
2025-07-23 13:46:52,940 [http-nio-1115-exec-5 - http://localhost:1115/xwiki/bin/get/TaskManager/TaskManagerLiveTableResults?outputSyntax=plain&transprefix=taskmanager.livetable.&classname=TaskManager.TaskManagerClass&collist=name%2Cproject%2Cstatus%2Cseverity%2Creporter%2Cassignee%2Cduedate&queryFilters=currentlanguage%2Chidden&tagcloud=true&offset=1&limit=15&reqNo=1&sort=name&dir=asc] ERROR o.h.e.j.s.SqlExceptionHelper   - ORA-00932: tipuri de date inconsistente: se aştepta -, s-a primit CLOB

2025-07-23 13:46:52,940 [http-nio-1115-exec-5 - http://localhost:1115/xwiki/bin/get/TaskManager/TaskManagerLiveTableResults?outputSyntax=plain&transprefix=taskmanager.livetable.&classname=TaskManager.TaskManagerClass&collist=name%2Cproject%2Cstatus%2Cseverity%2Creporter%2Cassignee%2Cduedate&queryFilters=currentlanguage%2Chidden&tagcloud=true&offset=1&limit=15&reqNo=1&sort=name&dir=asc] ERROR o.a.v.d.null                   - Exception in macro #gridresult_buildRowsJSON called at xwiki:XWiki.LiveTableResultsMacros[line 511, column 1]
2025-07-23 13:46:52,940 [http-nio-1115-exec-5 - http://localhost:1115/xwiki/bin/get/TaskManager/TaskManagerLiveTableResults?outputSyntax=plain&transprefix=taskmanager.livetable.&classname=TaskManager.TaskManagerClass&collist=name%2Cproject%2Cstatus%2Cseverity%2Creporter%2Cassignee%2Cduedate&queryFilters=currentlanguage%2Chidden&tagcloud=true&offset=1&limit=15&reqNo=1&sort=name&dir=asc] ERROR o.a.v.d.null                   - Exception in macro #gridresultwithfilter_buildJSON called at xwiki:XWiki.LiveTableResultsMacros[line 534, column 1]
2025-07-23 13:46:52,940 [http-nio-1115-exec-5 - http://localhost:1115/xwiki/bin/get/TaskManager/TaskManagerLiveTableResults?outputSyntax=plain&transprefix=taskmanager.livetable.&classname=TaskManager.TaskManagerClass&collist=name%2Cproject%2Cstatus%2Cseverity%2Creporter%2Cassignee%2Cduedate&queryFilters=currentlanguage%2Chidden&tagcloud=true&offset=1&limit=15&reqNo=1&sort=name&dir=asc] ERROR o.a.v.d.null                   - Exception in macro #gridresultwithfilter called at xwiki:XWiki.LiveTableResults[line 26, column 1]
2025-07-23 13:46:54,256 [http-nio-1115-exec-10 - http://localhost:1115/xwiki/bin/get/TaskManager/GanttMacro/JSONTaskSource?xpage=plain&outputSyntax=plain&hideNoDueDate=true&maxTasks=50] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 932, SQLState: 42000
2025-07-23 13:46:54,256 [http-nio-1115-exec-10 - http://localhost:1115/xwiki/bin/get/TaskManager/GanttMacro/JSONTaskSource?xpage=plain&outputSyntax=plain&hideNoDueDate=true&maxTasks=50] ERROR o.h.e.j.s.SqlExceptionHelper   - ORA-00932: tipuri de date inconsistente: se aştepta -, s-a primit CLOB

2025-07-23 13:52:55,511 [http-nio-1115-exec-4 - http://localhost:1115/xwiki/bin/view/TaskManager/] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 932, SQLState: 42000
2025-07-23 13:52:55,512 [http-nio-1115-exec-4 - http://localhost:1115/xwiki/bin/view/TaskManager/] ERROR o.h.e.j.s.SqlExceptionHelper   - ORA-00932: tipuri de date inconsistente: se aştepta -, s-a primit CLOB

Screenshots

Image

Environment:

  • OS: Windows 11 Pro
  • Browser: Chrome 138
  • XWiki version: 17.4.2 on Oracle 19c/ Tomcat 11
  • App version: 3.9.0

Metadata

Metadata

Assignees

Labels

ToScheduleType: Bug

Type

Bug

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions