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

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 1.6
    • 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.

      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

          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: