Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-18804

Filtering empty values on LiveData tables doesn't work on Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 13.4.1, 13.5
    • Fix Version/s: 13.7, 13.8-rc-1, 13.4.4
    • Component/s: Live Data
    • Labels:
    • Environment:
      Windows 10 Pro 64 bit, Edge 91, using a local instance of XWiki 13.4.1 on Oracle 19c/ Tomcat 9.0.48
    • Tests:
      Unit
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      STEPS TO REPRODUCE

      1. Create an instance on Oracle (tested on Oracle 19c)
      2. (Optional) Create one or more subwikis (also with other users), to generate more entries in WikiManager LD table
      3. Go to Drawer > Wiki Index
      4. From Owner column filter box, select "---"

      EXPECTED RESULTS

      Filtering is applied properly, no entry is displayed, since all entries have an owner set.

      ACTUAL RESULTS

      The LiveData table appears to be loading continuously in the back-end and all entries are still displayed. In XWiki console there is the following error:

      2021-06-29 14:34:06,343 [http-nio-1115-exec-3 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1624966446238&sourceParams.resultPage=WikiManager.WikisLiveTableResults&sourceParams.translationPrefix=platform.wiki.browse.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=XWiki.XWikiServerClass&properties=wikiprettyname&properties=description&properties=owner&properties=doc.creationDate&properties=membershipType&properties=_actions&offset=0&limit=10&filters.owner=empty%3A&sort=wikiprettyname&descending=] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 932, SQLState: 42000
      2021-06-29 14:34:06,343 [http-nio-1115-exec-3 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1624966446238&sourceParams.resultPage=WikiManager.WikisLiveTableResults&sourceParams.translationPrefix=platform.wiki.browse.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=XWiki.XWikiServerClass&properties=wikiprettyname&properties=description&properties=owner&properties=doc.creationDate&properties=membershipType&properties=_actions&offset=0&limit=10&filters.owner=empty%3A&sort=wikiprettyname&descending=] ERROR o.h.e.j.s.SqlExceptionHelper   - ORA-00932: tipuri de date inconsistente: se a?tepta -, s-a primit CLOB
      
      2021-06-29 14:34:06,360 [http-nio-1115-exec-3 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1624966446238&sourceParams.resultPage=WikiManager.WikisLiveTableResults&sourceParams.translationPrefix=platform.wiki.browse.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=XWiki.XWikiServerClass&properties=wikiprettyname&properties=description&properties=owner&properties=doc.creationDate&properties=membershipType&properties=_actions&offset=0&limit=10&filters.owner=empty%3A&sort=wikiprettyname&descending=] ERROR o.a.v.d.null                   - Exception in macro #gridresult_buildTagCloudJSON called at xwiki:WikiManager.WikisLiveTableResults[line 463, column 1]
      2021-06-29 14:34:06,361 [http-nio-1115-exec-3 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1624966446238&sourceParams.resultPage=WikiManager.WikisLiveTableResults&sourceParams.translationPrefix=platform.wiki.browse.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=XWiki.XWikiServerClass&properties=wikiprettyname&properties=description&properties=owner&properties=doc.creationDate&properties=membershipType&properties=_actions&offset=0&limit=10&filters.owner=empty%3A&sort=wikiprettyname&descending=] ERROR o.a.v.d.null                   - Exception in macro #gridresultwithfilter_buildJSON called at xwiki:WikiManager.WikisLiveTableResults[line 487, column 1]
      2021-06-29 14:34:06,362 [http-nio-1115-exec-3 - http://localhost:1115/xwiki/rest/liveData/sources/liveTable/entries?timestamp=1624966446238&sourceParams.resultPage=WikiManager.WikisLiveTableResults&sourceParams.translationPrefix=platform.wiki.browse.&sourceParams.queryFilters=currentlanguage%2Chidden&sourceParams.className=XWiki.XWikiServerClass&properties=wikiprettyname&properties=description&properties=owner&properties=doc.creationDate&properties=membershipType&properties=_actions&offset=0&limit=10&filters.owner=empty%3A&sort=wikiprettyname&descending=] ERROR o.a.v.d.null                   - Exception in macro #gridresultwithfilter called at xwiki:WikiManager.WikisLiveTableResults[line 27, column 1]

      The Oracle error is:

      ORA-00932: inconsistent datatypes: expected -, got CLOB

      Also, on Panels homepage "/xwiki/bin/view/Panels", if an entry has set an empty Type value for example and the empty "---" suggestion filter is applied, no results are displayed, but in this case there is no error generated in console.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mleduc Manuel Leduc
              Reporter:
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: