Hi Kim
This is what i did :
r...@dspace-desktop:/usr/local/dspace1.5.2/dspace/bin# bash
update-handle-prefix 123456789 36547
If you continue, all handles in your repository with prefix 123456789 will be
updated to have handle prefix 1900
2357 items will be updated.
Have you taken a backup, and are you ready to continue? [y/n]: y
Updating handle table... 2357 items updated
Updating metadatavalues table... Exception in thread "main"
org.postgresql.util.PSQLException: ERROR: more than one row returned by a
subquery used as an expression
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.handle.UpdateHandlePrefix.main(UpdateHandlePrefix.java:97)
How can I fix that error.
Thanks
-----Original Message-----
From: Kim Shepherd [mailto:[email protected]]
Sent: Thu 8/27/2009 10:22 PM
To: Lewatle Phaladi; [email protected]
Subject: RE: [Dspace-tech] handle-server setup
Hi Lewatle,
In your [dspace]/bin directory, there is a script called "update-handle-prefix"
If, for example, your new handle is 858585:
[dspace]/bin/update-handle-prefix 123456789 858585
This will update the old handles with a default handle prefix without bothering
your new, correct items/collections/communities.
Cheers,
Kim
From: Lewatle Phaladi [mailto:[email protected]]
Sent: Friday, 28 August 2009 1:42 a.m.
To: [email protected]
Subject: [Dspace-tech] handle-server setup
Hi All
I was setting up handle server for my University, and everything went well in
such a way that changes apply only for new submissions, if we submit or import
a file the file will take a new prefix not default like 123456789,
What we really need is to change the default handle prefix e.g 123456789 to all
our previous stored digital files and even to the new imported or submited file.
Regards
Lewatle
This communication is intended for the addressee only. It is confidential. If
you have received this communication in error, please notify us immediately and
destroy the original message. You may not copy or disseminate this
communication without the permission of the University. Only authorized
signatories are competent to enter into agreements on behalf of the University
and recipients are thus advised that the content of this message may not be
legally binding on the University and may contain the personal views and
opinions of the author, which are not necessarily the views and opinions of The
University of the Witwatersrand, Johannesburg. All agreements between the
University and outsiders are subject to South African Law unless the University
agrees in writing to the contrary.
<html><p><font face = "verdana" size = "0.8" color = "navy">This communication
is intended for the addressee only. It is confidential. If you have received
this communication in error, please notify us immediately and destroy the
original message. You may not copy or disseminate this communication without
the permission of the University. Only authorized signatories are competent to
enter into agreements on behalf of the University and recipients are thus
advised that the content of this message may not be legally binding on the
University and may contain the personal views and opinions of the author, which
are not necessarily the views and opinions of The University of the
Witwatersrand, Johannesburg. All agreements between the University and
outsiders are subject to South African Law unless the University agrees in
writing to the contrary.</font></p></html>
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
