Re: [Dspace-tech] Problem with indexing 1.4.2 (update)

[Bernadette Schlonsok]

Hi George,

you should remove

/usr/local/tomcat/webapps/dspace/WEB-INF/classes

/usr/local/tomcat/webapps/dspace-oai/WEB-INF/classes

from your CLASSPATH.
dsrun sets its java environment itself, see
FULLPATH=$CLASSPATH:$JARS:$DSPACEDIR/config

If you got DSpace 1.3.2 in Tomcat and set the tomcat classes in the 
CLASSPATH they will be found and used before the DSpace jars you 
actually need.

sunny greetings

Claudia Jürgen

George Kozak schrieb:
 Hi...

 This is an update to the indexing problem that I wrote about a 
 problem with DSpace 1.4.2

 When I did an index-all, I got the following error:
  Indexing all Items in DSpaceERROR:  Relation dctyperegistry 
 does not exist

 Several people suggested that I had a CLASSPATH problem.  Sure 
 enough, in my .cshrc profile in my CLASSPATH I had
 /usr/local/tomcat/webapps/dspace/WEB-INF/classes and 
 /usr/local/tomcat/webapps/dspace-oai/WEB-INF/classes

 AND since I had compiled my 1.4.2 release BUT had not uploaded to 
 Tomcat, yet, the classes of the old version of DSpace were being 
 called.  Thanks to all those who wrote to me.

 Does anyone have any ideas as to what I'm doing wrong?

 ***
 George Kozak
 Coordinator
 Web Development and Management
 Digital Media Group
 501 Olin Library
 Cornell University
 607-255-8924
 ***
 [EMAIL PROTECTED]  


 -
 This SF.net email is sponsored by: Microsoft
 Defy all challenges. Microsoft(R) Visual Studio 2005.
 http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech
   

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Database question

[Bernadette Schlonsok]

Hello Mika,
this error says, you have duplicated values in a column with unique index.
For DSpace 1.4 you can check all unique index as follow:

select name, count(*) from epersongroup group by name having count(*)1;
select short_description, count(*) from BitstreamFormatRegistry group by 
short_description having count(*)1;
select email, count(*) from eperson group by email having count(*)1;
select namespace, count(*) from MetadataSchemaRegistry group by 
namespace having count(*)1;
select short_id, count(*) from MetadataSchemaRegistry group by short_id 
having count(*)1;
select handle, count(*) from Handle group by handle having count(*)1;
select item_id, count(*) from WorkflowItem group by item_id having 
count(*)1;
select email, count(*) from RegistrationData group by email having 
count(*)1;
select checksum, count(*) from History group by checksum having count(*)1;

You result for the queries should be always 0 rows. But NULL Values are 
not equal, so you can have multiple rows for a unique index with NULL 
values.
For example in our Database we have 6 rows in table History with 
checksum NULL.

select checksum, count(*) from History group by checksum having count(*)1;
 checksum | count
--+---
  | 6
(1 row)

select * from history where checksum is null;
 history_id | creation_date | checksum
+---+--
 467492 |   |
 467493 |   |
 467494 |   |
 467500 |   |
 467501 |   |
 467502 |   |
(6 rows)

Maybe that helps
Bernadette

Mika Stenberg schrieb:
 While reindexing Dspace database I get following error. Wonder whats 
 causing this and how could I fix this?

 reindexdb: reindexing of database dspace failed:
 ERROR:  could not create unique index
 DETAIL:  Table contains duplicated values.

 -Mika

 -
 This SF.net email is sponsored by: Microsoft
 Defy all challenges. Microsoft(R) Visual Studio 2005.
 http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech
   

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech