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

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

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 8.4.5, 9.6
    • Fix Version/s: None
    • Component/s: App Within Minutes
    • Labels:
    • Environment:
      Windows 10 Pro 64 bit, Chrome v.60, Firefox v.55, IE v.11, using a local instance configured with ORACLE 11.2
    • Difficulty:
      Unknown
    • Similar issues:

      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

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                iandriuta Ilie Andriuta
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Date of First Response: