Details
-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
1.8.5
-
None
-
Windows 10 Pro 64 bit, Chrome v.60, Firefox v.55, IE v.11, using a local instance XWiki 8.4.5 with ORACLE 11.2
Description
Prerequisites: The instance of XWiki must be configured with Oracle Database and several users (e.g. U1, U2, U3) must be already created.
STEPS TO REPRODUCE
- Install Ideas Application
- Create several ideas (with different titles, estimated cost, priority and assignees)
- Vote several ideas with different users
- Go to Ideas Home and sort the ideas (ascending/descending) by Yes, No, Idea, Estimated cost, Status, Priority, Assignee, Update date, Last Author
- Then, also filter the ideas by the fields mentioned at Step 4
EXPECTED RESULTS
The sorting and filtering actions work properly without any errors.
ACTUAL RESULTS
When sorting by Assignee, sorting doesn't work and the following error appears in the console:
2017-08-11 15:27:37,008 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=ideas.livetable.&classname=Ideas.IdeasClass&collist=nbvotes%2Cnbagainst%2Cdoc.title%2Cnbestimate%2Cstatus%2Cpriority%2Cassignement%2Cdoc.date%2Cdoc.author&queryFilters=currentlanguage%2Chidden&&status=open&offset=1&limit=15&reqNo=8&sort=assignement&dir=asc] WARN o.h.u.JDBCExceptionReporter - SQL Error: 932, SQLState: 42000 2017-08-11 15:27:37,009 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=ideas.livetable.&classname=Ideas.IdeasClass&collist=nbvotes%2Cnbagainst%2Cdoc.title%2Cnbestimate%2Cstatus%2Cpriority%2Cassignement%2Cdoc.date%2Cdoc.author&queryFilters=currentlanguage%2Chidden&&status=open&offset=1&limit=15&reqNo=8&sort=assignement&dir=asc] ERROR o.h.u.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expected - got CLOB 2017-08-11 15:27:37,012 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=ideas.livetable.&classname=Ideas.IdeasClass&collist=nbvotes%2Cnbagainst%2Cdoc.title%2Cnbestimate%2Cstatus%2Cpriority%2Cassignement%2Cdoc.date%2Cdoc.author&queryFilters=currentlanguage%2Chidden&&status=open&offset=1&limit=15&reqNo=8&sort=assignement&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #gridresult_buildRowsJSON called at 15:xwiki:XWiki.LiveTableResults[line 381, column 1] 2017-08-11 15:27:37,012 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=ideas.livetable.&classname=Ideas.IdeasClass&collist=nbvotes%2Cnbagainst%2Cdoc.title%2Cnbestimate%2Cstatus%2Cpriority%2Cassignement%2Cdoc.date%2Cdoc.author&queryFilters=currentlanguage%2Chidden&&status=open&offset=1&limit=15&reqNo=8&sort=assignement&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #gridresultwithfilter_buildJSON called at 15:xwiki:XWiki.LiveTableResults[line 405, column 1] 2017-08-11 15:27:37,012 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=ideas.livetable.&classname=Ideas.IdeasClass&collist=nbvotes%2Cnbagainst%2Cdoc.title%2Cnbestimate%2Cstatus%2Cpriority%2Cassignement%2Cdoc.date%2Cdoc.author&queryFilters=currentlanguage%2Chidden&&status=open&offset=1&limit=15&reqNo=8&sort=assignement&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #gridresultwithfilter called at 15:xwiki:XWiki.LiveTableResults[line 36, column 1]
Also, the a.m. sorting error affects filtering, which stops working afterwards.
Attachments
Issue Links
- is duplicated by
-
-
- Open
-