topic FTP Mass upload problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/ftp-mass-upload-problem/m-p/153658#M108199 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I tried to push around 200 OpenOffice document (.odt) to a folder which contains an Action.</SPAN><BR /><BR /><SPAN>The transfer was quite long, and at the end I found 8 files with a size of 0 staying at the original folder </SPAN><BR /><SPAN>(normal behaviour is: the action moves the files to sub-folders). </SPAN><BR /><SPAN>It seems that the FTP has transferred unsuccessfully these 8 files.</SPAN><BR /><BR /><SPAN>I saw in the logs that I got at least 8 errors like this one : </SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />javax.transaction.RollbackException: Transaction didn't commit: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#202350]; nested exception is org.hibernate.exception.ConstraintViolationException: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#202350]<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:430)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.server.SrvSession.endTransaction(SrvSession.java:684)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.ftp.FTPSrvSession.procStoreFile(FTPSrvSession.java:2354)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.ftp.FTPSrvSession.run(FTPSrvSession.java:4239)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:595)<BR />Caused by: org.springframework.dao.DataIntegrityViolationException: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#202350]; nested exception is org.hibernate.exception.ConstraintViolationException: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#202350]<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:699)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:570)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:654)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:624)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:307)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:420)<BR />&nbsp;&nbsp;&nbsp;… 4 more<BR />Caused by: org.hibernate.exception.ConstraintViolationException: could not update: [org.alfresco.repo.domain.hibernate.ChildAssocImpl#202350]<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2375)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2257)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2557)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:562)<BR />&nbsp;&nbsp;&nbsp;… 8 more<BR />Caused by: org.postgresql.util.PSQLException: ERREUR: une clé dupliquée rompt la contrainte unique "alf_child_assoc_parent_node_id_key"<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)<BR />&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2357)<BR />&nbsp;&nbsp;&nbsp;… 20 more<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></CODE></PRE><BR /><SPAN>(The first error in french means like : Error of duplicated key in unique constraint "alf_child_assoc_parent_node_id_key")</SPAN><BR /><BR /><SPAN>Details:</SPAN><BR /><SPAN>OS: Sun Solaris 10</SPAN><BR /><SPAN>JVM: Java HotSpot(TM) Server VM (build 1.5.0_15-b04, mixed mode)</SPAN><BR /><SPAN>Alfresco: 2.1.1</SPAN><BR /><BR /><SPAN>Thanks for your help,</SPAN></BODY></HTML> Mon, 14 Apr 2008 09:51:38 GMT ruffp 2008-04-14T09:51:38Z FTP Mass upload problem https://connect.hyland.com/t5/alfresco-archive/ftp-mass-upload-problem/m-p/153658#M108199 Hello,I tried to push around 200 OpenOffice document (.odt) to a folder which contains an Action.The transfer was quite long, and at the end I found 8 files with a size of 0 staying at the original folder (normal behaviour is: the action moves the files to sub-folders). It seems that the FTP has tra Mon, 14 Apr 2008 09:51:38 GMT https://connect.hyland.com/t5/alfresco-archive/ftp-mass-upload-problem/m-p/153658#M108199 ruffp 2008-04-14T09:51:38Z Re: FTP Mass upload problem https://connect.hyland.com/t5/alfresco-archive/ftp-mass-upload-problem/m-p/153659#M108200 <HTML><HEAD></HEAD><BODY><SPAN>I have the same problem, and it says it is because of an unique constraint violated too.</SPAN><BR /><BR /><SPAN>any ideas?</SPAN></BODY></HTML> Tue, 29 Jul 2008 15:24:15 GMT https://connect.hyland.com/t5/alfresco-archive/ftp-mass-upload-problem/m-p/153659#M108200 jzulu2000 2008-07-29T15:24:15Z