Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-3649

no longer can select eperson after upgrade to 5.6

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Volunteer Needed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.6
    • Fix Version/s: None
    • Component/s: JSPUI
    • Labels:
      None
    • Environment:
      Linux SLES11, Oracle12g, java7, tomcat7.0.64, DSpace 5.6
    • Attachments:
      3
    • Comments:
      13
    • Documentation Status:
      Needed

      Description

      After upgrading our DSpace 5.4 server to DSpace 5.6 we no longer can select epersons. Activating the button at /tools/eperson-list?multiple=true throws a database error.

      Exception:

      java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB

       

                   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

                   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

                   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

                   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

                   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

                   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

                   at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)

                   at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)

                   at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)

                   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)

                   at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)

                   at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)

                   at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)

                   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:295)

                   at org.dspace.eperson.EPerson.findAll(EPerson.java:518)

                   at org.dspace.app.webui.servlet.admin.EPersonListServlet.doDSGet(EPersonListServlet.java:91)

                   at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:119)

                   at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:67)

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

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

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

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

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

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

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

                   at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                fbr Francis Brouns
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: