[Dspace-tech] Error after upgrading from 3.2 to 4.0

8 views
Skip to first unread message

Anthony Petryk

unread,
Aug 26, 2015, 12:18:04 PM8/26/15
to dspac...@lists.sourceforge.net

Hello,

 

I’m getting the following error (below) after upgrading DSpace from version 3.2 to 4.0.  I see a similar error when trying to access the xmlui. 

 

I followed all the steps written in the manual.  Note that I successfully upgrade 1.8.x to 3.2 a few days ago.

 

Thanks in advance for your help.

 

Anthony Petryk

Emerging Technologies Librarian | Bibliothécaire des technologies émergentes

uOttawa Library | Bibliothèque uOttawa

613-562-5800 x4650

ape...@uottawa.ca

 

--

 

2014-02-06 11:44:38,259 ERROR org.dspace.jsp @ caught exception:

org.dspace.plugin.PluginException: ERROR: relation "community" does not exist

  Position: 15

                at org.dspace.app.webui.components.TopCommunitiesSiteProcessor.process(TopCommunitiesSiteProcessor.java:53)

                at org.apache.jsp.index_jsp._jspService(index_jsp.java:120)

                at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

                at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

                at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

                at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

                at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

                at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

                at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

                at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)

                at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)

                at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

                at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

                at java.lang.Thread.run(Thread.java:744)

Caused by: org.postgresql.util.PSQLException: ERROR: relation "community" does not exist

  Position: 15

                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)

                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)

                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.queryTable(DatabaseManager.java:221)

                at org.dspace.content.Community.findAllTop(Community.java:314)

                at org.dspace.app.webui.components.TopCommunitiesSiteProcessor.process(TopCommunitiesSiteProcessor.java:49)

                ... 29 more

2014-02-06 11:44:38,274 WARN  org.dspace.app.webui.servlet.InternalErrorServlet @ :session_id=9EAF6DCFEE6E19598C81045CEF1DCAD4:internal_error:-- URL Was: http://137.122.14.240/jspui/internal-error

-- Method: GET

-- Parameters were:

 

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 59

 

56:             SiteHomeProcessor[] chp = (SiteHomeProcessor[]) PluginManager.getPluginSequence(SiteHomeProcessor.class);

57:             for (int i = 0; i < chp.length; i++)

58:             {

59:                 chp[i].process(context, request, response);

60:             }

61:         }

62:         catch (Exception e)

 

 

Stacktrace:

                at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568)

                at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455)

                at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

                at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

                at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

                at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

                at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

                at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)

                at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)

                at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

                at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

                at java.lang.Thread.run(Thread.java:744)

Caused by: javax.servlet.ServletException: org.dspace.plugin.PluginException: ERROR: relation "community" does not exist

  Position: 15

                at org.apache.jsp.index_jsp._jspService(index_jsp.java:127)

                at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

                at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

                ... 25 more

Caused by: org.dspace.plugin.PluginException: ERROR: relation "community" does not exist

  Position: 15

                at org.dspace.app.webui.components.TopCommunitiesSiteProcessor.process(TopCommunitiesSiteProcessor.java:53)

                at org.apache.jsp.index_jsp._jspService(index_jsp.java:120)

                ... 28 more

Caused by: org.postgresql.util.PSQLException: ERROR: relation "community" does not exist

  Position: 15

                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)

                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)

                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.queryTable(DatabaseManager.java:221)

                at org.dspace.content.Community.findAllTop(Community.java:314)

                at org.dspace.app.webui.components.TopCommunitiesSiteProcessor.process(TopCommunitiesSiteProcessor.java:49)

                ... 29 more

 

 

helix84

unread,
Aug 26, 2015, 12:18:06 PM8/26/15
to Anthony Petryk, dspac...@lists.sourceforge.net
On Thu, Feb 6, 2014 at 5:54 PM, Anthony Petryk
<Anthony...@uottawa.ca> wrote:
> org.dspace.plugin.PluginException: ERROR: relation "community" does not
> exist

That means that DSpace cannot see the "community" table. Did you
configure DSpace to use the right database and schema? Perhaps you
have an empty database without tables lying around and you mistakenly
told DSpace to use that.

Try connecting to the same database that DSpace is configured to
connect to and send me the list of tables. (the "\dt" command in
psql). There should be around 50 tables there.


Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Anthony Petryk

unread,
Aug 26, 2015, 12:18:07 PM8/26/15
to hel...@centrum.sk, dspac...@lists.sourceforge.net
My mistake - I was pointing to the wrong database (I guess it helps to follow the instructions and edit build.properties!).

Thanks for your help.

Anthony

helix84

unread,
Aug 26, 2015, 12:18:09 PM8/26/15
to Anthony Petryk, dspac...@lists.sourceforge.net
On Thu, Feb 6, 2014 at 6:42 PM, Anthony Petryk
<Anthony...@uottawa.ca> wrote:
> My mistake - I was pointing to the wrong database (I guess it helps to follow the instructions and edit build.properties!).

I recommend against editing build.properties directly as they can be
overwritten (depends on your usage). You can copy build.properties to
local.properties, change that and then always use "mvn package
-Denv=local".
Reply all
Reply to author
Forward
0 new messages