Greetings all,
I to upgrade our dSpace environment from 1.4.2 to 1.5.0. I ran thru the
upgrade procedures exactly as prescribed here:
http://www.dspace.org/1_7_0Documentation/Upgrading%20a%20DSpace%20Installation.html#UpgradingaDSpaceInstallation-UpgradingFrom1.4.2to1.5
The upgrade process went without a hitch and I was able to build the new dspace
binaries (including reindexing the DB). However, upon accessing our dspace
page, I saw a "System Error: Malformed request" as well as an "Internal System
Error" message. Looking at the dspace.log file, I saw this:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2011-07-26 15:51:42,588 WARN org.dspace.app.webui.servlet.DSpaceServlet @
anonymous:session_id=4AB698522C957BBAD2A78EAE9EDC9D2D:ip_addr=192.168.1.5:database_error:org.postgresql.util.PSQLException:
ERROR: relation "collectionitemsbydateaccession" does not exist
org.postgresql.util.PSQLException: ERROR: relation
"collectionitemsbydateaccession" does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:257)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:259)
at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:270)
at org.dspace.browse.Browse.getLastSubmitted(Browse.java:326)
at
org.dspace.app.webui.servlet.HandleServlet.collectionHome(HandleServlet.java:470)
at
org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:197)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)
at
org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I searched all the Postgres SQL files in the upgrade directory (even as far as
1.7.2) and could not find anything named "collectionitemsbydateaccession".
For what its worth, I am running Postgresql 8.1.23 on CentOS 5.6 with tomcat5
v5.2.23 and apache 2.2.23-45.
Can someone shed some light here?
Thanks,
-----------------------------
Ron Kelley
[email protected]
------------------------------------------------------------------------------
Got Input? Slashdot Needs You.
Take our quick survey online. Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
_______________________________________________
Dspace-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-general
