Loading...

Details

Type: Bug
Resolution: Fixed
Priority: Critical
Component/s: Oracle
Labels:
None
Environment:
Windows 10 Pro 64 bit, Firefox 78, using a local instance of XWiki 12.5.1 on Oracle 19.3 (Docker image), Tomcat 9.0.36

Difficulty:
Unknown
Documentation:
https://github.com/xwiki/xwiki-docker-build/blob/master/build-oracle/README.md
Documentation in Release Notes:
N/A
Similar issues:

Description

STEPS TO REPRODUCE

Configure a fresh instance of XWiki (e.g. 12.5.1) to run with XWiki Oracle Docker image (I've tested with xwiki/oracle-database:19.3.0-se2)
Start the instance and run DW
Create a subwiki (e.g. with scope 'Both global and local users are available in the wiki')

EXPECTED RESULTS

The subwiki is created successfully.

ACTUAL RESULTS

The subwiki could not be created, some errors are encountered in browser. Stacktrace:

ORA-65096: nume nevalid pt. utilizator comun sau rol
class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to execute creation steps on the wiki [subwikiglobal].
    at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:104)
    at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:240)
    at org.xwiki.job.AbstractJob.run(AbstractJob.java:217)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to create the wiki [subwikiglobal].
    at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:54)
    at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96)
    at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:240)
    at org.xwiki.job.AbstractJob.run(AbstractJob.java:217)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: class org.xwiki.wiki.manager.WikiManagerException: Failed to create database for wiki "subwikiglobal"
    at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:75)
    at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:96)
    at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52)
    at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96)
    at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:240)
    at org.xwiki.job.AbstractJob.run(AbstractJob.java:217)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: class com.xpn.xwiki.XWikiException: Error number 0 in 0: Error number 3401 in 3: Exception while create wiki database subwikiglobal
    at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:312)
    at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:725)
    at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:73)
    at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:96)
    at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52)
    at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96)
    at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:240)
    at org.xwiki.job.AbstractJob.run(AbstractJob.java:217)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: class org.hibernate.exception.GenericJDBCException: error executing work
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:311)
    at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1084)
    at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1071)
    at org.hibernate.engine.spi.SessionDelegatorBaseImpl.doWork(SessionDelegatorBaseImpl.java:1105)
    at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:274)
    at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:725)
    at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:73)
    at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:96)
    at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52)
    at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96)
    at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:240)
    at org.xwiki.job.AbstractJob.run(AbstractJob.java:217)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: class java.sql.SQLException: ORA-65096: nume nevalid pt. utilizator comun sau rol

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at com.xpn.xwiki.store.XWikiHibernateStore.lambda$createWiki$0(XWikiHibernateStore.java:283)
    at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)
    at org.hibernate.internal.AbstractSharedSessionContract.lambda$doWork$1(AbstractSharedSessionContract.java:1068)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:306)
    at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1084)
    at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1071)
    at org.hibernate.engine.spi.SessionDelegatorBaseImpl.doWork(SessionDelegatorBaseImpl.java:1105)
    at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:274)
    at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:725)
    at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:73)
    at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:96)
    at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52)
    at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96)
    at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:240)
    at org.xwiki.job.AbstractJob.run(AbstractJob.java:217)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: class oracle.jdbc.OracleDatabaseException: ORA-65096: nume nevalid pt. utilizator comun sau rol

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
    at com.xpn.xwiki.store.XWikiHibernateStore.lambda$createWiki$0(XWikiHibernateStore.java:283)
    at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)
    at org.hibernate.internal.AbstractSharedSessionContract.lambda$doWork$1(AbstractSharedSessionContract.java:1068)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:306)
    at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1084)
    at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1071)
    at org.hibernate.engine.spi.SessionDelegatorBaseImpl.doWork(SessionDelegatorBaseImpl.java:1105)
    at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:274)
    at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:725)
    at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:73)
    at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:96)
    at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52)
    at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96)
    at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:240)
    at org.xwiki.job.AbstractJob.run(AbstractJob.java:217)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)

The issue could not be reproduced using Oracle 19.3 locally on my machine.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

ORA-65096_error.png
60 kB
08/Jul/20 14:46

Issue Links

relates to

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

Closed

Cannot create subwikis using Oracle 19.3: ORA-65096: invalid common user or role name

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates