Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Changed repository to MySQL & didn't work

ricter
Champ in-the-making
Champ in-the-making

‎10-09-2008 08:15 AM

I've installed succesfully (at least this is what I think) Alfresco on a Centos 4. Changed the default port to 8081 and after a few problems got it working. Then I wanted to change Derby to MySQL and followed the instructions that I found:
Locate the distribution's extension configuration files and samples (here) and remove the .sample extensions:

    * <extensionRoot>/alfresco/extension/custom-repository-context.xml.sample
          o This ensures that the properties overrides from the files below are pulled into the server. 
    * <extensionRoot>/alfresco/extension/custom-repository.properties.sample
          o Choose a root location for the storage of content binaries and index files.
          o Adjust properties here to change the database connection details.
          o Pay attention to the choice of JDBC driver used with each connection type. 
    * <extensionRoot>/alfresco/extension/custom-hibernate-dialect.properties.sample
          o Choose a Hibernate schema most appropriate to your database (Hibernate Dialects). 
‍‍‍‍‍‍‍‍‍‍‍
And when I start Alfresco again I got this in the alfresco.log

16:08:04,336 INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]                                                                                                                                
16:08:09,643 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed                                                  
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                                
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                                
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml    
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                 
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)                                             
        at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)                                            
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)                             
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)                            
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)                                                                                                                                             
        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.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.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.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                    
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)     
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)                            
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                      
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                        
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                                
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                      
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                              
        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.deployWAR(HostConfig.java:825)                                                                  
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                                 
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                                 
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                     
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)                                                             
        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:597)                                                                                       
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)                                                                        
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)                                                                         
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                   
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)                                                                       
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)                                             
        … 57 more                                                                                                                               
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                      
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)                                                             
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)                                                                     
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)                                                                    
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)                                                                       
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)                                                                       
        … 58 more                                                                                                                               
Caused by: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                    
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)                                                          
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)                                                           
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)                                        
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)                                                             
        … 62 more                                                                                                                               
16:08:09,665 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excepción enviando evento inicializado de contexto a instancia de escuchador de clase org.springframework.web.context.ContextLoaderListener                                                          
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                                
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                                
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml    
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                 
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)                                             
        at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)                                            
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)                             
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)                            
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)                                                                                                                                             
        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.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.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.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                    
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)     
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)                            
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                      
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                        
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                                
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                      
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                              
        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.deployWAR(HostConfig.java:825)                                                                  
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                                 
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                                 
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                     
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)                                                             
        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:597)                                                                                       
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)                                                                        
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)                                                                         
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                   
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)                                                                       
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)                                             
        … 57 more                                                                                                                               
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                      
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)                                                             
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)                                                                     
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)                                                                    
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)                                                                       
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)                                                                       
        … 58 more                                                                                                                               
Caused by: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                    
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)                                                          
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)                                                           
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)                                        
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)                                                             
        … 62 more                                                                                                                               
16:08:09,668 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excepción enviando evento inicializado de contexto a instancia de escuchador de clase org.alfresco.web.app.ContextListener                                                                           
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activityService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'postDaoService' while setting bean property 'postDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                                
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'postDaoService' defined in class path resource [alfresco/activities/activities-feed-context.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                                
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in file [/usr/local/alfresco/tomcat/shared/classes/alfresco/extension/custom-activities-feed-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml    
Caused by: java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml                                                                                                                                 
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:109)                                             
        at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)                                            
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)                             
        at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)                            
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)                                                                                                                                             
        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.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.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.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)                                    
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)     
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)                            
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                      
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                        
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                                
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                      
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                              
        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.deployWAR(HostConfig.java:825)                                                                  
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                                 
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                                 
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                     
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        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:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:62)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)
        … 57 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:123)
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:84)
        at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
        at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:60)
        … 58 more
Caused by: java.io.IOException: Could not find resource alfresco/activities/hibernate.dialect/ActivityPost.xml
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:108)
        at com.ibatis.common.resources.Resources.getResourceAsStream(Resources.java:93)
        at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.process(SqlMapConfigParser.java:383)
        at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)
        … 62 more
16:08:15,867 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
If I connect to MySQL I got this
mysql -u alfresco -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 463
Server version: 5.0.66a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use alfresco
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+——————–+
| Tables_in_alfresco |
+——————–+
| JBPM_ACTION        |
| JBPM_BYTEARRAY     |
| alf_bootstrap_lock |
+——————–+
3 rows in set (0.00 sec)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
I've typed:
ll alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml
-rw-r–r–  1 root root 4209 sep  9 15:55 alfresco/activities/org.hibernate.dialect.MySQLInnoDBDialect/ActivityPost.xml
‍‍‍
And got this in custom-hibernate-dialect.properties 


#
# MySQL dialect (default)
#
mysql#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

‍‍‍‍‍‍‍‍
What could it be the reason for this?
Labels:
0 Kudos
5 REPLIES 5

mikeh
Star Contributor
Star Contributor

‎10-09-2008 09:40 AM

Change this 
mysql#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect‍

to this 
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect‍


Mike
0 Kudos

ricter
Champ in-the-making
Champ in-the-making

‎10-09-2008 11:48 AM

🙂
All right. It worked. Thanks, but now I've got

INFO  [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]                                                                                                                          
19:23:47,095 ERROR [org.alfresco.repo.content.transform.swf.PDFToSWFContentTransformer] Failed to start SWF2PDF transformer:                   
Execution result:                                                                                                                              
   os:         Linux                                                                                                                           
   command:    pdf2swf -V                                                                                                                      
   succeeded:  false                                                                                                                           
   exit code:  1                                                                                                                               
   out:                                                                                                                                        
   err:        Cannot run program "pdf2swf": java.io.IOException: error=2, No such file or directory                                           
19:23:54,440 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Esquema gestionado por el gestor de base de datos org.hibernate.dialect.MySQLInnoDBDialect.                                                                                                                              
19:25:55,813 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Actualización automática de esquema fallida                               
org.alfresco.error.AlfrescoRuntimeException: Una actualización previa de esquema falló. Revertir a la base de datos original antes de intentar de nuevo la actualización.                                                                                                                     
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1019)                                              
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)                                           
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)                
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)                                                    
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)       
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)                    
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)                         
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                   
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                     
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                             
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                   
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                           
        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.deployWAR(HostConfig.java:825)                                                               
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                              
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                              
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                  
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)                                                          
        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:597)                                                                                    
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)                                                                     
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)                                                                      
19:25:55,816 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed                                               
org.alfresco.error.AlfrescoRuntimeException: Actualización automática de esquema fallida                                                       
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1075)                                              
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)                                           
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)                
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)                                                    
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)       
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)                    
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)                         
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                   
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                     
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                             
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                   
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                           
        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.deployWAR(HostConfig.java:825)                                                               
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                              
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                              
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                  
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)                                                          
        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:597)                                                                                    
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)                                                                     
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)                                                                      
Caused by: org.alfresco.error.AlfrescoRuntimeException: Una actualización previa de esquema falló. Revertir a la base de datos original antes de intentar de nuevo la actualización.                                                                                                          
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1019)                                              
        … 33 more                                                                                                                            
19:25:55,819 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excepción enviando evento inicializado de contexto a instancia de escuchador de clase org.springframework.web.context.ContextLoaderListener                                                    
org.alfresco.error.AlfrescoRuntimeException: Actualización automática de esquema fallida                                                       
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1075)                                              
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)                                           
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)                
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)                                                    
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)       
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)                    
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)                         
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)                                   
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)                                     
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)                             
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)                                                   
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)                                                           
        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.deployWAR(HostConfig.java:825)                                                               
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)                                                              
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)                                                              
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)                                                                  
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)                                                          
        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:597)                                                                                    
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)                                                                     
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)                                                                      
Caused by: org.alfresco.error.AlfrescoRuntimeException: Una actualización previa de esquema falló. Revertir a la base de datos original antes de intentar de nuevo la actualización.                                                                                                          
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1019)                                              
        … 33 more                                                                                                                            
