Family Empowerment

org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [{{html}}
##------------------------------------------------------------------------------------
## WaihonaPedia has a Topic-tag model
## the idea is like the xwiki-tag model, but the difference that you can only tag with predefined Topics
## Below we show these tags
## and when context.user is a moderator we offer some edit functionality
##------------------------------------------------------------------------------------
## Refactored "Read More Like This" Logic

#set($topicClassName = "WaihonaCode.pageTopicTagClass")
#set($storyClassName = 'WaihonaCode.themeRoomCloserLookClass')
#set($atePublicClassName = 'WaihonaCode.ATEPublic.ATEPublicClass')
## Predefine the class and query for topic descriptions
#set($topicDescriptionClassName = 'WaihonaCode.healthTopicsClass')

#set($articleClasses = [$storyClassName, $atePublicClassName])
#set($articleTypes = {
  "stories": $storyClassName,
  "answers": $atePublicClassName,
  "information": $topicClassName
})
## Define the sheet mapping for index displayers
#set($articleTypeIndexSheets = {
  "stories": "WaihonaCode.publicInfo.storyDisplayer",
  "answers": "ATEPublic.topicATEDisplayer",
  "information": "WaihonaCode.publicInfo.infoDisplayer"
})


#set($topicTagQueryDef = "from doc.object($topicClassName) as topicTag where topicTag.topicKey = :key")
#set($storyQueryDef = "from doc.object($storyClassName) as story where story.storyTopicKey = :key")
#set($topicDescriptionQueryDef = "from doc.object($topicDescriptionClassName) as topic where topic.key = :thisKey")

## Step 1: Collect unique topicKeys for the current page
#set($topicKeys = [])

## Collect topicKeys from WaihonaCode.pageTopicTagClass
#set($classKeys = [])
#foreach($topicObject in $doc.getObjects($topicClassName, "topicType", "2"))
  #if($topicObject.getProperty("topicKey").getValue())
    #set($discard = $classKeys.add($topicObject.getProperty("topicKey").getValue()))
  #end
#end
#set($topicKeys = $collectiontool.union($topicKeys, $classKeys))

## Collect topicKeys from article-specific classes
#set($articleKeys = [])
#foreach($className in $articleClasses)
  #if($doc.getObject($className) && $doc.getObject($className).getProperty("storyTopicKey").getValue())
    #set($discard = $articleKeys.add($doc.getObject($className).getProperty("storyTopicKey").getValue()))
  #end
#end
#set($topicKeys = $collectiontool.union($topicKeys, $articleKeys))
#if($doc.getObject($atePublicClassName))
  #set($ateTopicKeys = [])
  #getATETopicTags($ateTopicKeys)
  #set($topicKeys = $collectiontool.union($topicKeys, $ateTopicKeys))
#end

## Define the disease-based root path (adjust dynamically for the current disease)
## Assume that the list of topicKeys point a the collection of diseases
## But currently ONE artike is linked to maximum of ONE dsisease, so we can safely break after ONE
#set($diseaseLibraryBasePath = '')
#foreach($thisKey in $topicKeys)
  #getDiseaseWithTopic($thisKey, $diseaseLibraryBasePath)
  #break
#end
#if($diseaseLibraryBasePath != '')
  #set($diseaseLibraryDoc = $xwiki.getDocument($diseaseLibraryBasePath))
#end

## Step 2: Query and count articles by type for each topicKey
#set($tagData = {}) ## Structure: { topicKey: {type: count} }
#set($currentDocRef = $doc.getDocumentReference())

#foreach($key in $topicKeys)
  #set($typeCounts = {})
  #set($storyDocRefArray = [])
  #set($ateDocRefArray = [])
  #foreach($type in $articleTypes.keySet())
    #set($className = $articleTypes.get($type))
    #set($typeCount = 0)
    ## Dynamic query based on article type
    #if($className == $storyClassName)
      ## For Patient story type, use storyTopicKey
      #set($articlesHavingStoryClassList = $services.query.xwql($storyQueryDef).bindValue("key", $key).addFilter("unique").execute())
      #foreach($articlesHavingStoryDocRef in $articlesHavingStoryClassList)
        #if($xwiki.getDocument($articlesHavingStoryDocRef).getDocumentReference() != $currentDocRef)## Avoid double count
          #set($typeCount = $typeCount + 1)
          #set($discard = $storyDocRefArray.add($articlesHavingStoryDocRef))## to be able to filter topicTag Query
        #end
      #end
      ## For other types, loop through a list of pages with topicTagObjects
      #set($potentialStoryDocRefList = $services.query.xwql($topicTagQueryDef).bindValue("key", $key).addFilter("unique").execute())
      #foreach($potentialStoryDocRef in $potentialStoryDocRefList)
        #if($xwiki.getDocument($potentialStoryDocRef).getObject($className)
        && !$storyDocRefArray.contains($potentialStoryDocRef))
          #if($xwiki.getDocument($potentialStoryDocRef).getDocumentReference() != $currentDocRef)## Avoid double count
            #set($discard = $storyDocRefArray.add($potentialStoryDocRef))
            #set($typeCount = $typeCount + 1)
          #end
        #end
      #end
    #else
      ## For other types, loop through a list of pages with topicTagObjects
      #set($otherTypeDocRefList = $services.query.xwql($topicTagQueryDef).bindValue("key", $key).addFilter("unique").execute())
      #set($typeCount = 0)
      ## Issue with count of Expert Articles, example WaihonaPediaThemes.cdls0.cdls0sub2 counts 2 expert articles while there is only 1?
      #foreach($otherTypeDocRef in $otherTypeDocRefList)
        #if($xwiki.getDocument($otherTypeDocRef).getObject($className))
          #if($xwiki.getDocument($otherTypeDocRef).getDocumentReference() != $currentDocRef)  ## Avoid double count
            ## Issue with ATEPublic articles, on the number found seems still to double count because of translation issue
            #if($className == $atePublicClassName)
              #set($discard = $ateDocRefArray.add($otherTypeDocRef))
              #set($typeCount = $typeCount + 1)
            #else
              #if(!$ateDocRefArray.contains($otherTypeDocRef)
               && !$storyDocRefArray.contains($otherTypeDocRef)
               && !$otherTypeDocRef.contains('cdlsPublications'))##this clause is for dev only!
                #set($typeCount = $typeCount + 1)
              #end
            #end##$className == $atePublicClassName
          #end## Avoid double count
        #end##class name  
      #end
    #end
    #set($discard = $typeCounts.put($type, $typeCount))
  #end

  ## Calculate total count manually
  #set($totalCount = 0)
  #foreach($count in $typeCounts.values())
    #set($totalCount = $totalCount + $count)
  #end

  ## Add typeCounts to tagData if there is at least one non-zero count
  #if($totalCount > 0)
    #set($discard = $tagData.put($key, $typeCounts))
  #end
#end

## Step 3: Render tags if article count > 0
#if($tagData.size() > 0)
<div class='meta-topics'>
  <span class='meta-topics-label'>$services.localization.render('waihonapedia.meta.topics.title')</span>
  <span class="topics-with-page">
  #foreach($entry in $tagData.entrySet())
    #set($key = $entry.key)
    #set($typeCounts = $entry.value)
    ## Fetch the localized description for the current topicKey
    #set($topicDescription = "")
    #set($topicDescriptionList = $services.query.xwql($topicDescriptionQueryDef).bindValue('thisKey', $key).addFilter('unique').execute())
    #foreach($topicDescriptionDocRef in $topicDescriptionList)
      #set($topicDescriptionDoc = $xwiki.getDocument($topicDescriptionDocRef))
      #set($topicDescription = $topicDescriptionDoc.getTranslatedDocument().getPlainTitle())
    #end
    ## Iterate through each type and count
    #foreach($type in $articleTypes.keySet())
      #if($typeCounts.get($type) > 0)
        ## Construct the index page URL dynamically
        #set($indexSheet = $articleTypeIndexSheets.get($type))
        #set($indexURL = $diseaseLibraryDoc.getURL('view', "sheet=${indexSheet}&topic=${key}"))
        <span class="label topic-link">
          <a href="$indexURL">
            <span class='wai-tile-icon-area'>
              <span class="wai-tile-icon waihonapedia-${type}" style='width: 1.25em; height: 1.25em;'> </span>
            </span> $topicDescription <span class='badge badge-light'>${typeCounts.get($type)}</span>
          </a>
        </span>
      #end
    #end
  #end
  </span>
</div>
#end

#macro(getDiseaseWithTopic $thisTopicKey, $diseaseLibraryBasePath)
  ##titi $thisTopicKey
  #set($diseaseClassName = 'WaihonaCode.diseaseClass')
  #set($diseaseTagClassName = 'WaihonaCode.ATEPublic.diseaseTagClass')
  #set($topicClassName = 'WaihonaCode.healthTopicsClass')
  #set($topicQueryByKeyDef = "from doc.object($topicClassName) as topic where topic.key = :thisTopicKey")
  #set($topicQueryByParentKeyDef = "from doc.object($topicClassName) as topic where topic.parent = :thisParentKey")
  #set($diseaseByKeyQueryDef = "from doc.object($diseaseClassName) as disease where disease.key = :diseaseKey")
  ##
  #set($topicDocRefByKeyList = $services.query.xwql($topicQueryByKeyDef).bindValue("thisTopicKey", $thisTopicKey ).addFilter("unique").execute())
  #foreach($topicDocRef in $topicDocRefByKeyList)
    #set($topicDoc = $xwiki.getDocument($topicDocRef) )
    #if(!$topicDoc.getObject($diseaseTagClassName))
      #set($diseaseObject = {})
      #getDisease($thisTopicKey, $diseaseObject)
      #set($diseaseDocRefByKeyList = $services.query.xwql($diseaseByKeyQueryDef).bindValue("diseaseKey", $diseaseObject.key ).addFilter("unique").execute())
      #foreach($diseaseDocRef in $diseaseDocRefByKeyList)
        #set($diseaseDoc = $xwiki.getDocument($diseaseDocRef))
        #set($diseaseLibraryBasePath = $diseaseDoc.getObject($diseaseClassName).getProperty('publicationspace').getValue())
      #end
    #else
      #set($diseaseKey = $topicDoc.getObject($diseaseTagClassName).getProperty('diseaseKey').getValue() )
      #set($diseaseDocRefByKeyList = $services.query.xwql($diseaseByKeyQueryDef).bindValue("diseaseKey", $diseaseKey ).addFilter("unique").execute())
      #foreach($diseaseDocRef in $diseaseDocRefByKeyList)
        #set($diseaseDoc = $xwiki.getDocument($diseaseDocRef))
        #set($diseaseLibraryBasePath = $diseaseDoc.getObject($diseaseClassName).getProperty('publicationspace').getValue())
      #end
    #end
  #end
#end

#macro(getATETopicTags)
  #set($ateQuestionParentQueryDef = "from doc.object($atePublicClassName) as qa where qa.questionID = :questionID")
  #set($ateQuestionTranslationsQueryDef = "from doc.object($atePublicClassName) as qa where qa.parentQuestionID = :questionID")
## Step 1: Identify Translations of the Current Page
  #set($relatedPages = [])
##if($doc.getObject($atePublicClassName))
  ## Check if this is a translated page (has 'parentQuestionID')
  #set($parentQuestionID = $doc.getObject($atePublicClassName).getProperty('parentQuestionID').getValue())
  #set($questionID = $doc.getObject($atePublicClassName).getProperty('questionID').getValue())

  #if($parentQuestionID)
    ## Fetch the original page (parent of the translation)
    #set($originalPageList = $services.query.xwql($ateQuestionParentQueryDef).bindValue('questionID', $parentQuestionID).addFilter('unique').execute())
    #set($relatedPages = $collectiontool.union($relatedPages, $originalPageList))
  #elseif($questionID)
    ## Fetch all translations of this page
    #set($translationPageList = $services.query.xwql($ateQuestionTranslationsQueryDef).bindValue('questionID', $questionID).addFilter('unique').execute())
    #set($relatedPages = $collectiontool.union($relatedPages, $translationPageList))
  #end

  ## Add the current page to the relatedPages
  #set($currentPageRef = $doc.getDocumentReference())
  #if(!$relatedPages.contains($currentPageRef))
    #set($discard = $relatedPages.add($currentPageRef))
  #end

  ## Step 2: Collect TopicTags from All Related Pages
  #set($aggregatedTopicKeys = [])
  #foreach($pageRef in $relatedPages)
    #set($relatedDoc = $xwiki.getDocument($pageRef))
    #foreach($topicObject in $relatedDoc.getObjects($topicClassName, "topicType", "2"))
      #if($topicObject.getProperty("topicKey").getValue())
        #set($discard = $aggregatedTopicKeys.add($topicObject.getProperty("topicKey").getValue()))
      #end
    #end
  #end

  ## Ensure Unique TopicKeys Manually
  #set($uniqueTopicKeysMap = {})
  #foreach($topicKey in $aggregatedTopicKeys)
    #if(!$uniqueTopicKeysMap.containsKey($topicKey))
      #set($discard = $uniqueTopicKeysMap.put($topicKey, true))
    #end
  #end

  ## Convert the Map keys back to a list
  #foreach($key in $uniqueTopicKeysMap.keySet())
    #set($discard = $ateTopicKeys.add($key))
  #end
#end

