topic Problem with links deleting document and reupdate it in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-with-links-deleting-document-and-reupdate-it/m-p/296623#M249753 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>I'm new in the forum and with Alfresco. I've got a problem with links.</SPAN><BR /><SPAN>I've created some links to a document. When I delete the document, its links are not deleted but I can't see them, probably because they don't find the nodeRef associated. </SPAN><BR /><SPAN>Then I re-upload the document with the same name and I try to recreate the links and Alfresco says to me that a node with this name already exists. So I delete them using Javascript Console, and try again to create links. </SPAN><BR /><BR /><SPAN>Now Alfresco sends me this stack trace:</SPAN><BR /><BR /><SPAN> org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "parent_node_id"</SPAN><BR /><SPAN>&nbsp; Detail: Key (parent_node_id, type_qname_id, child_node_name_crc, child_node_name)=(1193, 35, 918653046, test.txt.url) already exists.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:87)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:46)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor393.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:606)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)</SPAN><BR /><BR /></BODY></HTML> Fri, 11 Oct 2013 13:21:44 GMT ruudg 2013-10-11T13:21:44Z Problem with links deleting document and reupdate it https://connect.hyland.com/t5/alfresco-archive/problem-with-links-deleting-document-and-reupdate-it/m-p/296623#M249753 Hi,I'm new in the forum and with Alfresco. I've got a problem with links.I've created some links to a document. When I delete the document, its links are not deleted but I can't see them, probably because they don't find the nodeRef associated. Then I re-upload the document with the same name and I Fri, 11 Oct 2013 13:21:44 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-links-deleting-document-and-reupdate-it/m-p/296623#M249753 ruudg 2013-10-11T13:21:44Z Re: Problem with links deleting document and reupdate it https://connect.hyland.com/t5/alfresco-archive/problem-with-links-deleting-document-and-reupdate-it/m-p/296624#M249754 <HTML><HEAD></HEAD><BODY><SPAN>I've tried to delete links and THEN the document, but at the end the problem is the same</SPAN></BODY></HTML> Fri, 11 Oct 2013 13:23:45 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-links-deleting-document-and-reupdate-it/m-p/296624#M249754 ruudg 2013-10-11T13:23:45Z