<div dir="ltr">Hi,<br>I have faced the following error after installing a fresh DSpace and importing 2-3 thousands items into the repository. I wanted to preserve the handles for the imported items so I removed the URI element from dublin_core.xml file and just kept the handle file for each exported package. The Import process completed successfully with no problem.<br>
I put some wok-flows on my collections and started to submit items manually. The submission completes and the item gets in to the related work-flow. The internal system error shows up when the collection admin presses the button for sending the item in to the repository.<br>
The weird thing is after this error; the user's workspace is empty without any messages or anything, empty at all.<br>I tried to find the cause of this error but found nothing. I need to resolve this ASAP because this is a production repository. I looked in to the database and noticed that unlike my other DSpace installation, the handle_id (item internal ID) and and the second part of the handle in the "handle" table are not the same. I am not sure whether this may be the problem or not.<br>
I am looking forward for all comments and solutions,<br>Bests,<br>Saeed<br><br><b>here is the Error:</b><br><br>2010-01-01 16:10:26,958 WARN org.dspace.app.webui.servlet.DSpaceServlet @ saeed@repo-ei.org:session_id=8472C2F50C508757D5E2DB93E432DB7A:ip_addr=<a href="http://192.168.123.156">192.168.123.156</a>:<b>database_error:org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "handle_handle_key"</b><br>
org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "handle_handle_key"<br> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)<br>
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)<br> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)<br>
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)<br> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300)<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.execute(DatabaseManager.java:1301)<br> at org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java:657)<br>
at org.dspace.handle.HandleManager.createHandle(HandleManager.java:174)<br> at org.dspace.content.InstallItem.installItem(InstallItem.java:110)<br> at org.dspace.content.InstallItem.installItem(InstallItem.java:72)<br>
at org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:650)<br> at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:604)<br> at org.dspace.workflow.WorkflowManager.advance(WorkflowManager.java:369)<br>
at org.dspace.app.webui.servlet.MyDSpaceServlet.processPerformTask(MyDSpaceServlet.java:442)<br> at org.dspace.app.webui.servlet.MyDSpaceServlet.doDSPost(MyDSpaceServlet.java:131)<br> at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147)<br>
at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br> at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<br>
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br>
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)<br>
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)<br> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)<br>
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)<br> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)<br> at java.lang.Thread.run(Thread.java:595)<br>
<br clear="all">Saeed Moaddeli<br>IT Department<br>Encyclopaedia of Iranian Architectural History <br>No.2175 Valiasr Ave. Tehran 1511913511, Iran<br>Tel: +98 (21) 88728125-7 W3: <a href="http://eiah.org">http://eiah.org</a><br>
</div>