topic How to extract data from a 'old' alfresco in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-extract-data-from-a-old-alfresco/m-p/236853#M189983 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>I have a old alfresco 3.0 labs. I fallow this page </SPAN><A href="http://wiki.alfresco.com/wiki/Installing_Labs_3_Stable_on_Debian_Etch" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Installing_Labs_3_Stable_on_Debian_Etch</A><SPAN> to install my old alfresco on a Debian lenny.</SPAN><BR /><SPAN>My java version is: 1.6.0.20</SPAN><BR /><SPAN>My SWFtools: 2009-02-07-1827</SPAN><BR /><SPAN>It was working since few month. After a hard reboot of the computer my alfresco doesn't want to start again.</SPAN><BR /><SPAN>When I arrive on the web interface I have this:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>HTTP Status 404 -<BR /><BR />type Status report<BR /><BR />message<BR /><BR />description The requested resource () is not available.<BR />Apache Tomcat/6.0.18<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>When I try to stop it:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>Using CATALINA_BASE:&nbsp;&nbsp; /opt/Alfresco/tomcat<BR />Using CATALINA_HOME:&nbsp;&nbsp; /opt/Alfresco/tomcat<BR />Using CATALINA_TMPDIR: /opt/Alfresco/tomcat/temp<BR />Using JRE_HOME:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/lib/jvm/java-6-sun<BR />CompilerOracle: exclude org/apache/lucene/index/IndexReader$1.doBody<BR />CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeIndexes<BR />CompilerOracle: exclude org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger.mergeDeletions<BR />Using CATALINA_BASE:&nbsp;&nbsp; /opt/Alfresco/virtual-tomcat<BR />Using CATALINA_HOME:&nbsp;&nbsp; /opt/Alfresco/virtual-tomcat<BR />Using CATALINA_TMPDIR: /opt/Alfresco/virtual-tomcat/temp<BR />Using JRE_HOME:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/lib/jvm/java-6-sun<BR />Jul 5, 2010 6:52:47 PM org.apache.catalina.startup.Catalina stopServer<BR />SEVERE: Catalina.stop:<BR />java.net.ConnectException: Connection refused<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.socketConnect(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.connect(Socket.java:529)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.connect(Socket.java:478)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.&lt;init&gt;(Socket.java:375)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.net.Socket.&lt;init&gt;(Socket.java:189)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:395)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:344)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:435)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>The end of the catalina.out file:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>Jul 6, 2010 3:28:20 PM org.apache.coyote.http11.Http11Protocol init<BR />INFO: Initializing Coyote HTTP/1.1 on http-8080<BR />Jul 6, 2010 3:28:20 PM org.apache.catalina.startup.Catalina load<BR />INFO: Initialization processed in 613 ms<BR />Jul 6, 2010 3:28:21 PM org.apache.catalina.core.StandardService start<BR />INFO: Starting service Catalina<BR />Jul 6, 2010 3:28:21 PM org.apache.catalina.core.StandardEngine start<BR />INFO: Starting Servlet Engine: Apache Tomcat/6.0.18<BR />Jul 6, 2010 3:28:21 PM org.apache.catalina.startup.HostConfig deployWAR<BR />INFO: Deploying web application archive studio.war<BR />15:28:24,889&nbsp; INFO&nbsp; [web.scripts.DeclarativeRegistry] Registered 67 Web Scripts (+0 failed), 71 URLs<BR />15:28:24,892&nbsp; INFO&nbsp; [web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 436.41827ms)<BR />15:29:25,886&nbsp; INFO&nbsp; [web.scripts.DeclarativeRegistry] Registered 101 Web Scripts (+0 failed), 105 URLs<BR />15:29:25,889&nbsp; INFO&nbsp; [web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 60978.707ms)<BR />15:29:25,966&nbsp; INFO&nbsp; [web.site.FrameworkHelper] Successfully Initialized Web Framework<BR />Jul 6, 2010 3:29:26 PM org.apache.catalina.startup.HostConfig deployWAR<BR />INFO: Deploying web application archive alfresco.war<BR />Jul 6, 2010 3:29:27 PM org.apache.catalina.core.StandardContext addApplicationListener<BR />INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.<BR />15:29:46,433&nbsp; ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation:<BR />Execution result:<BR />&nbsp;&nbsp; os:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Linux<BR />&nbsp;&nbsp; command:&nbsp;&nbsp;&nbsp; [/usr/bin/convert, /opt/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_8989400873708964833.gif, /opt/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_2579676881669118765.png]<BR />&nbsp;&nbsp; succeeded:&nbsp; false<BR />&nbsp;&nbsp; exit code:&nbsp; 1<BR />&nbsp;&nbsp; out:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp; err:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cannot run program "/usr/bin/convert": java.io.IOException: error=12, Cannot allocate memory<BR />15:29:47,618&nbsp; WARN&nbsp; [jmx.support.JmxUtils] Found more than one MBeanServer instance. Returning first from list.<BR />15:29:49,328&nbsp; INFO&nbsp; [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]<BR />15:30:23,382&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] Detected first UserTransaction which is being garbage collected without a commit() or rollback()<BR />15:30:23,406&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] Logging of transaction call stack is now enabled and will affect performance<BR />15:30:23,406&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,407&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,407&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,407&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,407&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,407&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,408&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,408&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,408&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,408&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,408&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,409&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,409&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,409&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,409&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,410&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:23,411&nbsp; ERROR [transaction.SpringAwareUserTransaction.trace] UserTransaction being garbage collected without a commit() or rollback(). NOTE: Prior to transaction call stack logging.<BR />15:30:29,948&nbsp; ERROR [web.context.ContextLoader] Context initialization failed<BR />org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'luceneIndexBackupComponent' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)<BR />&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)<BR />&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)<BR />&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)<BR />&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)<BR />&nbsp;&nbsp; at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)<BR />&nbsp;&nbsp; at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)<BR />&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)<BR />&nbsp;&nbsp; at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)<BR />&nbsp;&nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)<BR />&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)<BR />&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:219)<BR />&nbsp;&nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:415)<BR />&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:309)<BR />&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)<BR />&nbsp;&nbsp; at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1467)<BR />&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1201)<BR />&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1171)<BR />&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)<BR />&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)<BR />&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)<BR />&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)<BR />&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)<BR />&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)<BR />&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)<BR />&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)<BR />&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)<BR />&nbsp;&nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<BR />&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)<BR />&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)<BR />&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<BR />&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<BR />&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)<BR />&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)<BR />&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)<BR />&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)<BR />&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)<BR />&nbsp;&nbsp; at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)<BR />&nbsp;&nbsp; at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)<BR />&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<BR />&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)<BR />&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />&nbsp;&nbsp; at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />&nbsp;&nbsp; at org.apache.catalina.core.StandardService.start(StandardService.java:516)<BR />&nbsp;&nbsp; at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<BR />&nbsp;&nbsp; at org.apache.catalina.startup.Catalina.start(Catalina.java:578)<BR />&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)<BR />&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)<BR />Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Failed to start database 'alf_data/derby_data/alfresco', see the next exception for details.)<BR />&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)<BR />&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)<BR />&nbsp;&nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)<BR />&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)<BR />&nbsp;&nbsp; … 48 more<BR />Caused by: java.sql.SQLException: Failed to start database 'alf_data/derby_data/alfresco', see the next exception for details.<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.EmbedConnection.&lt;init&gt;(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.EmbedConnection30.&lt;init&gt;(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.EmbedConnection40.&lt;init&gt;(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)<BR />&nbsp;&nbsp; at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)<BR />&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)<BR />&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)<BR />&nbsp;&nbsp; … 51 more<BR />Caused by: java.sql.SQLException: Failed to start database 'alf_data/derby_data/alfresco', see the next exception for details.<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)<BR />&nbsp;&nbsp; … 65 more<BR />Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database /opt/Alfresco/alf_data/derby_data/alfresco.<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)<BR />&nbsp;&nbsp; … 62 more<BR />Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /opt/Alfresco/alf_data/derby_data/alfresco.<BR />&nbsp;&nbsp; at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)<BR />&nbsp;&nbsp; at java.security.AccessController.doPrivileged(Native Method)<BR />&nbsp;&nbsp; at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)<BR />&nbsp;&nbsp; at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)<BR />&nbsp;&nbsp; … 62 more<BR />Jul 6, 2010 3:30:29 PM org.apache.catalina.core.StandardContext start<BR />SEVERE: Error listenerStart<BR />Jul 6, 2010 3:30:29 PM org.apache.catalina.core.StandardContext start<BR />SEVERE: Context [/alfresco] startup failed due to previous errors<BR />log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.<BR />Jul 6, 2010 3:30:31 PM org.apache.catalina.startup.HostConfig deployWAR<BR />INFO: Deploying web application archive share.war<BR />15:30:34,279&nbsp; INFO&nbsp; [web.site.FrameworkHelper] Successfully Initialized Web Framework<BR />Jul 6, 2010 3:30:34 PM org.apache.coyote.http11.Http11Protocol start<BR />INFO: Starting Coyote HTTP/1.1 on http-8080<BR />Jul 6, 2010 3:30:34 PM org.apache.catalina.startup.Catalina start<BR />INFO: Server startup in 133721 ms<BR />Error occurred during initialization of VM<BR />Could not reserve enough space for object heap<BR />Could not create the Java virtual machine.<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>Stop log:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>alfred:~# /etc/init.d/alfresco stop<BR />Using CATALINA_BASE:&nbsp;&nbsp; /opt/Alfresco/tomcat<BR />Using CATALINA_HOME:&nbsp;&nbsp; /opt/Alfresco/tomcat<BR />Using CATALINA_TMPDIR: /opt/Alfresco/tomcat/temp<BR />Using JRE_HOME:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/lib/jvm/java-6-sun<BR />Error occurred during initialization of VM<BR />Could not reserve enough space for object heap<BR />Could not create the Java virtual machine.<BR />Using CATALINA_BASE:&nbsp;&nbsp; /opt/Alfresco/virtual-tomcat<BR />Using CATALINA_HOME:&nbsp;&nbsp; /opt/Alfresco/virtual-tomcat<BR />Using CATALINA_TMPDIR: /opt/Alfresco/virtual-tomcat/temp<BR />Using JRE_HOME:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/lib/jvm/java-6-sun<BR />Error occurred during initialization of VM<BR />Could not reserve enough space for object heap<BR />Could not create the Java virtual machine.<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>When I try to restart alfresco:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>error opening security policy file /etc/X11/xserver/SecurityPolicy<BR />(EE) XKB: Couldn't open rules file /usr/share/X11/xkb/rules/base<BR />Could not init font path element /usr/share/fonts/X11/cyrillic, removing from list!<BR />Could not init font path element /usr/share/fonts/X11/100dpi/:unscaled, removing from list!<BR />Could not init font path element /usr/share/fonts/X11/75dpi/:unscaled, removing from list!<BR />Could not init font path element /usr/share/fonts/X11/100dpi, removing from list!<BR />Could not init font path element /usr/share/fonts/X11/75dpi, removing from list!<BR />[config/hal] couldn't initialise context: (null) ((null))<BR />Using CATALINA_BASE:&nbsp;&nbsp; /opt/Alfresco/tomcat<BR />Using CATALINA_HOME:&nbsp;&nbsp; /opt/Alfresco/tomcat<BR />Using CATALINA_TMPDIR: /opt/Alfresco/tomcat/temp<BR />Using JRE_HOME:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/lib/jvm/java-6-sun<BR />iptables v1.4.2: can't initialize iptables table `nat': Table does not exist (do you need to insmod?)<BR />Perhaps iptables or your kernel needs to be upgraded.<BR />iptables v1.4.2: can't initialize iptables table `nat': Table does not exist (do you need to insmod?)<BR />Perhaps iptables or your kernel needs to be upgraded.<BR />Using CATALINA_BASE:&nbsp;&nbsp; /opt/Alfresco/virtual-tomcat<BR />Using CATALINA_HOME:&nbsp;&nbsp; /opt/Alfresco/virtual-tomcat<BR />Using CATALINA_TMPDIR: /opt/Alfresco/virtual-tomcat/temp<BR />Using JRE_HOME:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /usr/lib/jvm/java-6-sun<BR />I18N: Operating system doesn't support locale ""<BR />I18N: Operating system doesn't support locale "en_US"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>This old alfresco is not installed with Mysql.</SPAN><BR /><SPAN>Those log are just after the start of the computer.</SPAN><BR /><SPAN>I install a new Alfresco: 3.2 with Mysql in hope to migrate alf_data between the to version to try to get back my data, but with no result. In the web interface I have the same result with the 3.2 and the 3.0 labs with the same alf_data, it's make me think that the database of the 3.0 is dead. I read that for backup and restore data the database is important.</SPAN><BR /><SPAN>Can someone know a way to extract my data from the old alfresco ? I don't mater if it's not work again.</SPAN><BR /><BR /><SPAN>Thank's for your help</SPAN><BR /><BR /><SPAN>Totoro</SPAN></BODY></HTML> Thu, 05 Aug 2010 20:39:38 GMT totoro 2010-08-05T20:39:38Z How to extract data from a 'old' alfresco https://connect.hyland.com/t5/alfresco-archive/how-to-extract-data-from-a-old-alfresco/m-p/236853#M189983 Hi,I have a old alfresco 3.0 labs. I fallow this page http://wiki.alfresco.com/wiki/Installing_Labs_3_Stable_on_Debian_Etch to install my old alfresco on a Debian lenny.My java version is: 1.6.0.20My SWFtools: 2009-02-07-1827It was working since few month. After a hard reboot of the computer my alfr Thu, 05 Aug 2010 20:39:38 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-extract-data-from-a-old-alfresco/m-p/236853#M189983 totoro 2010-08-05T20:39:38Z Re: How to extract data from a 'old' alfresco https://connect.hyland.com/t5/alfresco-archive/how-to-extract-data-from-a-old-alfresco/m-p/236854#M189984 <HTML><HEAD></HEAD><BODY><SPAN>You need to get your database running again.</SPAN><BR /><BR /><SPAN>Your Derby database was not shut down correctly and contains a lock file which is used to prevent multiple instances of Derby&nbsp; running on the same files.&nbsp;&nbsp;&nbsp; If you can remove the lock then it will start again.&nbsp; </SPAN><BR /><BR /><SPAN>I'm not sure that many "Derby administrators" will read this since Derby is not recommended for production use of Alfresco.&nbsp;&nbsp; I suggest that you search the Derby forums since this must be a "run of the mill" admin task.</SPAN></BODY></HTML> Fri, 06 Aug 2010 10:13:30 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-extract-data-from-a-old-alfresco/m-p/236854#M189984 mrogers 2010-08-06T10:13:30Z Re: How to extract data from a 'old' alfresco https://connect.hyland.com/t5/alfresco-archive/how-to-extract-data-from-a-old-alfresco/m-p/236855#M189985 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><SPAN>Thank's for your answer I will looking in that way.</SPAN><BR /><SPAN>Totoro</SPAN></BODY></HTML> Fri, 06 Aug 2010 10:29:34 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-extract-data-from-a-old-alfresco/m-p/236855#M189985 totoro 2010-08-06T10:29:34Z