topic Export command line in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/export-command-line/m-p/68479#M43899 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>I'm trying to make a full export of alfresco via command line, I've used the shell script provided in post </SPAN><A href="http://forums.alfresco.com/viewtopic.php?t=2425&amp;highlight=export+command+line" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=2425&amp;highlight=export+command+line</A><BR /><BR /><SPAN>I've modified this script to match my alfresco environment</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>#!/usr/bin/ksh<BR />export TOMCAT_HOME=/product/1.4.0/tomcat;<BR />export PATH=${PATH}:${TOMCAT_HOME};<BR /><BR />export IMPORT_LIB=./webapps/PortailCapitalisation/WEB-INF/lib<BR />export IMPORT_COMMON=./common/lib<BR />export JAVA_CLASSPATH=./webapps/PortailCapitalisation/WEB-INF/lib<BR />export IMPORT_CLASSES=./webapps/PortailCapitalisation/WEB-INF/classes<BR />cd $TOMCAT_HOME<BR /><BR />for i in $TOMCAT_HOME/$IMPORT_LIB/*.jar ;<BR />do export JAVA_CLASSPATH=${JAVA_CLASSPATH}:$i ;<BR />done<BR /><BR /># Class for Oracle<BR />for i in $TOMCAT_HOME/$IMPORT_COMMON/classes12.jar ;<BR />do export JAVA_CLASSPATH=${JAVA_CLASSPATH}:$i ;<BR />done<BR /><BR /><BR />export JAVA_CLASSPATH=${JAVA_CLASSPATH}:${IMPORT_CLASSES} ;<BR />$JAVA_HOME/bin/java -cp $JAVA_CLASSPATH org.alfresco.tools.Export "$@"<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><BR /><BR /><SPAN>…but it does not work. </SPAN><BR /><SPAN>It seems that export user 'admin' cannot connect to the Oracle database.</SPAN><BR /><BR /><SPAN>Anyway I've got this error :</SPAN><BR /><BR /><BR /><PRE class="language-none line-numbers"><CODE>./alf_exp.sh -user admin -pwd adminpass -s system://system&nbsp; system.acp<BR />Alfresco Repository Exporter<BR />17:35:48,643 ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to execute command: convert /tmp/Alfresco/ImageMagickContentTransformer_init_source_43370.gif&nbsp; /tmp/Alfresco/ImageMagickContentTransformer_init_target_43371.png<BR />17:35:49,858 ERROR [repo.transaction.TransactionUtil] Error rolling back transaction<BR />java.lang.IllegalStateException: No user transaction is active<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:450)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:193)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:74)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:126)<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:585)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1093)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1063)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:87)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:72)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:40)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.tools.Tool.initialiseRepository(Tool.java:238)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.tools.Tool.start(Tool.java:204)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.tools.Export.main(Export.java:57)<BR />The following error has occurred:<BR />Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Initialization of bean 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<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></CODE></PRE><BR /><SPAN>If someone as an idea !</SPAN><BR /><SPAN>Thanks in advance</SPAN><BR /><BR /><SPAN>.-ea</SPAN></BODY></HTML> Tue, 05 Dec 2006 16:41:28 GMT ea 2006-12-05T16:41:28Z Export command line https://connect.hyland.com/t5/alfresco-archive/export-command-line/m-p/68479#M43899 Hi,I'm trying to make a full export of alfresco via command line, I've used the shell script provided in post http://forums.alfresco.com/viewtopic.php?t=2425&amp;highlight=export+command+lineI've modified this script to match my alfresco environment#!/usr/bin/kshexport TOMCAT_HOME=/product/1.4.0/tom Tue, 05 Dec 2006 16:41:28 GMT https://connect.hyland.com/t5/alfresco-archive/export-command-line/m-p/68479#M43899 ea 2006-12-05T16:41:28Z Re: Export command line https://connect.hyland.com/t5/alfresco-archive/export-command-line/m-p/68480#M43900 <HTML><HEAD></HEAD><BODY><SPAN>It seems that the export tool do not care about custom parameters of alfresco located</SPAN><BR /><SPAN>in $TOMCAT_HOME/shared/classes</SPAN><BR /><SPAN>So I add it in IMPORT_CLASSES in the script :</SPAN><BR /><SPAN>export IMPORT_CLASSES=./shared/classes:./webapps/PortailCapitalisation/WEB-INF/classes</SPAN><BR /><BR /><SPAN>The authentication is made first by Alfresco and second by Active Directory, and when I use&nbsp; a AD user to make the export it works but when I use the admin user which is not in AD it fails :</SPAN><BR /><PRE class="language-none line-numbers"><CODE>The following error has occurred:<BR />Failed to authenticate<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Any idea ?</SPAN><BR /><SPAN>Thanks</SPAN></BODY></HTML> Tue, 05 Dec 2006 18:06:54 GMT https://connect.hyland.com/t5/alfresco-archive/export-command-line/m-p/68480#M43900 ea 2006-12-05T18:06:54Z