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

Error when opening XWikiPreferences in objects editing mode on Oracle

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.6.1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      Windows 10 Pro 64 bit, Chrome 68, using a local instance of XWiki 10.6.1 and 9.11.7 on Oracle 11.2
    • Difficulty:
      Unknown
    • Similar issues:

      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Date of First Response: