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

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. IDEAS-69 Sorting doesn't work on instance configured with Oracle Database

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. XAMEETINGS-143 Sorting meetings doesn't work on instance configured with Oracle Database

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. TASKMAN-69 'My Due Tasks' Panel displays error on ORACLE Database

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-15500 Error when opening XWikiPreferences in objects editing mode on Oracle

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CRAPP-133 Errors in console when accessing the Profile page or Notification Settings page on Oracle

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-18804 Filtering empty values on LiveData tables doesn't work on Oracle

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. XWIKI-16197 Implement relational storage for properties of type "List of users" and "List of groups"

          • Major - Major loss of function.
          • Open

          Activity

            People

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

              Dates

                Created:
                Updated: