Hi Sisay, in the past this problem was caused by too much text in one of the metadata fields (the usual suspect is dc.description.abstract). Try to take a look at the items you submitted since the last successful reindexing and shorten any text that seems excessively long. You can still upload the whole text of the metadata field as a bitstream (preferably in the TEXT bundle) so the item will still be fully searchable.
Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Mon, Apr 1, 2013 at 3:12 PM, Webshet, Sisay (ILRI) <s.webs...@cgiar.org> wrote: > Hi all, > > > > > > This is what I usually do without any trouble > > · To have a browse by filed I am using files like > (message.xml,dspace.cfg) > > · To have linkable/clikcable fields I used (item-list.xsl and > item-view.xsl) > > However I try to reindex the system, the following errors were displayed. > > Can anybody has a hint to giureout this solution. > > > > > > > > Exception: org.postgresql.util.PSQLException: ERROR: index row size 3024 > exceeds > maximum 2712 for index "bi_11_dis_svalue_idx" > > org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: > ind > ex row size 3024 exceeds maximum 2712 for index "bi_11_dis_svalue_idx" > > at > org.dspace.browse.BrowseCreateDAOPostgres.insertDistinctRecord(Browse > CreateDAOPostgres.java:671) > > at > org.dspace.browse.BrowseCreateDAOPostgres.getDistinctID(BrowseCreateD > AOPostgres.java:543) > > at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:468) > > at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1127) > > at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1076) > > at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:718) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. > java:39) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces > sorImpl.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: index row size 3024 > exceeds > maximum 2712 for index "bi_11_dis_svalue_idx" > > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx > ecutorImpl.java:1531) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor > Impl.java:1313) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja > va:188) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat > ement.java:452) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract > Jdbc2Statement.java:354) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc > 2Statement.java:258) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele > gatingPreparedStatement.java:96) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele > gatingPreparedStatement.java:96) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele > gatingPreparedStatement.java:96) > > at > org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseMan > ager.java:1755) > > at > org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java: > 675) > > at > org.dspace.browse.BrowseCreateDAOPostgres.insertDistinctRecord(Browse > CreateDAOPostgres.java:662) > > ... 10 more > > > ------------------------------------------------------------------------------ > Own the Future-Intel® Level Up Game Demo Contest 2013 > Rise to greatness in Intel's independent game demo contest. > Compete for recognition, cash, and the chance to get your game > on Steam. $5K grand prize plus 10 genre and skill prizes. > Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------------------------------------------------------ Own the Future-Intel(R) Level Up Game Demo Contest 2013 Rise to greatness in Intel's independent game demo contest. Compete for recognition, cash, and the chance to get your game on Steam. $5K grand prize plus 10 genre and skill prizes. Submit your demo by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2 _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette