Nuxeo DM 5.4 for Tomcat startup fails with two or more schemas over Oracle
Database
-----------------------------------------------------------------------------------
Key: NXP-5989
URL: https://jira.nuxeo.org/browse/NXP-5989
Project: Nuxeo Enterprise Platform
Issue Type: Bug
Affects Versions: 5.4
Reporter: Daniel Giribet
If we have one schema (for example, called NUXEO1), Nuxeo startup works fine.
When a second schema are created (for example, called NUXEO2), and
we try to startup Nuxeo with this new user, it fails. Error logs messages are
something like this:
2010-11-15 16:25:36,524 INFO [org.nuxeo.runtime.osgi.OSGiRuntimeService] Nuxeo
EP Started
======================================================================
= Nuxeo EP Started
======================================================================
= Component Loading Status: Pending: 0 / Unstarted: 0 / Total: 383
======================================================================
2010-11-15 16:25:36,556 INFO
[org.jbpm.persistence.db.StaleObjectLogConfigurer] stale object exceptions will
be hidden from logging
2010-11-15 16:25:36,559 INFO [org.jbpm.JbpmConfiguration] using jbpm
configuration resource 'jbpm.cfg.xml'
2010-11-15 16:25:40,423 WARN [org.hibernate.util.JDBCExceptionReporter] SQL
Error: 1031, SQLState: 42000
2010-11-15 16:25:40,423 ERROR [org.hibernate.util.JDBCExceptionReporter]
ORA-01031: insufficient privileges
2010-11-15 16:25:40,424 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could
not complete schema update
org.hibernate.exception.SQLGrammarException: could not get table metadata:
JBPM_ACTION
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at
org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:128)
at
org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:995)
at
org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:187)
at
org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:356)
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
at
org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:105)
at
org.nuxeo.ecm.platform.jbpm.core.service.JbpmComponent.frameworkEvent(JbpmComponent.java:240)
at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:203)
at
org.nuxeo.osgi.application.loader.FrameworkLoader.doStart(FrameworkLoader.java:201)
at
org.nuxeo.osgi.application.loader.FrameworkLoader.start(FrameworkLoader.java:136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.nuxeo.osgi.application.FrameworkBootstrap.start(FrameworkBootstrap.java:134)
at
org.nuxeo.runtime.tomcat.NuxeoLauncher.handleEvent(NuxeoLauncher.java:78)
at
org.nuxeo.runtime.tomcat.NuxeoLauncher.lifecycleEvent(NuxeoLauncher.java:62)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4424)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.sql.SQLException: ORA-01031: insufficient privileges
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
at
oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1487)
at
oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3296)
at
org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:167)
at
org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:61)
at
org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:113)
... 40 more
.........
.........
and so on.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
