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

Error when opening XWikiPreferences in objects editing mode on Oracle

    XMLWordPrintable

    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: