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

Sorting doesn't work on instance configured with Oracle Database

    XMLWordPrintable

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

      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

        1. Ideas_ascending.jpg
          125 kB
          Ilie Andriuta
        2. Ideas_descending.jpg
          121 kB
          Ilie Andriuta

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: