Uploaded image for project: 'Ideas Application'
  1. Ideas Application
  2. IDEAS-69

Sorting doesn't work on instance configured with Oracle Database

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 1.8.5
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      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
    • Similar issues:

      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

      1. Install Ideas Application
      2. Create several ideas (with different titles, estimated cost, priority and assignees)
      3. Vote several ideas with different users
      4. Go to Ideas Home and sort the ideas (ascending/descending) by Yes, No, Idea, Estimated cost, Status, Priority, Assignee, Update date, Last Author
      5. 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

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: