I tried to delete a collection in DSpace 1.5.1 online yesterday and got this error. I was able to finally delete it only after I went in and manually deleted all the rows in bi_7_dmap, but I'm not quite sure why I had to do this or if it's a bug...?? Does anyone have any ideas? Thanks, Sue
-----Original Message----- From: LDR-S - Langley Digital Repository (1.5.1) [mailto:[email protected]] Sent: Tuesday, September 28, 2010 4:13 PM To: Thornton, Susan M. (LARC-B702)[Raytheon Information Services (RIS)] Subject: Langley Digital Repository (LDR-S) Internal Server Error An internal server error occurred on https://xxxxx.larc.nasa.gov: Date......: 9/28/10 4:13 PM Session ID: D884BF71A03E4AA0C04ABFC55F5A366B -- URL Was: https://xxxxx.larc.nasa.gov/tools/edit-communities -- Method: POST -- Parameters were: -- collection_id: "7" -- community_id: "4" -- action: "10" -- submit: "Delete" *************** * Exception.: * *************** org.postgresql.util.PSQLException: ERROR: update or delete on table "item" violates foreign key constraint "bi_7_dmap_item_id_fkey" on table "bi_7_dmap" Detail: Key (item_id)=(28) is still referenced from table "bi_7_dmap". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:390) at org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:535) at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:502) at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:737) at org.dspace.content.Item.delete(Item.java:1904) at org.dspace.content.Collection.removeItem(Collection.java:950) at org.dspace.content.Collection.delete(Collection.java:1076) at org.dspace.content.Community.removeCollection(Community.java:1073) at org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(EditCommunitiesServlet.java:275) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:152) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:110) at javax.servlet.http.HttpServlet.service(HttpServlet.java:816) at javax.servlet.http.HttpServlet.service(HttpServlet.java:917) at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:398) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:217) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:255) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:586) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:556) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:187) at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:586) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:556) at com.sun.webserver.connector.nsapi.NSAPIProcessor.service(NSAPIProcessor.java:160) **Note......: This error occurs due to one or more Java errors/exceptions in LDR-S and is a "catch-all" for non-specific application errors. Stack traces should be analyzed to determine likely causes. In addition, DSpace, PostgreSQL, and server logs can be examined for specific error mesasges that may help with error diagnosis and resolution. LDR-S Administration ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
