Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-14634

Error when sorting and filtering large string based properties on Oracle Database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Critical
    • None
    • 8.4.5, 9.6
    • App Within Minutes
    • Windows 10 Pro 64 bit, Chrome v.60, Firefox v.55, IE v.11, using a local instance configured with ORACLE 11.2
    • Unknown

    Description

      Prerequisites: The instance of XWiki must be configured with Oracle Database and several users (e.g. U1, U2) must be already created.

      STEPS TO REPRODUCE

      1. Create an application with App Within Minutes from Applications Panel: More applications -> Create your own! -> Create Application
      2. On "Step 2 - Structure your data", add a Short Text Field, an User Field and a Group Field
      3. On "Step 4 - Customize your application home page", Live Table Columns section, leave only the 3 fields selected above
      4. Click Finish
      5. In the application just created, add 2 entries selecting for each one a different user and group
      6. Go to the application's main page and sort the entries by the existing columns (Short Text, User and Group)
      7. Then, filter the entries by all columns

      EXPECTED RESULTS

      Sorting and filtering work properly.

      ACTUAL RESULTS

      When sorting the entries by User and Group columns, sorting doesn't work and the following error appears in the console:

       2017-08-22 14:57:07,071 [http://localhost:9600/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=application1.livetable.&classname=Application1.Code.Application1Class&collist=shortText1%2Cuser1&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=27&sort=user1&dir=desc] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 932, SQLState: 42000
      2017-08-22 14:57:07,071 [http://localhost:9600/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=application1.livetable.&classname=Application1.Code.Application1Class&collist=shortText1%2Cuser1&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=27&sort=user1&dir=desc] ERROR o.h.u.JDBCExceptionReporter    - ORA-00932: inconsistent datatypes: expected - got CLOB
      
      2017-08-22 14:57:07,072 [http://localhost:9600/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=application1.livetable.&classname=Application1.Code.Application1Class&collist=shortText1%2Cuser1&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=27&sort=user1&dir=desc] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #gridresult_buildRowsJSON called at 117:xwiki:XWiki.LiveTableResults[line 375, column 1]
      2017-08-22 14:57:07,072 [http://localhost:9600/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=application1.livetable.&classname=Application1.Code.Application1Class&collist=shortText1%2Cuser1&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=27&sort=user1&dir=desc] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #gridresultwithfilter_buildJSON called at 117:xwiki:XWiki.LiveTableResults[line 399, column 1]
      2017-08-22 14:57:07,073 [http://localhost:9600/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=application1.livetable.&classname=Application1.Code.Application1Class&collist=shortText1%2Cuser1&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=27&sort=user1&dir=desc] ERROR o.x.v.i.DefaultVelocityEngine  - Exception in macro #gridresultwithfilter called at 117:xwiki:XWiki.LiveTableResults[line 36, column 1] 

      Also, the above mentioned sorting error affects filtering, which stops working afterwards.

      Attachments

        1. AWM_after_sorting.jpg
          82 kB
          Ilie Andriuta
        2. AWM_before_sorting.jpg
          88 kB
          Ilie Andriuta

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: