Details
-
Bug
-
Resolution: Fixed
-
Critical
-
8.4.4, 9.11.8, 11.2, 10.11.5
-
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
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
- is related to
-
-
- Closed
-
-
-
- Closed
-