Hi, I upgraded recently from dspace 1.5.2 to dspace 1.7.1 -- I went through
a 2-phases upgrade, from 1.5.x to 1.6.x and then from 1.6.x to 1.7.x
It worked fine with me but when I tried the item mapper I got the error:
[error details below]
org.dspace.browse.BrowseDAOPostgres @ caught exception:
org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does not
exist
I was searching for the cause of this error when I came through this:
http://www.mail-archive.com/dspace-tech@lists.sourceforge.net/msg11125.html
so I deleted the tables that start with bi_ and tried generating the browse
and search indexes, yet I get the following error, the tables are created
with the authority column not containing any values. As a result, the search
stopped working. Your help is highly appreciated.
E:\dspace\bin>dspace index-init
Using DSpace installation in: E:\dspace
Started: 1308578975296
Ended: 1308578990093
Elapsed time: 14 secs (14797 msecs)
Exception: null
java.lang.NullPointerException
at
org.apache.lucene.index.DocumentsWriter.addDeleteTerm(DocumentsWriter
.java:1113)
at
org.apache.lucene.index.DocumentsWriter.getThreadState(DocumentsWrite
r.java:765)
at
org.apache.lucene.index.DocumentsWriter.updateDocument(DocumentsWrite
r.java:816)
at
org.apache.lucene.index.DocumentsWriter.updateDocument(DocumentsWrite
r.java:809)
at
org.apache.lucene.index.IndexWriter.updateDocument(IndexWriter.java:2
683)
at
org.apache.lucene.index.IndexWriter.updateDocument(IndexWriter.java:2
655)
at
org.dspace.search.DSIndexer.executeIndexingTask(DSIndexer.java:742)
at
org.dspace.search.DSIndexer.flushIndexingTaskQueue(DSIndexer.java:799
)
at
org.dspace.search.DSIndexer.flushIndexingTaskQueue(DSIndexer.java:770
)
at
org.dspace.search.DSIndexer.setBatchProcessingMode(DSIndexer.java:233
)
at org.dspace.search.DSIndexer.main(DSIndexer.java:489)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183)
Thanks a lot,
Asmaa
*
*
*[org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does
not exist]*
-----------------------------------------------------------------------------------------------------------------------------------------------
org.dspace.browse.BrowseDAOPostgres @ caught exception:
org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does not
exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
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.query(DatabaseManager.java:284)
at
org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:153)
at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:752)
at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:712)
at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:264)
at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:100)
at
org.dspace.app.webui.servlet.admin.ItemMapServlet.doDSPost(ItemMapServlet.java:295)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)
at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)
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:240)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:395)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:306)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:323)
at
org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1719)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2011-06-20 14:40:52,274 ERROR
org.dspace.app.webui.servlet.admin.ItemMapServlet @ caught exception:
org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR:
column bi_2_dis.authority does not exist
at
org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:168)
at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:752)
at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:712)
at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:264)
at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:100)
at
org.dspace.app.webui.servlet.admin.ItemMapServlet.doDSPost(ItemMapServlet.java:295)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)
at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)
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:240)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:395)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:306)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:323)
at
org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1719)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: column
bi_2_dis.authority does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
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.query(DatabaseManager.java:284)
at
org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:153)
... 31 more
2011-06-20 14:40:52,274 WARN
org.dspace.app.webui.servlet.InternalErrorServlet @
:session_id=75668369586AD839E131A8A188E757FE:internal_error:-- URL Was:
http://10.2.1.87/jspui/tools/itemmap
-- Method: POST
-- Parameters were:
-- action: "Search Authors"
-- cid: "1"
-- namepart: "shalaan"
javax.servlet.ServletException: org.dspace.browse.BrowseException:
org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does not
exist
at
org.dspace.app.webui.servlet.admin.ItemMapServlet.doDSPost(ItemMapServlet.java:333)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)
at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)
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:240)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:395)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:306)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:323)
at
org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1719)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.dspace.browse.BrowseException:
org.postgresql.util.PSQLException: ERROR: column bi_2_dis.authority does not
exist
at
org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:168)
at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:752)
at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:712)
at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:264)
at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:100)
at
org.dspace.app.webui.servlet.admin.ItemMapServlet.doDSPost(ItemMapServlet.java:295)
... 26 more
Caused by: org.postgresql.util.PSQLException: ERROR: column
bi_2_dis.authority does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
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.query(DatabaseManager.java:284)
at
org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:153)
... 31 more
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
