[Dspace-tech] error with Index_all

[Nigel Pegus]

Hello,

 

I am attempting to upgrade a Dpsace version 1.1.1 install to 1.3.1. However I have encountered errors after running command ./index-all I noted that when I first run the command it does not locate dsrun. I then created a script to setup the environment and the command then goes through but yields the error listed below. I did not do the original install and the site is normally available at startup so I am assuming there has been some sort of environment automatically setup java??.

 

Does anyone have any input on what the possible problem is?

 

 

Thanks in advance,

 

 

 

Here is the output :

 

Creating browse index

Indexing all Items in DSpace....Error: Browse index NOT created

java.sql.SQLException: ERROR:  Relation "communities2item" does not exist

 

        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)

        at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Con

nection.java:505)

        at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Stat

ement.java:320)

        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat

ement.java:48)

        at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdb

c1Statement.java:197)

        at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdb

c1Statement.java:183)

        at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingS

tatement.java:225)

        at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.

java:284)

        at org.dspace.browse.Browse.indexRemoveAll(Browse.java:518)

        at org.dspace.browse.Browse.indexAll(Browse.java:486)

        at org.dspace.browse.InitializeBrowse.main(InitializeBrowse.java:74)

Creating search index

Exception in thread "main" java.lang.IllegalArgumentException: No such column su

bmitter

        at org.dspace.storage.rdbms.TableRow.isColumnNull(TableRow.java:121)

        at org.dspace.content.Collection.groupFromColumn(Collection.java:1073)

        at org.dspace.content.Collection.<init>(Collection.java:154)

        at org.dspace.content.Collection.findAll(Collection.java:291)

        at org.dspace.search.DSIndexer.indexAllCollections(DSIndexer.java:329)

        at org.dspace.search.DSIndexer.createIndex(DSIndexer.java:184)

        at org.dspace.search.DSIndexer.main(DSIndexer.java:218)

 

Nigel Pegus
Systems Unit
The Main Library,
The University of the West Indies,
St. Augustine Campus,
St. Augustine,
Trinidad and Tobago,
West Indies.
Tel: 868-662-2002 ext 2263
Fax: 868-662-9238

 

[Tansley, Robert]

The error is probably due to your postgresql.jar not being the correct one for your PostgreSQL version.

 

Also note that you need to upgrade to 1.2.2 first, then to 1.3.3.  We don't support a direct 1.1.x to 1.3.x upgrade.

---

From: dspace-t...@lists.sourceforge.net [mailto:dspace-t...@lists.sourceforge.net] On Behalf Of Nigel Pegus
Sent: 12 August 2005 14:03
To: dspac...@lists.sourceforge.net
Subject: [Dspace-tech] error with Index_all