Hi all,
Once an new item has been submitted, it then goes through a workflow and
an administrator then approves the item.
ERROR: duplicate key value violates unique constraint
"handle_handle_key"
At this point we are getting an internal error, I think it may be trying
to issue a handle id that is already in use. A while back I did some
batch importing and had to assign/force certain handle id due to
conflicts.
Anyone any ideas how to get around this issue ?
Regards.
Aaron Hossain
Information Specialist
Central Server Group
Information Services
University of Abertay Dundee
Tel: 01382 308802
Mob: 07791670579
a.hoss...@abertay.ac.uk
Home of Dare to be Digital - the UK's premier computer games design
competition for university students
The University of Abertay Dundee is a charity registered in Scotland,
No: SC016040
An internal server error occurred on
http://repository.abertay.ac.uk:8080/jspui:
Date: 8/27/09 1:55 PM
Session ID: 854358F5AE20442E9C5859DCC7E12E9A
-- URL Was: http://repository.abertay.ac.uk:8080/jspui/mydspace
-- Method: POST
-- Parameters were:
-- step: "3"
-- submit_approve: "Approve"
-- workflow_id: "19"
Exception:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "handle_handle_key"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2S
tatement.java:308)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
tingPreparedStatement.java:102)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
tingPreparedStatement.java:102)
at
org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:13
55)
at
org.dspace.storage.rdbms.DatabaseManager.update(DatabaseManager.java:711
)
at
org.dspace.handle.HandleManager.createHandle(HandleManager.java:174)
at
org.dspace.content.InstallItem.installItem(InstallItem.java:110)
at org.dspace.content.InstallItem.installItem(InstallItem.java:72)
at
org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:662)
at
org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:616)
at
org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:592)
at
org.dspace.workflow.WorkflowManager.advance(WorkflowManager.java:372)
at
org.dspace.app.webui.servlet.MyDSpaceServlet.processPerformTask(MyDSpace
Servlet.java:461)
at
org.dspace.app.webui.servlet.MyDSpaceServlet.doDSPost(MyDSpaceServlet.ja
va:141)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.
java:147)
at
org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105
)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
at
org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnly
Filter.java:98)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:175)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2
86)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84
4)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(
Http11Protocol.java:583)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and