[Dspace-tech] duplicate key violates unique constraint "handle_handle_key"

[Van Ly]

Hi;

Has anyone found a fix for

  PSQLException: ERROR: duplicate key violates unique constraint  
"handle_handle_key" ?

I've upgraded a DSpace from 1.4.2 to 1.5 and then to 1.5.2 and  
haven't done anything to the handle-server.

At both the newer versions, by batch import, I am able to `add' but  
not `replace' an item.

The newly added item is given the handle `123/89310'; the current  
state of the handle table in the postgresql database has by  
descending handle_id values:

  handle_id |   handle
---+-
  89306 | 123/89306
  89305 | 123/89305
  89304 | 123/40284
  89303 | 123/5090
  89302 | 123/4383
  89301 | 123/8301
  89300 | 123/7008

and handle_seq is 89306

The error message is:

  1  org.postgresql.util.PSQLException: ERROR: duplicate key  
violates unique constraint "handle_handle_key"
  2  at  
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse 
(QueryExecutorImpl.java:1512)
  3  at  
org.postgresql.core.v3.QueryExecutorImpl.processResults 
(QueryExecutorImpl.java:1297)
  4  at org.postgresql.core.v3.QueryExecutorImpl.execute 
(QueryExecutorImpl.java:188)
  5  at  
org.postgresql.jdbc2.AbstractJdbc2Statement.execute 
(AbstractJdbc2Statement.java:430)
  6  at  
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags 
(AbstractJdbc2Statement.java:346)
  7  at  
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate 
(AbstractJdbc2Statement.java:300)
  8  at  
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate 
(DelegatingPreparedStatement.java:101)
  9  at  
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate 
(DelegatingPreparedStatement.java:101)
 10  at org.dspace.storage.rdbms.DatabaseManager.execute 
(DatabaseManager.java:1301)
 11  at org.dspace.storage.rdbms.DatabaseManager.update 
(DatabaseManager.java:657)
 12  at org.dspace.handle.HandleManager.createHandle 
(HandleManager.java:206)
 13  at org.dspace.content.InstallItem.installItem 
(InstallItem.java:114)
 14  at org.dspace.app.itemimport.ItemImport.addItem 
(ItemImport.java:672)
 15  at org.dspace.app.itemimport.ItemImport.replaceItems 
(ItemImport.java:585)
 16  at org.dspace.app.itemimport.ItemImport.main 
(ItemImport.java:425)

This problem is also noted at: http://jira.dspace.org/jira/browse/DS-110

Thanks in advance.

Van Ly
vly at usyd dot edu dot au





--
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] FW: help windows installation

[Allen Lam]

Hi Susan,

Check these points:

Find in dspace.cfg, what username you are using to login to postgres?
Open pgAdminIII (provided by postgres) and check the Login Roles. Can 
you find the username?
In pgAdminIII also check the properties of the "dspace" database. Who is 
the owner?

Fix any conflicts that you discover.

Best,
Allen Lam.
HKU Hub Administrator, http://hub.hku.hk



Kantargis, Susan wrote:
>
> Hello,
>
> I’ve been relocation dspace to a new windows server and must have 
> missed a step along the line.
>
> This message comes up when I bring \jspui up with tomcat:
>
> WARN org.dspace.jsp @ 
> anonymous:no_context:database_error:org.postgresql.util.PSQLException\colon; 
> FATAL\colon; permission denied for database "dspace"
>
> Detail\colon; User does not have CONNECT privilege.
>
> org.postgresql.util.PSQLException: FATAL: permission denied for 
> database "dspace"
>
> Detail: User does not have CONNECT privilege.
>
> Can someone please point to the right spot?
>
> *Sue Kantargis*
>
> Programmer Analyst
>
> *Department of Computing Resources** *
>
> Southern New Hampshire University
>
> 2500 North River Road
>
> Manchester, NH 03106
>
> *Phone:* 603-668-2211 ext. 2337
>
> *Fax:* 603-645-9775
>
>
> Please consider the environment before printing this e-mail.
> 
>
> --
> 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
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>   

--
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] FW: help windows installation

[Kantargis, Susan]

Hello,
I've been relocation dspace to a new windows server and must have missed a step 
along the line.

This message comes up when I bring \jspui up with tomcat:


WARN  org.dspace.jsp @ 
anonymous:no_context:database_error:org.postgresql.util.PSQLException\colon; 
FATAL\colon; permission denied for database "dspace"
  Detail\colon; User does not have CONNECT privilege.
org.postgresql.util.PSQLException: FATAL: permission denied for database 
"dspace"
  Detail: User does not have CONNECT privilege.

Can someone please point to the right spot?


Sue Kantargis

Programmer Analyst
Department of Computing Resources
Southern New Hampshire University
2500 North River Road
Manchester, NH 03106

Phone: 603-668-2211 ext. 2337
Fax: 603-645-9775



Please consider the environment before printing this e-mail.
--
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] How to update the URL of a DSpace instance in ROAR

[Guillermo Antonio Varela]

Hi,


¿Does any of you know how to update the information about a DSpace instance in 
Celestial (http://celestial.eprints.org/status)?
Until a few months ago the URL was http://dspace.icesi.edu.co/dspace but it has 
been changed to http://bibliotecadigital.icesi.edu.co/biblioteca_digital/ 
(http://bibliotecadigital.icesi.edu.co/biblioteca_digital-oai/request) and I 
can´t get any register form or email to contact an administrator in the 
Celestial web site.

Because of this our instance is appearing twice on 
http://roar.eprints.org/,with the old URL (which has no problem with the 
activity graph) and with the new one (which has no activity graph, because that 
URL is not registered in Celestial).

I tested the OAI interfece using the Web application in http://re.cs.uct.ac.za/ 
with the new URL and it pass the test so I don't think that's the reason why we 
are not in Celestial with the new URL.

Also I have written several emails to Tim Brody 
(tdb...@ecs.soton.ac.uk), since 02/10/2009, but 
I haven't received an answer ¿Do the updates in ROAR take that long? ¿Is he 
still in charge of updating the data in Open ROAR? ¿Is there another email 
address to write to about this or a form in a Web site to update de URL?


Thanks for the help you can give us.


[cid:image001.jpg@01CA621D.5408FFD0]
Guillermo Antonio Varela Herrera
Analista Programador Jr.
Desarrollo de Sistemas
Servicios y Recursos de Información
Universidad Icesi

<>--
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] Minho stats add-on for DSpace 1.5.2 (compiles ok, but can't access)

[Luciano Musacchio]

hi everybody!

I'm trying to build dspace-1.5.2+stats-addon-2.1.2 (from Minho University).
I've compiled succesfully the source code (patched trough Eclipse). I get
this warning tough:

[INFO]

[INFO] Building DSpace STATS
[INFO]
[INFO] Id: org.dspace.modules:stats:jar:1.5.2
[INFO] task-segment: [package]
[INFO]

[INFO] [resources:resources]
[INFO] Using default encoding to copy filtered resources.
[INFO] [compiler:compile]
[INFO] No sources to compile
[INFO] [resources:testResources]
[INFO] Using default encoding to copy filtered resources.
[INFO] [compiler:testCompile]
[INFO] No sources to compile
[INFO] [surefire:test]
[INFO] No tests to run.
[INFO] [jar:jar]
[WARNING] JAR will be empty - no content was marked for inclusion!
[INFO] Building jar:
/Users/l0kit0/Documents/DSpace/dspace-1.5.2/dspace/modules/stats/target/stats-1.5.2.jar


I've copied the binary files, the stats files and modified the dspace.cfg
file as specified in the install process, but when I try to access trough
http://url/stats I get nothing.. also, i don't get any intresting log
message.. I hope that someone can give me a hint..

Thanks!
--
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] Indexing documents with fields in DSpace

[Luis Rodrigues]

Hello,

I have a collection of documents I would like to index in dspace. The docs
are like this:

Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Suspendisse condimentum bibendum purus, pretium tempus enim faucibus ut. In
magna ante, imperdiet ut tincidunt nec, varius sed risus. Morbi et orci quis
ipsum vulputate vulputate eu ac metus. Pellentesque at placerat purus.
Sed dolor urna, tempor a ultricies in, faucibus at nisi. Nunc cursus,
erat ut aliquet fermentum, purus dolor consequat nibh, vel porttitor
mauris sapien quis tellus. Maecenas magna metus, vehicula vel sodales eu,
fermentum vel lorem. Nam placerat tortor eget eros tempor fermentum
quis nec leo. In hac habitasse platea dictumst. Sed semper,
augue et posuere mollis, libero elit rutrum lectus, at pulvinar augue massa
vel eros. Aliquam in molestie nunc. Donec sed metus eget libero
ultrices posuere. Quisque vitae neque in nunc pulvinar euismod eu a sapien.

I would like to able to type in the search box:
tag1: Lorem ipsum
that is TAG: text query

only search for the text in the indexed tag1.

When no tag is entered the normal full text search would be used.

Can anyone provide with some insight how to do this?

Best regards,

Luis
--
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] Configure dspace for usage by user community

[sanjib mondal]

Hi All,


  I want to configure dspace for usage by user community. Can any have idea
of how to do this.

Regards
Sanjeev
--
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech