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

Error when opening XWikiPreferences in objects editing mode on Oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 10.6.1
    • None
    • Windows 10 Pro 64 bit, Chrome 68, using a local instance of XWiki 10.6.1 and 9.11.7 on Oracle 11.2
    • Unknown

    Description

      STEPS TO REPRODUCE

      Preconditions: The XWiki (10.6.1) instance is configured with Oracle (11.2).

      1. Login as Admin
      2. Go to 
        http://<yourwiki>/xwiki/bin/edit/XWiki/XWikiPreferences?editor=object

      EXPECTED RESULTS

      The page XWikiPreferences opens in object editing mode without any errors.

      ACTUAL RESULTS

      When opening the page in objects edit mode, the following error is encountered in the console:

      2018-08-16 17:42:36,309 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/XWiki.XWikiGlobalRights/properties/groups/values?fp=XWiki.XWikiAdminGroup&limit=10] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 932, SQLState: 42000
2018-08-16 17:42:36,309 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/XWiki.XWikiGlobalRights/properties/groups/values?fp=XWiki.XWikiAdminGroup&limit=10] ERROR o.h.u.JDBCExceptionReporter    - ORA-00932: inconsistent datatypes: expected - got CLOB

2018-08-16 17:42:36,310 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/XWiki.XWikiRights/properties/groups/values?fp=XWiki.XWikiAdminGroup&limit=10] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 932, SQLState: 42000
2018-08-16 17:42:36,311 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/XWiki.XWikiRights/properties/groups/values?fp=XWiki.XWikiAdminGroup&limit=10] ERROR o.h.u.JDBCExceptionReporter    - ORA-00932: inconsistent datatypes: expected - got CLOB

2018-08-16 17:42:36,316 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/XWiki.XWikiGlobalRights/properties/groups/values?fp=XWiki.XWikiAllGroup&limit=10] WARN  o.h.u.JDBCExceptionReporter    - SQL Error: 932, SQLState: 42000
2018-08-16 17:42:36,316 [http://localhost:1062/xwiki/rest/wikis/xwiki/classes/XWiki.XWikiGlobalRights/properties/groups/values?fp=XWiki.XWikiAllGroup&limit=10] ERROR o.h.u.JDBCExceptionReporter    - ORA-00932: inconsistent datatypes: expected - got CLOB

      I've tested also on XWiki 9.11.7, but the issue could not be reproduced.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-14634 Error when sorting and filtering large string based properties on Oracle Database

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          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

              mflorea Marius Dumitru Florea
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: