Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-3774

Search results page fails to render for EyeQL queries > 4000 characters on Oracle.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Medium
    • 2.7.5
    • 2.7.4
    • Search
    • None

    Description

      When using an EyeQL query longer than 4000 characters, the search results page fails to render for users with an Oracle database. The logs show the following error message:

      avax.servlet.jsp.JspException: javax.el.ELException: Problems calling function 'cru:getStar'
              at org.apache.jsp.tag.web.cru.star.star_tag.doTag(star_tag.java:334)
              at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp._jspx_meth_star_star_0(searchresults_jsp.java:1227)
              at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp._jspx_meth_c_if_3(searchresults_jsp.java:1197)
              at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp.access$1200(searchresults_jsp.java:7)
              at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp$searchresults_jspHelper.invoke7(searchresults_jsp.java:1607)
              at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp$searchresults_jspHelper.invoke(searchresults_jsp.java:1674)
              at org.apache.jsp.tag.web.cru.threePanelPageContent_tag._jspx_meth_c_if_36(threePanelPageContent_tag.java:1920)
              at org.apache.jsp.tag.web.cru.threePanelPageContent_tag.doTag(threePanelPageContent_tag.java:604)
              at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp._jspx_meth_rend_threePanelPageContent_0(searchresults_jsp.java:625)
              at org.apache.jsp.WEB_002dINF.jsp.search.searchresults_jsp._jspService(searchresults_jsp.java:193)
              at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
              at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
      ....
      
      Caused by: org.hibernate.QueryTimeoutException: could not execute query
              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
              at org.hibernate.loader.Loader.doList(Loader.java:2452)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
              at org.hibernate.loader.Loader.list(Loader.java:2187)
      ....
      Caused by: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested
      
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
      ...
      

      Attachments

        Activity

          People

            mheemskerk Michael Heemskerk (Inactive)
            mheemskerk Michael Heemskerk (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 11m
                11m