Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Incomplete
    • Affects Version/s: 1.6.2
    • Fix Version/s: None
    • Component/s: DSpace API
    • Labels:
      None
    • Environment:
      Postgresql 9.0.2, O/S= AIX 5.3, Tomcat 6
    • Attachments:
      0
    • Comments:
      2
    • Documentation Status:
      Not Required

      Description

      Certain types of searches arrive to the server from the outside world cause a java servlet error as if there is an indexing bug. See Example:

      An internal server error occurred on http://digital.maag.ysu.edu:8080/xmlui:

      Date: 1/27/11 3:25 PM
      Session ID: 9CCB2524370765356AEBFC84030B3493
      User: Anonymous
      IP address: 66.249.71.110

      – URL Was: http://digital.maag.ysu.edu:8080/jspui/browse?type=title&order=ASC&rpp=20&value=Nationally-renowned+educator+named+accounting+chair
      – Method: GET
      – Parameters were:
      – value: "Nationally-renowned educator named accounting chair"
      – rpp: "20"
      – type: "title"
      – order: "ASC"

      Exception:
      javax.servlet.ServletException: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation "bi_3_dmap" does not exist
      Position: 79
      at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:371)
      at org.dspace.app.webui.servlet.BrowserServlet.doDSGet(BrowserServlet.java:112)
      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:617)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Thread.java:735)
      Caused by: org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: relation "bi_3_dmap" does not exist
      Position: 79
      at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:196)
      at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:791)
      at org.dspace.browse.BrowseEngine.getTotalResults(BrowseEngine.java:751)
      at org.dspace.browse.BrowseEngine.browseByItem(BrowseEngine.java:296)
      at org.dspace.browse.BrowseEngine.browse(BrowseEngine.java:132)
      at org.dspace.app.webui.servlet.AbstractBrowserServlet.processBrowse(AbstractBrowserServlet.java:342)
      ... 20 more
      Caused by: org.postgresql.util.PSQLException: ERROR: relation "bi_3_dmap" does not exist
      Position: 79
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
      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:93)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
      at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:291)
      at org.dspace.browse.BrowseDAOPostgres.doCountQuery(BrowseDAOPostgres.java:181)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jtrimble Jeffrey Trimble
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: