[Building Sakai] Problem converting resources from DB to filesystem
Manesiya,Rustamali R
rmanesiy at mdanderson.org
Wed May 19 06:45:41 PDT 2010
Hello,
We are using Sakai 2.6.0 (Kernel 1.0.11). Created local.properties under C:\Tomcat5.5\sakai with following content (we want to discontinue storing file uploads in database and instead use file system).
local.properties content
convertToFile at org.sakaiproject.content.api.ContentHostingService = true
bodyPath at org.sakaiproject.content.api.ContentHostingService = C:\\TEMP\\sakaicontent\\
#bodyVolumes at org.sakaiproject.content.api.ContentHostingService = vol1,vol2,vol3,vol4,vol5
I start the tomcat server and receive this error (The error is at the bottom of this email). DbContentService class converts only three files and fails on the fourth file and none of the resources from CONTENT_RESOURCES are exported to file system. Can anyone help me here to successfully export all the contents that are stored in blob to files system?
These files are created on the file system
/group/PortfolioAdmin/system/formView.xslt
/group/PortfolioAdmin/system/formFieldTemplate.xslt
/group/PortfolioAdmin/system/formCreate.xslt
Fails on this one
/group/PortfolioAdmin/system/freeFormRenderer.xml
Error log
2010-05-19 08:28:02,419 WARN main org.sakaiproject.content.impl.DbContentService - convertToFile(): null xml :
2010-05-19 08:28:02,419 WARN main org.sakaiproject.content.impl.DbContentService - convertToFile(): null xml :
2010-05-19 08:28:02,419 WARN main org.sakaiproject.content.impl.DbContentService - convertToFile(): null xml :
2010-05-19 08:28:02,419 WARN main org.sakaiproject.content.impl.DbContentService - convertToFile(): null xml :
2010-05-19 08:28:02,435 INFO main org.sakaiproject.content.impl.DbContentService - convertToFile: converted resources: 0
2010-05-19 08:28:02,435 INFO main org.sakaiproject.content.impl.DbContentService - convertToFile: done
2010-05-19 08:28:02,435 INFO main org.sakaiproject.content.impl.DbContentService - init(): tables: CONTENT_COLLECTION CONTENT_RESOURCE CONTENT_RESOURCE_BODY_BINARY CONTENT_ENTITY_GROUPS locks-in-db: false bodyPath: C:\TEMP\sakaicontent\ storage: org.sakaiproject.content.impl.DbContentService$DbStorage at 1bb9805
2010-05-19 08:28:02,435 INFO main org.sakaiproject.component.app.messageforums.MessageForumsMessageManagerImpl - init()
2010-05-19 08:28:02,482 INFO main org.sakaiproject.component.app.messageforums.DefaultPermissionsManagerImpl - init()
2010-05-19 08:28:02,482 INFO main org.sakaiproject.component.app.messageforums.PermissionManagerImpl - init()
2010-05-19 08:28:02,529 INFO main org.sakaiproject.component.app.messageforums.MembershipManagerImpl - init()
2010-05-19 08:28:02,591 INFO main org.sakaiproject.component.app.messageforums.PermissionLevelManagerImpl - init()
Hibernate: select permission0_.ID as ID101_, permission0_.VERSION as VERSION101_, permission0_.UUID as UUID101_, permission0_.CREATED as CREATED101_, permission0_.CREATED_BY as CREATED5_101_, permission0_.MODIFIED as MODIFIED101_, permission0_.MODIFIED_BY as MODIFIED7_101_, permission0_.NAME as NAME101_, permission0_.TYPE_UUID as TYPE9_101_, permission0_.CHANGE_SETTINGS as CHANGE10_101_, permission0_.DELETE_ANY as DELETE11_101_, permission0_.DELETE_OWN as DELETE12_101_, permission0_.MARK_AS_READ as MARK13_101_, permission0_.MOVE_POSTING as MOVE14_101_, permission0_.NEW_FORUM as NEW15_101_, permission0_.NEW_RESPONSE as NEW16_101_, permission0_.NEW_RESPONSE_TO_RESPONSE as NEW17_101_, permission0_.NEW_TOPIC as NEW18_101_, permission0_.POST_TO_GRADEBOOK as POST19_101_, permission0_.X_READ as X20_101_, permission0_.REVISE_ANY as REVISE21_101_, permission0_.REVISE_OWN as REVISE22_101_, permission0_.MODERATE_POSTINGS as MODERATE23_101_ from MFR_PERMISSION_LEVEL_T permission0_ where permission0_.TYPE_UUID=?
2010-05-19 08:28:02,685 INFO main org.sakaiproject.component.app.messageforums.ui.DiscussionForumManagerImpl - init()
2010-05-19 08:28:02,732 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.component.app.messageforums.entity.ForumTopicEntityProviderImpl) prefix (forum_topic) with 5 capabilities
2010-05-19 08:28:02,748 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.component.app.messageforums.entity.ForumEntityProviderImpl) prefix (forum) with 5 capabilities
2010-05-19 08:28:02,826 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.component.app.messageforums.entity.ForumMessageEntityProviderImpl) prefix (forum_message) with 5 capabilities
2010-05-19 08:28:02,904 INFO main org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderManagerImpl - EntityBroker: Registered entity provider (org.sakaiproject.tool.assessment.entity.impl.PublishedAssessmentEntityProviderImpl) prefix (sam_pub) with 6 capabilities
2010-05-19 08:28:02,904 INFO main org.sakaiproject.entitybroker.util.spring.EntityProviderAutoRegistrar - AutoRegistered EntityProvider prefixes : forum_topic : forum : forum_message : sam_pub
2010-05-19 08:28:02,904 INFO main org.sakaiproject.entitybroker.util.spring.EntityProviderAutoRegistrar - init
2010-05-19 08:28:03,060 INFO main org.theospi.portfolio.worksite.mgt.impl.WorksiteListGenerator - init()
2010-05-19 08:28:03,216 INFO main org.theospi.portfolio.guidance.impl.GuidanceEntityProducer - init()
2010-05-19 08:28:03,248 INFO main org.theospi.portfolio.style.impl.StyleManagerImpl - init()
2010-05-19 08:28:03,373 INFO main org.theospi.portfolio.security.model.DefaultRealmManagerImpl - init()
2010-05-19 08:28:03,482 INFO main org.theospi.portfolio.security.model.DefaultRealmManagerImpl - init()
2010-05-19 08:28:03,513 INFO main org.theospi.portfolio.security.model.DefaultRealmManagerImpl - init()
2010-05-19 08:28:03,560 INFO main org.theospi.portfolio.security.model.SakaiDefaultPermsManager - init()
2010-05-19 08:28:04,326 INFO main org.theospi.portfolio.help.model.DbGlossary - init()
Hibernate: select glossaryen0_.id as id25_, glossaryen0_.worksite_id as worksite2_25_, glossaryen0_.term as term25_, glossaryen0_.description as descript4_25_ from osp_help_glossary glossaryen0_ order by glossaryen0_.term
2010-05-19 08:28:04,388 INFO main org.theospi.portfolio.help.impl.GlossaryEntityProducer - init()
2010-05-19 08:28:04,576 INFO main org.sakaiproject.metaobj.shared.mgt.impl.StructuredArtifactDefinitionManagerImpl - init()
Hibernate: select structured0_.id as id102_, structured0_.description as descript2_102_, structured0_.documentRoot as document3_102_, structured0_.owner as owner102_, structured0_.created as created102_, structured0_.modified as modified102_, structured0_.systemOnly as systemOnly102_, structured0_.externalType as external8_102_, structured0_.siteId as siteId102_, structured0_.siteState as siteState102_, structured0_.globalState as globalS11_102_, structured0_.schemaData as schemaData102_, structured0_.instruction as instruc13_102_, structured0_.schema_hash as schema14_102_, structured0_.alternateCreateXslt as alterna15_102_, structured0_.alternateViewXslt as alterna16_102_ from metaobj_form_def structured0_ where structured0_.schema_hash is null
2010-05-19 08:28:04,576 INFO main org.sakaiproject.metaobj.shared.mgt.impl.StructuredArtifactDefinitionManagerImpl - Updating base Metaobj XSLT files (auto.ddl is on).
Hibernate: select lock0_.id as id89_, lock0_.asset_id as asset2_89_, lock0_.qualifier_id as qualifier3_89_, lock0_.is_active as is4_89_, lock0_.is_system as is5_89_, lock0_.reason as reason89_, lock0_.date_added as date7_89_, lock0_.date_removed as date8_89_ from content_resource_lock lock0_ where is_active=1 and asset_id=?
Hibernate: select lock0_.id as id89_, lock0_.asset_id as asset2_89_, lock0_.qualifier_id as qualifier3_89_, lock0_.is_active as is4_89_, lock0_.is_system as is5_89_, lock0_.reason as reason89_, lock0_.date_added as date7_89_, lock0_.date_removed as date8_89_ from content_resource_lock lock0_ where is_active=1 and asset_id=?
Hibernate: select lock0_.id as id89_, lock0_.asset_id as asset2_89_, lock0_.qualifier_id as qualifier3_89_, lock0_.is_active as is4_89_, lock0_.is_system as is5_89_, lock0_.reason as reason89_, lock0_.date_added as date7_89_, lock0_.date_removed as date8_89_ from content_resource_lock lock0_ where is_active=1 and asset_id=?
Hibernate: select lock0_.id as id89_, lock0_.asset_id as asset2_89_, lock0_.qualifier_id as qualifier3_89_, lock0_.is_active as is4_89_, lock0_.is_system as is5_89_, lock0_.reason as reason89_, lock0_.date_added as date7_89_, lock0_.date_removed as date8_89_ from content_resource_lock lock0_ where is_active=1 and asset_id=?
Hibernate: select lock0_.id as id89_, lock0_.asset_id as asset2_89_, lock0_.qualifier_id as qualifier3_89_, lock0_.is_active as is4_89_, lock0_.is_system as is5_89_, lock0_.reason as reason89_, lock0_.date_added as date7_89_, lock0_.date_removed as date8_89_ from content_resource_lock lock0_ where is_active=1 and asset_id=?
Hibernate: select lock0_.id as id89_, lock0_.asset_id as asset2_89_, lock0_.qualifier_id as qualifier3_89_, lock0_.is_active as is4_89_, lock0_.is_system as is5_89_, lock0_.reason as reason89_, lock0_.date_added as date7_89_, lock0_.date_removed as date8_89_ from content_resource_lock lock0_ where is_active=1 and asset_id=?
Hibernate: select structured0_.id as id102_, structured0_.description as descript2_102_, structured0_.documentRoot as document3_102_, structured0_.owner as owner102_, structured0_.created as created102_, structured0_.modified as modified102_, structured0_.systemOnly as systemOnly102_, structured0_.externalType as external8_102_, structured0_.siteId as siteId102_, structured0_.siteState as siteState102_, structured0_.globalState as globalS11_102_, structured0_.schemaData as schemaData102_, structured0_.instruction as instruc13_102_, structured0_.schema_hash as schema14_102_, structured0_.alternateCreateXslt as alterna15_102_, structured0_.alternateViewXslt as alterna16_102_ from metaobj_form_def structured0_
2010-05-19 08:28:18,090 INFO main org.theospi.portfolio.presentation.model.impl.PresentationManagerImpl - init()
Hibernate: select presentati0_.id as id33_0_, presentati0_.name as name33_0_, presentati0_.description as descript3_33_0_, presentati0_.includeHeaderAndFooter as includeH4_33_0_, presentati0_.published as published33_0_, presentati0_.owner_id as owner6_33_0_, presentati0_.renderer as renderer33_0_, presentati0_.markup as markup33_0_, presentati0_.propertyPage as property9_33_0_, presentati0_.propertyFormType as propert10_33_0_, presentati0_.documentRoot as documen11_33_0_, presentati0_.created as created33_0_, presentati0_.modified as modified33_0_, presentati0_.site_id as site14_33_0_ from osp_presentation_template presentati0_ where presentati0_.id=?
Hibernate: select files0_.template_id as template5_1_, files0_.id as id1_, files0_.id as id36_0_, files0_.file_id as file2_36_0_, files0_.file_type_id as file3_36_0_, files0_.usage_desc as usage4_36_0_, files0_.template_id as template5_36_0_ from osp_template_file_ref files0_ where files0_.template_id=?
Hibernate: select items0_.template_id as template9_1_, items0_.id as id1_, items0_.id as id34_0_, items0_.name as name34_0_, items0_.title as title34_0_, items0_.description as descript4_34_0_, items0_.allowMultiple as allowMul5_34_0_, items0_.type as type34_0_, items0_.external_type as external7_34_0_, items0_.sequence_no as sequence8_34_0_, items0_.template_id as template9_34_0_ from osp_presentation_item_def items0_ where items0_.template_id=?
Hibernate: select mimetypes0_.item_def_id as item1_0_, mimetypes0_.primaryMimeType as primaryM2_0_, mimetypes0_.secondaryMimeType as secondar3_0_ from osp_pres_itemdef_mimetype mimetypes0_ where mimetypes0_.item_def_id=?
Hibernate: select lock0_.id as id89_, lock0_.asset_id as asset2_89_, lock0_.qualifier_id as qualifier3_89_, lock0_.is_active as is4_89_, lock0_.is_system as is5_89_, lock0_.reason as reason89_, lock0_.date_added as date7_89_, lock0_.date_removed as date8_89_ from content_resource_lock lock0_ where is_active=1 and qualifier_id=?
Hibernate: select lock0_.id as id89_, lock0_.asset_id as asset2_89_, lock0_.qualifier_id as qualifier3_89_, lock0_.is_active as is4_89_, lock0_.is_system as is5_89_, lock0_.reason as reason89_, lock0_.date_added as date7_89_, lock0_.date_removed as date8_89_ from content_resource_lock lock0_ where is_active=1 and asset_id=?
2010-05-19 08:28:18,169 WARN main org.theospi.portfolio.presentation.model.impl.PresentationManagerImpl - Temporarily catching all exceptions in osp.PresentationManagerImpl.init()
java.lang.RuntimeException: org.sakaiproject.exception.InUseException id=/group/PortfolioAdmin/system/freeFormRenderer.xml
at org.theospi.portfolio.presentation.model.impl.PresentationManagerImpl.updateResource(PresentationManagerImpl.java:2933)
at org.theospi.portfolio.presentation.model.impl.PresentationManagerImpl.initFreeFormTemplate(PresentationManagerImpl.java:2886)
at org.theospi.portfolio.presentation.model.impl.PresentationManagerImpl.init(PresentationManagerImpl.java:2757)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1240)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1205)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:281)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:131)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1099)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:861)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at org.sakaiproject.util.NoisierDefaultListableBeanFactory.getBean(NoisierDefaultListableBeanFactory.java:115)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons(NoisierDefaultListableBeanFactory.java:74)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at org.sakaiproject.component.impl.SpringCompMgr.init(SpringCompMgr.java:146)
at org.sakaiproject.component.cover.ComponentManager.getInstance(ComponentManager.java:68)
at org.sakaiproject.component.cover.ComponentManager.get(ComponentManager.java:80)
at org.sakaiproject.dav.DavServlet.init(DavServlet.java:501)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3996)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4266)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:634)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:561)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:496)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1203)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.sakaiproject.exception.InUseException id=/group/PortfolioAdmin/system/freeFormRenderer.xml
at org.sakaiproject.content.impl.BaseContentService.editResource(BaseContentService.java:4070)
at org.theospi.portfolio.presentation.model.impl.PresentationManagerImpl.updateResource(PresentationManagerImpl.java:2926)
... 80 more
Rusty
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100519/d38d0c36/attachment.html
More information about the sakai-dev
mailing list