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(BrowseC
reateDAOPostgres.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.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.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(QueryExecu
torImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:258)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:96)
at
org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManage
r.java:1755)
at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:675
)
at
org.dspace.browse.BrowseCreateDAOPostgres.updateDistinctMappings(BrowseC
reateDAOPostgres.java:277)
... 8 more
bash-3.00$
Regards,
Lewatle
<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
