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

Thu Feb 24 06:50:01 PST 2011

---------- Forwarded message ----------
From: Duffy Gillman <duffy at rsmart.com>
Date: Thu, Feb 24, 2011 at 7:48 AM
Subject: Re: Log File Attached
To: Farhan Akhlaq <farhan.akhlaq at live.com>

Hi again,

It looks like your database is not configured to use the UTF-8 character
set. This is the first error in the log:

---

2011-02-24 15:28:35,359 FATAL Thread-1
org.sakaiproject.content.impl.DbContentService - Check on Database
Failed
java.lang.Exception: UTF-8 Data was corrupted communicating with the
database, please check connectionstring and default table types
(Conversion)-128=>128=>-65
	at org.sakaiproject.content.impl.DbContentService.testUTF8Transport(DbContentService.java:3361)

---

This is probably preventing much of the core schema from being
created. UTF-8 is required to support internationalization of text
strings.

You can find information about setting up your database here:

https://confluence.sakaiproject.org/display/DOC/Sakai+2.7

Under the heading "7.0 Database Support in Sakai" there is a query you
can run to check if your Oracle database is correctly configured.

Regards,

   Duffy Gillman

On Thu, Feb 24, 2011 at 6:41 AM, Farhan Akhlaq <farhan.akhlaq at live.com>wrote:

>  Forget the Attachment. Here it is :)
>
> Regards,
>
> Farhan Akhlaq
> Software Engineer
> Techlogix Company (Pvt) Limited.
> farhanakhlaq at techlogix.com
>
>
> ------------------------------
> From: farhan.akhlaq at live.com
> To: duffy at rsmart.com
> Subject: RE: [Building Sakai] Sakai 2.7.0 src Fresh Installation : Not
> Creating Complete DB Schema
> Date: Thu, 24 Feb 2011 18:39:19 +0500
>
> Hi Duffy,
>
> Firstly thanks a lot for replying to my message. I had attached the Log
> file with my message but unfortunately its link is broken. I am attaching
> the log file with this email. What i understand from this log is that the
> two tables CMN_TYPE_T and METAOBJ_FORM_DEF are not created and that's why
> Sakai is not been able to execute the related SQL queries. But these two
> tables are present in the schema. That's why I'm in a fix, what to do next.
>
> Secondly is there any kind of information available regarding the Sakai
> 2.7.0 source Fresh installed schema like No. of tables, Default data present
> in tables like in realm etc?
>
>
> Regards,
>
> Farhan Akhlaq
> Software Engineer
> Techlogix Company (Pvt) Limited.
> farhanakhlaq at techlogix.com
>
>
>
>
>
> ------------------------------
> Date: Thu, 24 Feb 2011 05:53:56 -0700
> Subject: Re: [Building Sakai] Sakai 2.7.0 src Fresh Installation : Not
> Creating Complete DB Schema
> From: duffy at rsmart.com
> To: farhan.akhlaq at live.com
>
> Hi Farhan,
>
>    From your description it seems that an exception was thrown before Sakai
> could complete schema creation. The key is where you say the "log shows
> destroying beans". This happens when Spring is unable to configure a
> resource during startup. If you look earlier in the log you should find some
> error log entry which describes what bean Spring was trying to configure
> when the exception occurred. That will be the key to figuring out what is
> wrong.
>
> Cheers,
>
>    Duffy Gillman
>    Sr. Software Engineer
>    The rSmart Group, Inc.
>
> On Thu, Feb 24, 2011 at 5:29 AM, Farhan <farhan.akhlaq at live.com> wrote:
>
>
> 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.
> _______________________________________________
> 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"
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110224/8bbc0b58/attachment.html 