#macro(getDisease $thisTopicKey $diseaseObject)
  #set($maxDepth = 10)
  #set($range = [0..$maxDepth])
  #set($currentKey = $thisTopicKey)
  #set($found = false)
  #foreach($i in $range)
    #if($found || !$currentKey)
      #break()
    #end
    ## Your logic here, e.g., querying with $currentKey
    #set($topicDocList = $services.query.xwql($topicQueryByKeyDef).bindValue('thisTopicKey', $currentKey).addFilter('unique').execute())
    #if($topicDocList.size() > 0)
      #foreach($topicDocRef in $topicDocList)
        #set($topicDoc = $xwiki.getDocument($topicDocRef))
        #if($topicDoc.getObject($diseaseTagClassName))
          #set($found = true)
          #toplevelTopic($topicDoc.documentReference $diseaseObject)
        #else
          #set($topicObj = $topicDoc.getObject($topicClassName))
          #set($currentKey = $topicObj.getProperty('parent').getValue())
        #end
      #end
    #else
      #set($currentKey = '')
    #end
  #end
#end
#macro(toplevelTopic $topicTopLevelDocRef $diseaseObject)
  #set($diseaseKey = $xwiki.getDocument($topicTopLevelDocRef).getObject($diseaseTagClassName).getProperty('diseaseKey').getValue() )
  #if($diseaseKey && $diseaseKey != '')
    #set($discard = $diseaseObject.put('key', $diseaseKey))
    #set($diseaseClassName = 'WaihonaCode.diseaseClass')
    #set($diseaseQueryDef = "from doc.object($diseaseClassName) as dis where dis.key = :thisKey")
    #set($diseaseDocList = $services.query.xwql($diseaseQueryDef).bindValue('thisKey', $diseaseKey).addFilter('unique').execute() )
    #foreach($diseaseDocRef in $diseaseDocList)
      #set($thisTitle = $xwiki.getDocument($diseaseDocRef).getTranslatedDocument().getPlainTitle())
      #set($thisContent = $xwiki.getDocument($diseaseDocRef).getTranslatedContent() )
    #end
  #else
    #set($thisTitle = "unknown syndrome on $xwiki.getDocument($topicTopLevelDocRef).getPlainTitle()")
    #set($thisContent = '' )
  #end
  #set($discard = $diseaseObject.put('title', $thisTitle) )
  #set($discard = $diseaseObject.put('content', $thisContent) )
#end
{{/html}}]
 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:311)
 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.uiextension.internal.WikiUIExtension.render(WikiUIExtension.java:200)
 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 jdk.internal.reflect.GeneratedMethodAccessor366.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 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.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:225)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:105)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:853)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:808)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:800)
 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 jdk.internal.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 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:218)
 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:225)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:105)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:853)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:808)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderNoException(InternalTemplateManager.java:800)
 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 jdk.internal.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 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:218)
 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.ASTIfStatement.render(ASTIfStatement.java:171)
 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:225)
 at com.xpn.xwiki.internal.template.VelocityTemplateEvaluator.evaluateContent(VelocityTemplateEvaluator.java:105)
 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:904)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:866)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.renderFromSkin(InternalTemplateManager.java:846)
 at com.xpn.xwiki.internal.template.InternalTemplateManager.render(InternalTemplateManager.java:832)
 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:2565)
 at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:180)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:651)
 at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:339)
 at com.xpn.xwiki.web.LegacyActionServlet.service(LegacyActionServlet.java:108)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:232)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:122)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:61)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:132)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:194)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:167)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1651)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with namespace [xwiki:WaihonaBase.uixCollections.contentFooter.waiTopicTagsUIX-2^XWiki.UIExtensionClass[0]]
 at org.xwiki.velocity.internal.InternalVelocityEngine.evaluate(InternalVelocityEngine.java:227)
 at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:168)
 ... 180 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 disease , com.xpn.xwiki.objects.StringProperty as disease_key1 where ( disease_key1.value = :diseaseKey ) and doc.fullName=disease.name and disease.className='WaihonaCode.diseaseClass' and disease_key1.id.id=disease.id and disease_key1.id.name='key' ] at xwiki:WaihonaBase.uixCollections.contentFooter.waiTopicTagsUIX-2[line 192, column 141]
 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.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.directive.VelocimacroProxy.render(VelocimacroProxy.java:218)
 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.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.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:225)
 ... 181 more
Caused by: org.xwiki.query.QueryException: Exception while executing query. Query statement = [ select doc.fullName from XWikiDocument as doc , BaseObject as disease , com.xpn.xwiki.objects.StringProperty as disease_key1 where ( disease_key1.value = :diseaseKey ) and doc.fullName=disease.name and disease.className='WaihonaCode.diseaseClass' and disease_key1.id.id=disease.id and disease_key1.id.name='key' ]
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:184)
 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:276)
 at jdk.internal.reflect.GeneratedMethodAccessor290.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)
 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)
 ... 204 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:835)
 at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:902)
 at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:169)
 ... 217 more
Caused by: java.lang.NullPointerException