<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-7">
<META content="MSHTML 6.00.6000.16587" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Dear all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Recently I am dealing with a problem with my Dspace
installation (1.4.2).</FONT></DIV>
<DIV><FONT face=Arial size=2>When I try to delete a collection and/or community
from Dspace</FONT></DIV>
<DIV><FONT face=Arial size=2>the system returns an "Internal Server Error". The
explanation</FONT></DIV>
<DIV><FONT face=Arial size=2>of this error is shown below:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Exception:<BR>org.postgresql.util.PSQLException: ERROR: update or delete on
"item" violates foreign key constraint "$1" on "dcvalue"<BR><BR>at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)<BR>at
org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)<BR>at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)<BR>at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)<BR>at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)<BR>at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)<BR>at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273)<BR>at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR>at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)<BR>at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:519)</DIV>
<DIV>etc, etc</DIV>
<DIV>..........</DIV>
<DIV>.........</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The exact reason for this error seems to be that
the collection id is referenced from another table, but isn't that what
the</FONT></DIV>
<DIV><FONT face=Arial size=2>system is supposed to do when deleting a
community/collection? Shouldn't all the relations be deleted and/or get handled
by</FONT></DIV>
<DIV><FONT face=Arial size=2>the Dspace system?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If I go manually into the Postgres and delete all
the "relations" of one collection by hand then the items related to that
collection remain</FONT></DIV>
<DIV><FONT face=Arial size=2>in the tables. I then have to do the "manual
deletion" process by hand for each item, something which is not very efficient
when dealing </FONT></DIV>
<DIV><FONT face=Arial size=2>with thousands of records (items).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Does anyone have had this problem
before?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Kind Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>-Fk</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>-- <BR>Filippos Kolovos<BR>Software Systems Analyst
& Engineer<BR>M.Sc. (Eng.) in Data Communications</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Automation & Networking
Department<BR>University of Macedonia Library<BR>Egnatia 156, P.O.Box
1591<BR>540 06 Thessaloniki, Greece</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>E-Mail: <A
href="mailto:f.kolovos@ieee.org">f.kolovos@ieee.org</A>,<BR>
<A href="mailto:filippos@uom.gr">filippos@uom.gr</A><BR>Profile: <A
href="http://www.linkedin.com/in/filipposkolovos">http://www.linkedin.com/in/filipposkolovos</A><BR>-----------------------------------------------------------------------</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>