[Building Sakai] Tomcat does not start correctly

David Horwitz david.horwitz at uct.ac.za
Wed Nov 3 06:53:53 PDT 2010


Ok, This is the error:

org.hibernate.exception.SQLGrammarException: could not get table
metadata: SAM_PUBLISHEDANSWER_T

So there could be a couple of problems:

1) Your tomcat can't talk to the database
2) you have autoddl set to false so sakai can't create the tables it needs


David

On 11/03/2010 03:42 PM, le tan vu wrote:
> Hi David,
> I've attached my log file. There might be something wrong from line
> 579 in log file but I'm not able to understand the reason.
>
> Please take a look at it.
>
> Any help from all of you would be appreciated.
>
> Many thanks and regards,
>
> @Matthew: Thanks a lot for your support.
>
> On Tue, Nov 2, 2010 at 11:55 PM, Matthew Jones <jonespm at umich.edu
> <mailto:jonespm at umich.edu>> wrote:
>
>     You can get windows to write to log files, you just have to setup
>     a custom log4j.properties file.
>
>     See the bottom of this document "Additional Information" for a
>     sample file to place in "common/classes/log4j.properties"
>     https://docs.google.com/document/pub?id=1P6pYBlq6kfaHMZ4sgZp57Yl1i5Ixd5c57QphBg5tr6Y
>
>     This is probably also documented on confluence somewhere? I have
>     to add this every testing iteration.
>
>     -Matthew
>
>     On Tue, Nov 2, 2010 at 12:46 PM, le tan vu <imleeu at gmail.com
>     <mailto:imleeu at gmail.com>> wrote:
>
>         Hi David,
>
>         Thanks for your response. But my current system is
>
>
>         Windows XP SP2
>         Tomcat 5.5.26
>         Sakai 2.7.1
>
>         So I have no catalina.out file due to Windows environment. (as
>         I know, Tomcat can't write log file on Windows)
>
>         What can I do to give you more information?
>
>         Actually, I don't understand what's wrong with a new tomcat
>         and sakai (using HSQL database).
>
>         I've deployed Sakai successfully many times before.
>
>         Thanks and regards,
>         --
>         Vu Tan Le
>
>
>         >Hi Vu,
>         >
>         >We will need to see the bit before this to be of any help.
>         Maybe attach
>         >your cataliant.out to the mail.
>         >
>         >Regards
>         >
>         >David
>         >
>         On 11/01/2010 04:20 PM, le tan vu wrote:
>         > Hi all,
>         > My tomcat suddenly didn't start correctly yesterday. The
>         days before
>         > are fine. I've tried to set up a new tomcat and build a new
>         sakai but
>         > there is no result.
>         > This is the error in tomcat window, this is just the last
>         part of very
>         > long message on tomcat window.
>         >
>         > /arch.api.SearchService.
>         parallel.index.sharedFilesystemSaveTransactionListener,or
>         >
>         g.sakaiproject.search.api.SearchService.parallel.index.optimizeSharedTransaction
>         >
>         Listener,org.sakaiproject.search.api.SearchService.parallel.index.sharedOptimize
>         >
>         Sequence,org.sakaiproject.search.mbeans.SearchServiceManagement,org.sakaiproject
>         >
>         .search.component.adapter.contenthosting.ContentHostingContentProducer,org.sakai
>         >
>         project.search.component.adapter.contenthosting.DefaultContentDigester,org.sakai
>         >
>         project.search.component.adapter.contenthosting.PDFContentDigester,org.sakaiproj
>         >
>         ect.search.component.adapter.contenthosting.HtmlContentDigester,org.sakaiproject
>         >
>         .search.component.adapter.contenthosting.PPTContentDigester,org.sakaiproject.sea
>         >
>         rch.component.adapter.contenthosting.XLContentDigester,org.sakaiproject.search.c
>         >
>         omponent.adapter.contenthosting.PoiContentDigester,org.sakaiproject.search.compo
>         >
>         nent.adapter.contenthosting.TikaContentDigester,siteAdapter,org.sakaiproject.sec
>         >
>         tion.api.SectionAwareness,org.sakaiproject.section.api.CourseManager,org.sakaipr
>         >
>         oject.section.api.SectionManager,org.sakaiproject.component.section.sakai.Sectio
>         >
>         nCmMetadataSynchronizer,SectionCmMetadataSynchronizerJob,org.sakaiproject.sitema
>         >
>         nage.api.SectionFieldProvider,org.sakaiproject.sitemanage.api.AffiliatedSectionP
>         >
>         rovider,org.sakaiproject.sitemanage.api.UserNotificationProvider,org.sakaiprojec
>         >
>         t.springframework.orm.hibernate.impl.AdditionalHibernateMappingsImpl.siteSetupQu
>         >
>         estion,org.sakaiproject.sitemanage.api.model.SiteSetupQuestionService,org.sakaip
>         >
>         roject.sitemanage.impl.SiteSetupQuestionServiceImpl,org.sakaiproject.springframe
>         >
>         work.orm.hibernate.impl.AdditionalHibernateMappingsImpl.syllabus,org.sakaiprojec
>         >
>         t.api.app.syllabus.SyllabusManager,org.sakaiproject.api.app.syllabus.SyllabusSer
>         >
>         vice,org.sakaiproject.springframework.orm.hibernate.impl.AdditionalHibernateMapp
>         >
>         ingsImpl.taggable,org.sakaiproject.taggable.api.TaggingManager,org.sakaiproject.
>         >
>         taggable.api.LinkManager,org.sakaiproject.umem.api.Authz,org.sakaiproject.wareho
>         >
>         use.service.DataWarehouseManager.dataSource,org.sakaiproject.warehouse.service.D
>         >
>         ataWarehouseManager,org.sakaiproject.warehouse.service.PropertyAccess.id
>         <http://org.sakaiproject.warehouse.service.propertyaccess.id/>
>         > <http://org.sakaiproject.warehouse.service.PropertyAccess.id
>         <http://org.sakaiproject.warehouse.service.propertyaccess.id/>>,org.sak
>
>
>         >
>         aiproject.warehouse.service.PropertyAccess.parentId,org.sakaiproject.warehouse.s
>         >
>         ervice.PropertyAccess.owner,org.sakaiproject.warehouse.service.ChildWarehouseTas
>         >
>         k.structured.artifact.def,org.sakaiproject.warehouse.sakai.assignment.Assignment
>         >
>         WarehouseService,org.sakaiproject.warehouse.sakai.assignment.intf.PropertyAccess
>         >
>         .assignment_id,org.sakaiproject.warehouse.sakai.assignment.ChildWarehouseTask.as
>         <http://org.sakaiproject.warehouse.sakai.assignment.childwarehousetask.as/>
>         >
>         <http://org.sakaiproject.warehouse.sakai.assignment.ChildWarehouseTask.as
>         <http://org.sakaiproject.warehouse.sakai.assignment.childwarehousetask.as/>>
>
>
>         >
>         signment,org.sakaiproject.warehouse.sakai.assignment.WarehouseTask.assignmentSta
>         >
>         tus,org.sakaiproject.warehouse.service.ChildWarehouseTask.repository.lock,org.sa
>         <http://org.sa/>
>         > <http://org.sa <http://org.sa/>>
>
>         >
>         kaiproject.warehouse.service.ChildWarehouseTask.contentResources,org.sakaiprojec
>         >
>         t.warehouse.service.ChildWarehouseTask.contentResourceCollection,org.sakaiprojec
>         >
>         t.warehouse.service.WarehouseTask.contentResources,org.sakaiproject.warehouse.se
>         <http://org.sakaiproject.warehouse.se/>
>         > <http://org.sakaiproject.warehouse.se
>         <http://org.sakaiproject.warehouse.se/>>
>
>         >
>         rvice.WarehouseTask.contentResourceCollection,org.sakaiproject.warehouse.service
>         >
>         .ChildWarehouseTask.worksite.membership,org.sakaiproject.warehouse.service.Child
>         >
>         WarehouseTask.worksite,org.sakaiproject.warehouse.service.ChildWarehouseTask.ses
>         >
>         sion,org.sakaiproject.warehouse.service.ChildWarehouseTask.user,org.sakaiproject
>         >
>         .warehouse.service.WarehouseTask.worksite,org.sakaiproject.warehouse.service.War
>         >
>         ehouseTask.session,org.sakaiproject.api.app.scheduler.JobBeanWrapper.sakaiDataWa
>         >
>         rehouse,org.sakaiproject.warehouse.service.WarehouseTask.user,org.sakaiproject.w
>         >
>         eb.api.WebService,org.sakaiproject.component.DefaultSakaiProperties,org.sakaipro
>         >
>         ject.component.SakaiPropertyPromoter,org.sakaiproject.component.SakaiProperties]
>         > ; root of factory hierarchy
>         > 2010-11-01 20:55:42,109  INFO main
>         > org.sakaiproject.db.impl.BasicSqlService - de
>         > stroy()
>         > 2010-11-01 20:55:42,156  INFO main
>         > org.sakaiproject.log.impl.Log4jConfigurationM
>         > anager - destroy()
>         > 2010-11-01 20:55:42,156  INFO main
>         > org.sakaiproject.component.impl.BasicConfigur
>         > ationService - destroy()/
>         >
>         > Please tell me how to solve if anyone faced the same
>         problem. And what
>         > is the reason?
>         >
>         > My current system is:
>         > *Windows XP SP2
>         > Tomcat 5.5.26
>         > Sakai 2.7.1*
>         >
>         >
>         > Thanks and best regards,
>         > --
>         > Vu Tan Le
>         >
>         >
>
>
>
>         _______________________________________________
>         sakai-dev mailing list
>         sakai-dev at collab.sakaiproject.org
>         <mailto: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
>         <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>         subject of "unsubscribe"
>
>
>
>
>
> -- 
> Vu Tan Le
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101103/f13ee187/attachment.html 


More information about the sakai-dev mailing list