Uploaded image for project: 'Meeting Application'
  1. Meeting Application
  2. XAMEETINGS-143

Sorting meetings doesn't work on instance configured with Oracle Database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Minor
    • None
    • 1.6
    • 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.

      STEPS TO REPRODUCE

      1. Install Meetings Application
      2. Create several meeting entries (with different titles, leaders, places, start dates and statuses)
      3. Go to Meetings Home and sort the meeting entries (ascending/descending) by Meeting, Leader, Place, Start, Status
      4. Then, also filter the meeting entries by the fields mentioned at Step 3

      EXPECTED RESULTS

      The sorting and filtering actions work properly without any errors.

      ACTUAL RESULTS

      When sorting by Leader, sorting doesn't work and the following error appears in the console:

       2017-08-14 12:26:47,165 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 932, SQLState: 42000
      2017-08-14 12:26:47,165 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] ERROR o.h.u.JDBCExceptionReporter    - ORA-00932: inconsistent datatypes: expected - got CLOB
      
      2017-08-14 12:26:47,167 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #gridresult_buildRowsJSON called at 74:xwiki:XWiki.LiveTableResults[line 381, column 1]
      2017-08-14 12:26:47,168 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #gridresultwithfilter_buildJSON called at 74:xwiki:XWiki.LiveTableResults[line 405, column 1]
      2017-08-14 12:26:47,168 [http://localhost:8450/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=meeting.livetable.&classname=Meeting.MeetingClass&collist=doc.title%2Cleader%2Cplace%2CstartDate%2CdurationString%2Cstatus&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=18&sort=leader&dir=asc] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #gridresultwithfilter called at 74:xwiki:XWiki.LiveTableResults[line 36, column 1]

      Also, the a.m. sorting error affects filtering, which stops working afterwards.

      Attachments

        1. Meeting_ascending.jpg
          126 kB
          Ilie Andriuta
        2. Meeting_descending.jpg
          124 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: