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.