Thanks Eric! I'll try that. Here is the full stack trace of this error:
ERROR [main] hbm2ddl.SchemaUpdate Jan/16 10:53:41.368 - could not
complete schema update
[java] org.hibernate.exception.SQLGrammarException: could not get
table metadata: UP_PORTLET_PREF_VALUES
[java] at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
[java] at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
[java] at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
[java] at
org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:105)
[java] at
org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:948)
[java] at
org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
[java] at
org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314)
[java] at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
[java] at
org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915)
[java] at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:730)
[java] at
org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
[java] at
org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:221)
[java] at
org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:251)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1390)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1359)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:540)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:485)
[java] at java.security.AccessController.doPrivileged(Native
Method)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
[java] at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:170)
[java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:268)
[java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1274)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1042)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:485)
[java] at java.security.AccessController.doPrivileged(Native
Method)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
[java] at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:170)
[java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:268)
[java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1274)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1042)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:485)
[java] at java.security.AccessController.doPrivileged(Native
Method)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455)
[java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:219)
[java] at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:122)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1274)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1042)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:485)
[java] at java.security.AccessController.doPrivileged(Native
Method)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
[java] at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:170)
[java] at
org.springframework.aop.framework.autoproxy.BeanFactoryAdvisorRetrievalHelper.findAdvisorBeans(BeanFactoryAdvisorRetrievalHelper.java:87)
[java] at
org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:98)
[java] at
org.springframework.aop.aspectj.autoproxy.AspectJAwareAdvisorAutoProxyCreator.shouldSkip(AspectJAwareAdvisorAutoProxyCreator.java:105)
[java] at
org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessBeforeInstantiation(AbstractAutoProxyCreator.java:244)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:828)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation(AbstractAutowireCapableBeanFactory.java:799)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:475)
[java] at java.security.AccessController.doPrivileged(Native
Method)
[java] at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
[java] at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
[java] at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:170)
[java] at
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:883)
[java] at
org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext.java:593)
[java] at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:351)
[java] at
org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:122)
[java] at
org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:66)
[java] at
org.jasig.portal.spring.PortalApplicationContextLocator.getApplicationContext(PortalApplicationContextLocator.java:100)
[java] at
org.jasig.portal.RDBMServices.getDataSource(RDBMServices.java:125)
[java] at
org.jasig.portal.RDBMServices.getConnection(RDBMServices.java:170)
[java] at
org.jasig.portal.RDBMServices.getConnection(RDBMServices.java:153)
[java] at
org.jasig.portal.tools.dbloader.DbLoader.process(DbLoader.java:149)
[java] at
org.jasig.portal.tools.dbloader.DbLoader.main(DbLoader.java:117)
[java] Caused by: java.sql.SQLException: ORA-01031: insufficient
privileges
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[java] at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
[java] at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
[java] at
oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3485)
[java] at
org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:130)
[java] at
org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:35)
[java] at
org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)
[java] ... 75 more
Eric Dalquist wrote:
> A quick google search wasn't much help. The closest thing I found was
> this:
> http://opensource.atlassian.com/projects/hibernate/browse/HBX-609 but
> I'm not sure I understand what the person is describing.
>
> Would you be able to have a DBA monitor what the portal is trying to
> do during initportal to see if they can capture the SQL that is
> causing the exception? The Hibernate based DAOs may require more
> privileges on the schema than previous versions of uPortal did but
> that is just speculation right now.
>
> -Eric
>
>
>
> Tuyhang Ly wrote:
>> Initially, I got some errors when running initportal against a schema
>> with some tables from 2.5.* version. Then I dropped all tables in
>> this schema, reran the initportal task and still getting this error.
>>
>> Tuy.
>>
>> Eric Dalquist wrote:
>>> Are you doing initportal against a clean database schema or do
>>> tables already exist in it?
>>>
>>> -Eric
>>>
>>>
>>>
>>> Tuyhang Ly wrote:
>>>> Hi,
>>>>
>>>> I'm trying out uPortal_3.0.0-M5 with Oracle DB and getting the
>>>> following error for the "ant db" task even with a clean DB to start
>>>> from:
>>>>
>>>> [java] ERROR [main] util.JDBCExceptionReporter Jan/16
>>>> 11:58:01.680 - ORA-01031: insufficient privileges
>>>>
>>>> [java] ERROR [main] hbm2ddl.SchemaUpdate Jan/16 11:58:01.696 -
>>>> could not complete schema update
>>>> [java] org.hibernate.exception.SQLGrammarException: could not
>>>> get table metadata: UP_PORTLET_PREF_VALUES
>>>> ...
>>>> Caused by: java.sql.SQLException: ORA-01031: insufficient
>>>> privileges
>>>>
>>>> I have configured rdbm.properties accordingly for Oracle, and there
>>>> were 38 tables created after this task, but none of the UP_PORTLET*
>>>> tables were there. Am I missing something?
>>>>
>>>> Thanks,
>>>> Tuy.
>>>> --
>>>> Tuyhang Ly
>>>> Application Developer
>>>> Enterprise Systems & Services, Rutgers University
>>>> 65 Davidson Road, Room 101 - Piscataway, NJ 08854
>>>> voice: (732) 445-7393 | fax: (732) 445-5493 | email: [EMAIL PROTECTED]
>>>>
>>>> --
>>>> You are currently subscribed to [email protected] as: [EMAIL
>>>> PROTECTED]
>>>> To unsubscribe, change settings or access archives, see
>>>> http://www.ja-sig.org/wiki/display/JSG/uportal-dev
>>
>> --
>> Tuyhang Ly
>> Application Developer
>> Enterprise Systems & Services, Rutgers University
>> 65 Davidson Road, Room 101 - Piscataway, NJ 08854
>> voice: (732) 445-7393 | fax: (732) 445-5493 | email: [EMAIL PROTECTED]
>>
>> --
>> You are currently subscribed to [email protected] as: [EMAIL
>> PROTECTED]
>> To unsubscribe, change settings or access archives, see
>> http://www.ja-sig.org/wiki/display/JSG/uportal-dev
--
Tuyhang Ly
Application Developer
Enterprise Systems & Services, Rutgers University
65 Davidson Road, Room 101 - Piscataway, NJ 08854
voice: (732) 445-7393 | fax: (732) 445-5493 | email: [EMAIL PROTECTED]
--
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
