Uploaded image for project: 'XWiki Build Images'
  1. XWiki Build Images
  2. XDOCKBUILD-8

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • 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 in Release Notes:
      N/A
    • Similar issues:

      Description

      STEPS TO REPRODUCE

      1. 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)
      2. Start the instance and run DW
      3. 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

          Issue Links

            Activity

              People

              Assignee:
              vmassol Vincent Massol
              Reporter:
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response: