Good morning, It looks like that relation (view) shouldn't be in 1.5, see http://www.mail-archive.com/dspace-tech@lists.sourceforge.net/msg09668.html. Just to be sure, did you run index-init instead of index-update?
B-- >>> On 7/26/2011 at 7:26 PM, in message <09f56fdf-b500-434d-a254-521519f30...@gmail.com>, Ron Kelley <rkelley...@gmail.com> wrote: > 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%20Installatio > n.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:dat > abase_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(QueryExecutorIm > pl.java:1512) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.jav > a:1297) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.ja > va:437) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Sta > tement.java:353) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Stateme > nt.java:257) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPr > eparedStatement.java:92) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPr > eparedStatement.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(ApplicationF > ilterChain.java:269) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha > in.java:188) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.jav > a:210) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.jav > a: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.processCo > nnection(Http11BaseProtocol.java:665) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java > :528) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWor > kerThread.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 > rkelley...@gmail.com > > > > > ------------------------------------------------------------------------------ > 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 > Dspace-general@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-general ------------------------------------------------------------------------------ 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 Dspace-general@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-general
