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

    • Bug
    • Resolution: Fixed
    • Major
    • 13.7, 13.8-rc-1, 13.4.4
    • 13.4.1, 13.5
    • Live Data
    • Windows 10 Pro 64 bit, Edge 91, using a local instance of XWiki 13.4.1 on Oracle 19c/ Tomcat 9.0.48
    • Unit
    • Unknown
    • N/A
    • N/A

    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

        1. Panels_LD_1_Empty_Type_entry.png
          70 kB
          Ilie Andriuta
        2. Panels_LD_2_ Empty_Type_Selected.png
          50 kB
          Ilie Andriuta
        3. WikiManager_LD_filtered_by_empty.gif
          231 kB
          Ilie Andriuta

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-14634 Error when sorting and filtering large string based properties on Oracle Database

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: