Hi Hilton
I will try follow the document,
Thanks,
Lewatle
From: Hilton Gibson [mailto:[email protected]]
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 <[email protected]> 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
[email protected]
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
<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>------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
