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 privilegesI 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
smime.p7s
Description: S/MIME Cryptographic Signature