19:25:55,823 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Excepción enviando evento inicializado de contexto a instancia de escuchador de clase org.alfresco.web.app.ContextListener                                                                     
org.alfresco.error.AlfrescoRuntimeException: Actualización automática de esquema fallida                                                       
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1075)                                              
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)                                           
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)                
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
        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.deployWAR(HostConfig.java:825)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        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:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.alfresco.error.AlfrescoRuntimeException: Una actualización previa de esquema falló. Revertir a la base de datos original antes de intentar de nuevo la actualización.
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1019)
        … 33 more
19:26:03,667 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
I'm sorry but I'm lost again
could you help me again?
0 Kudos

mikeh
Star Contributor
Star Contributor

‎10-09-2008 02:44 PM

If you've not got any useful data in the repo, by far the easiest solution is to shutdown Tomcat, clear alf_data and the database and restart.

Mike
0 Kudos

ricter
Champ in-the-making
Champ in-the-making

‎10-09-2008 03:33 PM

I've renamed the directory alf_data and got the same result when I start alfresco.

I've noticed that in 

tomcat/webapps/alfresco/WEB-INF/classes/alfresco/dbscripts/create/3.0 ‍

there is no 
org.hibernate.dialect.MySQLInnoDBDialect‍
as it is in …/create/2.2
take a look at this
ll tomcat/webapps/alfresco/WEB-INF/classes/alfresco/dbscripts/create/2.2
total 8
drwxr-xr-x  2 root root 4096 oct  8 10:19 org.hibernate.dialect.Dialect
drwxr-xr-x  2 root root 4096 oct  8 10:19 org.hibernate.dialect.MySQLInnoDBDialect
‍‍‍‍‍
and now
ll tomcat/webapps/alfresco/WEB-INF/classes/alfresco/dbscripts/create/3.0
total 16
drwxr-xr-x  2 root root 4096 oct  8 10:19 org.hibernate.dialect.DerbyDialect
drwxr-xr-x  2 root root 4096 oct  8 10:19 org.hibernate.dialect.Dialect
drwxr-xr-x  2 root root 4096 oct  8 10:19 org.hibernate.dialect.Oracle9Dialect
drwxr-xr-x  2 root root 4096 oct  8 10:19 org.hibernate.dialect.PostgreSQLDialect
‍‍‍‍‍‍‍

Does it have something to do with my problem?

I've tried to change to MySQL in a fresh new install and got the same problem.

To change to MySQL I've followed this instructions
To configure MySQL:
  1. Browse to the tomcat\shared\classes\alfresco\extension\ directory.
  2. Locate and open the following two files:
        a. custom-hibernate-dialect.properties
        b. custom-repository.properties
  3. For both files:
        a. Use “#” to comment out any lines that refer to HSQL.
        b. Remove the “#” from the beginning of each line for references to MySQL.
  4. In the custom-repository.properties, locate the following line:
     dir.root=…
  5. Edit the line to point to the directory in which you want to store Alfresco data. For example:
     dir.root=c:\alfresco\alf_data
     Note: You can either save the file in its current location in the <extension> directory, or
     in another directory. If you save the file in the <extension> directory, no further action is
     needed because the file is already pointed to by the repository-properties bean in the
     <extension>/custom-repository-context.xml file.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks again  Smiley Sad
0 Kudos

ricter
Champ in-the-making
Champ in-the-making

‎10-09-2008 07:38 PM

Solved.

I made a mistake.  :?
I was deleting the data on the directory but didn't clean the database.
When I did exactly what you told me it worked perfectly.

Thanks
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2024 Khoros, LLC