[Building Sakai] Sakai 2.7.0 src Fresh Installation : Not Creating Complete DB Schema

Farhan farhan.akhlaq at live.com
Thu Feb 24 04:29:01 PST 2011


Hi All,
        I am trying to deploy a fresh installation of Sakai 2.7.0 source
version using the guide on following link
https://confluence.sakaiproject.org/display/DOC/Sakai+2.7. Sakai was
deployed successfully and it was working fine with the Demo Database HSQLDB.
Then i created the schema in Oracle 10g DB and setup the Sakai Properties
file accordingly for tables creation. When i started Tomcat it runs the
tables creation process but when i explore the DB it just created around 49
tables and  log shows destroying beans. When i see the log it was giving
errors like "Table or View Does Not Exists". I had done a previous
successful deployment from where i copied the corresponding Tables creation
scripts and run them on the current database. Scripts create the tables and
their indexes, keys etc successfully.  When i restarted the tomcat now with
turning "auto.ddl = false" it again logged some errors specially regarding
the 2 Tables "CMN_TYPE_T" and "METAOBJ_FORM_DEF" with tables or view not
created error (But i had created these tables using the scripts before). The
log is attached 
http://sakai-project-mail-list-archives.1343168.n2.nabble.com/file/n6060149/stdout_20110224.log
stdout_20110224.log .  
       My questions are 
       1) What are the reasons why Sakai wasn't able to create the schema
completely?
       2) What to do next if Sakai fails to create schema completely?
       3) Is there any resource available regarding Sakai 2.7.0 DB schema +
default Data in Tables?

Thankx a lot.

Regards,
Farhan Akhlaq  
      
-- 
View this message in context: http://sakai-project-mail-list-archives.1343168.n2.nabble.com/Sakai-2-7-0-src-Fresh-Installation-Not-Creating-Complete-DB-Schema-tp6060149p6060149.html
Sent from the DG: Development / Buidling Sakai (sakai-dev at collab.sakaiproject.org) mailing list archive at Nabble.com.


More information about the sakai-dev mailing list