nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Changed repository to MySQL & didn't work

ricter

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?

Find more posts tagged with

Comments

mikeh

Change this

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

to this

hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect‍

Mike

ricter

🙂
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?

mikeh

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

ricter

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&nbsp; 2 root root 4096 oct&nbsp; 8 10:19 org.hibernate.dialect.Dialect
drwxr-xr-x&nbsp; 2 root root 4096 oct&nbsp; 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&nbsp; 2 root root 4096 oct&nbsp; 8 10:19 org.hibernate.dialect.DerbyDialect
drwxr-xr-x&nbsp; 2 root root 4096 oct&nbsp; 8 10:19 org.hibernate.dialect.Dialect
drwxr-xr-x&nbsp; 2 root root 4096 oct&nbsp; 8 10:19 org.hibernate.dialect.Oracle9Dialect
drwxr-xr-x&nbsp; 2 root root 4096 oct&nbsp; 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:
&nbsp; 1. Browse to the tomcat\shared\classes\alfresco\extension\ directory.
&nbsp; 2. Locate and open the following two files:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a. custom-hibernate-dialect.properties
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b. custom-repository.properties
&nbsp; 3. For both files:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a. Use “#” to comment out any lines that refer to HSQL.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b. Remove the “#” from the beginning of each line for references to MySQL.
&nbsp; 4. In the custom-repository.properties, locate the following line:
&nbsp;&nbsp;&nbsp;&nbsp; dir.root=…
&nbsp; 5. Edit the line to point to the directory in which you want to store Alfresco data. For example:
&nbsp;&nbsp;&nbsp;&nbsp; dir.root=c:\alfresco\alf_data
&nbsp;&nbsp;&nbsp;&nbsp; Note: You can either save the file in its current location in the <extension> directory, or
&nbsp;&nbsp;&nbsp;&nbsp; in another directory. If you save the file in the <extension> directory, no further action is
&nbsp;&nbsp;&nbsp;&nbsp; needed because the file is already pointed to by the repository-properties bean in the
&nbsp;&nbsp;&nbsp;&nbsp; <extension>/custom-repository-context.xml file.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks again

ricter

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