Details
Major Description
STEPS TO REPRODUCE
- Create an instance on Oracle (tested on Oracle 19c)
- (Optional) Create one or more subwikis (also with other users), to generate more entries in WikiManager LD table
- Go to Drawer > Wiki Index
- 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
- is related to
-
XWIKI-14634 Error when sorting and filtering large string based properties on Oracle Database
-
- Open
-