topic Error al importar usando ANT in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-al-importar-usando-ant/m-p/146966#M102631 <HTML><HEAD></HEAD><BODY><SPAN>Hola Foro,</SPAN><BR /><SPAN>A ver, me han planteado un problema que no sé si tiene fácil solución. Estoy en un proyecto donde el cliente prioriza mucho el tema de seguridad. En el entorno de desarrollo los programadores hacen los programas y los despliegan mediante ANT. Ellos (los programadores) necesitan de vez en cuando importar y/o exportar contenidos mediante ACP’s. Como he dicho antes, la seguridad es muy estricta y ellos tienen en el servidor su propio home (máquina linux) y permisos para escribir sólo en los directorios que pertenecen al home de desarrollo. Tampoco pueden usar el cliente web. La cuestión es que para poder importar y/o exportar un ACP, la orden de línea de comandos que ejecuta el build.xml de ANT debe de ejecutarse dentro del directorio WEB-INF y no desde un directorio del home de desarrollo porque si no da error. </SPAN><BR /><BR /><SPAN>Os paso la traza del error.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />[b]ant import_acp_alfresco -Dargument_import="-user admin -pwd admin -s workspace://SpacesStore/ -path /companyhome -verbose -d /aplic/w24i/dist w24WebScriptsACP.acp"[/b]<BR />Buildfile: build.xml<BR /><BR />import_acp_alfresco:<BR />import_acp_alfresco_:<BR />[java] Alfresco Repository Importer<BR />[java] The following error has occurred:<BR />[java] 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 />[java] 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 />[java] Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />[java] Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin HibernateTransactionManager.java:510)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary TransactionAspectSupport.java:219)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.transaction.SpringAwareUserTransaction.begin(SpringAwareUserTransaction.java:415)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:311)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:248)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory$LuceneIndexBackupComponent.afterPropertiesSet(AbstractLuceneIndexerAndSearcherFactory.java:1513)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1172)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:427)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:249)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:155)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:246)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:291)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:122)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.ClassPathXmlApplicationContext.&lt;init&gt;(ClassPathXmlApplicationContext.java:76)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.ApplicationContextHelper.getApplicationContext(ApplicationContextHelper.java:55)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.tools.Tool.initialiseRepository(Tool.java:246)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.tools.Tool.start(Tool.java:212)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.tools.Import.main(Import.java:66)<BR />[java] Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: Unknown host specified )<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; … 27 more<BR />[java] Caused by: java.sql.SQLException: Io exception: Unknown host specified<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.PhysicalConnection.&lt;init&gt;(PhysicalConnection.java:441)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CConnection.&lt;init&gt;(T4CConnection.java:165)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)<BR />[java]&nbsp;&nbsp;&nbsp;&nbsp; … 30 more<BR />[java]<BR />[java] Java Result: 255<BR />BUILD SUCCESSFUL<BR />Total time: 43 seconds<BR /><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></CODE></PRE><BR /><BR /><SPAN>¿A alguien se le ocurre algo?</SPAN><BR /><SPAN>Muchas gracias y saludos.</SPAN></BODY></HTML> Wed, 27 Jan 2010 10:06:15 GMT volasolo_9270 2010-01-27T10:06:15Z Error al importar usando ANT https://connect.hyland.com/t5/alfresco-archive/error-al-importar-usando-ant/m-p/146966#M102631 Hola Foro,A ver, me han planteado un problema que no sé si tiene fácil solución. Estoy en un proyecto donde el cliente prioriza mucho el tema de seguridad. En el entorno de desarrollo los programadores hacen los programas y los despliegan mediante ANT. Ellos (los programadores) necesitan de vez en c Wed, 27 Jan 2010 10:06:15 GMT https://connect.hyland.com/t5/alfresco-archive/error-al-importar-usando-ant/m-p/146966#M102631 volasolo_9270 2010-01-27T10:06:15Z Re: Error al importar usando ANT https://connect.hyland.com/t5/alfresco-archive/error-al-importar-usando-ant/m-p/146967#M102632 <HTML><HEAD></HEAD><BODY><SPAN>Buenas. </SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection</BLOCKQUOTE><BR /><SPAN>Según eso, todo pinta a que no realiza con éxito la conexión con la BBDD. ¿Podrías comprobar en los archivos de conexión a tu BBDD está todo correcto?</SPAN></BODY></HTML> Fri, 19 Mar 2010 10:29:06 GMT https://connect.hyland.com/t5/alfresco-archive/error-al-importar-usando-ant/m-p/146967#M102632 cristinamr 2010-03-19T10:29:06Z