Hi Filippos, The dcvalue database table is probably left over from a previous installation that you have upgraded from; It should now be known as metadatavalue. Have you run through the upgrade procedure when moving to 1.4.2? If coming from 1.3.x or earlier you will need to run the database upgrade scripts provided in [dspace-source]/etc.
Cheers, Richard > Dear all, > > Recently I am dealing with a problem with my Dspace installation (1.4.2). > When I try to delete a collection and/or community from Dspace > the system returns an "Internal Server Error". The explanation > of this error is shown below: > > Exception: > org.postgresql.util.PSQLException: ERROR: update or delete on "item" > violates foreign key constraint "$1" on "dcvalue" > > at > org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) > at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) > at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) > at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) > at > org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) > at > org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:273) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:519) > etc, etc > .......... > ......... > > The exact reason for this error seems to be that the collection id is > referenced from another table, but isn't that what the > system is supposed to do when deleting a community/collection? > Shouldn't all the relations be deleted and/or get handled by > the Dspace system? > > 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 > 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 > with thousands of records (items). > > Does anyone have had this problem before? > > Kind Regards, > > -Fk > > -- > Filippos Kolovos > Software Systems Analyst & Engineer > M.Sc. (Eng.) in Data Communications > > Automation & Networking Department > University of Macedonia Library > Egnatia 156, P.O.Box 1591 > 540 06 Thessaloniki, Greece > > E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>, > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Profile: http://www.linkedin.com/in/filipposkolovos > ----------------------------------------------------------------------- > > -- Richard Jones Research Engineer, HP Labs eml: [EMAIL PROTECTED] blg: http://chronicles-of-richard.blogspot.com/ ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
