Hi Hilton

 

I will try follow the document,

 

Thanks,

Lewatle

 

From: Hilton Gibson [mailto:hilton.gibson@gmail.com]
Sent: 31 August 2011 10:57 AM
To: Lewatle Phaladi
Subject: Re: [Dspace-tech] Dspace index-update error

 

Hi Lewatle

 

This is what I did.

http://wiki.lib.sun.ac.za/index.php/SUNScholar/Indexes

 

Cheers

 

hg

 

On 31 August 2011 09:25, Lewatle Phaladi <Lewatle.Phaladi@wits.ac.za> wrote:

Hi All

 

Please see the error that I received when I run index-update on dspace, any idea on how to solve this error ?

 

bash-3.00$ ./bin/dspace index-update

Started: 1314694806725

Ended: 1314694820042

Elapsed time: 13 secs (13317 msecs)

Exception: problem updating distinct mappings: table=bi_2_dmap,item-id=11451

org.dspace.browse.BrowseException: problem updating distinct mappings: table=bi_2_dmap,item-id=11451

        at org.dspace.browse.BrowseCreateDAOPostgres.updateDistinctMappings(BrowseCreateDAOPostgres.java:286)

        at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:492)

        at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1124)

        at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:669)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183)

Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "bi_2_dmap" violates foreign key constraint "bi_2_dmap_distinct_id_fkey"

  Detail: Key (distinct_id)=(5048) is not present in table "bi_2_dis".

        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.executeQuery(AbstractJdbc2Statement.java:258)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)

        at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1755)

        at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675)

        at org.dspace.browse.BrowseCreateDAOPostgres.updateDistinctMappings(BrowseCreateDAOPostgres.java:277)

        ... 8 more

bash-3.00$

 

 

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.


------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech



 

--
Hilton Gibson
Systems Administrator
JS Gericke Library

Room 1025D
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa

Cell: +27 846 464 758 | Phone: +27 21 808 4100

 

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.