[Building Sakai] auto.ddl failed on Oracle DB for 2.9

[Jean-Francois Leveque]

Peter,

I think the first worrying log is:

2011-09-22 11:35:13,952  WARN Thread-2 
org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean 
- Unsuccessful schema statement: comment on table ASN_SUP_ATTACH_T is 
'This table is for assignment supplement item attachment.'
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Chris,

SVN trunk on Oracle 10g (trunk/sakai) tomcat log is not showing the 
errors Peter has. Is it still 10G or 11G already?

There is an error with dav.war deploying.

Cheers,

J-F

On 22/09/2011 18:16, Liu, Peter wrote:
> Please see the log error messages as attached file. Hope it will help.
>
> Thanks,
>
> Peter
>
> *From:*Maurer, Christopher Wayne [mailto:chmaurer at iupui.edu]
> *Sent:* Thursday, September 22, 2011 12:08 PM
> *To:* Liu, Peter; sakai-dev Dev
> *Subject:* Re: [Building Sakai] auto.ddl failed on Oracle DB for 2.9
>
> Peter,
>
> I don't suppose there's anything useful in the logs, is there?
>
> The nightly instance is having the DB upgraded to Oracle 11G this
> afternoon, so we'll know soon enough if there are other problems!
>
> Chris
>
> *From: *"Liu, Peter" <peter.liu at yale.edu <mailto:peter.liu at yale.edu>>
> *Date: *Thu, 22 Sep 2011 16:04:19 +0000
> *To: *sakai-dev Dev <sakai-dev at collab.sakaiproject.org
> <mailto:sakai-dev at collab.sakaiproject.org>>
> *Subject: *[Building Sakai] auto.ddl failed on Oracle DB for 2.9
>
> Hi all,
>
> I am trying to set up a Sakai 2.9 (trunk code) on Tomcat 7.x. I have
> problem with the auto.ddl on Oracle DB. Some tables are not
> automatically created such as tables for Chat2. It works perfect on
> Mysql DB.
>
> Is this a known issue on Oracle 11g on auto.ddl?
>
> Thanks a lot!
>
> Peter