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

Error when deleting pages on ORACLE with FileSystem configuration

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 9.0
    • Fix Version/s: 9.11-rc-1
    • Component/s: Old Core
    • Labels:
    • Environment:
      Windows 10 Pro 64 bit, Chrome v.62, Firefox v.57, IE v.11, Edge v.16 using a local instance XWiki 9.10.1 on ORACLE 11.2
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      STEPS TO REPRODUCE:

      Precondition: Have an instance of XWiki 9.10.1 configured with ORACLE (11.2) Database.

      1. Go to the instance's folder and change the document storage configuration to FileSystem by editing the
        [...]webapps\xwiki\WEB-INF\xwiki.cfg

        file

      2. Uncomment and modify this parameter as follows:
        xwiki.store.recyclebin.content.hint=file
        
      3. Start XWiki instance
      4. Create a page
      5. Delete the page

      EXPECTED RESULTS

      The respective page is deleted and appears displayed in 'Page Index' > 'Deleted Pages' Tab.

      ACTUAL RESULTS

      An error is displayed in the browser and the page is not displayed in the 'Deleted Pages' Tab.

      Stacktrace of the error:

       
      Some errors happened:
      ORA-01400: cannot insert NULL into ("XWIKI"."XWIKIRECYCLEBIN"."XDD_XML")
      Exception while close transaction

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tmortagne Thomas Mortagne
                Reporter:
                iandriuta Ilie Andriuta
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: