[Building Sakai] Error during tomcat startup

[Chris Dunstall]

Something I always miss is the grant permission.  It¹s quite possible there
some sort of granting or synonym being created (not knowing exactly what DDL
is trying to do), but there could be something there.

Chris


On 10/03/09 3:29 PM, "Karen Tsao" <ktsao at stanford.edu> wrote:

> Hi,
> 
> Can someone please help me with my tomcat startup error? This is a trunk
> instance. I run it against a blank Oracle db (with aauto.ddl=true in
> sakai.properties). Following is the error:
> 
> Caused by: java.sql.SQLException: ORA-01031: insufficient privileges
>         at oracle.jdbc.driver.
> DatabaseError.throwSqlException(DatabaseError.java:112)
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>         at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
>         at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
>         at 
> oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
>         at 
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1
> 170)
>         at 
> oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:
> 1623)
>         at 
> oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
>         at 
> oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:34
> 86)
>         at 
> org.hibernate.tool.hbm2ddl.TableMetadata.initIndexes(TableMetadata.java:130)
>         at 
> org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:35)
>         at 
> org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.
> java:90)
>         ... 58 more
> 
> Does anyone know what privileges the error refers to? I have done some DDL and
> DML statements directly to that schema and they work fine though.
> 
> I'd appreciate any suggestions. Thanks.
> Karen
> 
> 
> 
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
> with a subject of "unsubscribe"
> 
> Chris Dunstall | Solutions Developer
> Enterprise Information Management Solutions (EIMS)
> Division of Information Technology | Charles Sturt University | Bathurst, NSW
> 
> Ph: 02 63384818 | Fax: 02 63384181
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090310/317680fd/attachment-0001.html