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

Cannot create subwiki with Oracle database: ORA-01950: no privileges on tablespace 'USERS'

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 9.11.8, 11.2, 10.11.5
    • Fix Version/s: None
    • Component/s: Old Core
    • Labels:
      None
    • Environment:
      Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production under Oracle Linux (developer instance running in Virtual Box Version 5.2.18_Ubuntu r123745) but also reported for Oracle DB 12.2.0.1
    • Difficulty:
      Unknown
    • Similar issues:

      Description

      If trying to create a subwiki (here just named "subwiki") with Oracle DB set up as described in https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/InstallationWAR/InstallationOracle/, the last step creates an error message:

      The wiki subwiki has been created but some pages have not been installed. Consequently, the wiki might behave erroneously and you should probably delete it. 
      

      The install log output starts with:

          Starting job of type [wikicreationjob] with identifier [wikicreation/createandinstall/subwiki]
          SQL Error: 1950, SQLState: 42000
          ORA-01950: no privileges on tablespace 'USERS'
          ORA-01950: no privileges on tablespace 'USERS'
      

      Full log in error-log-ui-xwiki-11.2.txt

      If one checks the database before deleting the broken wiki, one gets the following result:

      SQL> SELECT DISTINCT TABLESPACE_NAME FROM DBA_TABLES WHERE OWNER = 'SUBWIKI';
      
      TABLESPACE_NAME               
      ------------------------------
      USERS                         
      

      Checking for select table_name, tablespace_name, owner from dba_tables where owner = 'SUBXWIKI' shows that all tables for the XWiki DB have been created, but in the tablespace USERS instead of the prepared tablespace XWIKI where the tables (and data) for the main wiki resides, too.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                camil7 Clemens Robbenhaar
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Date of First Response: