Uploaded image for project: 'Xray for Jira'
  1. Xray for Jira
  2. XRAY-1260

In Oracle Databases, in "Gadget Historical Gadget", with projects with more than 1000 tests no results are shown

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • R2.0.8
    • R2.0.9
    • Core, Database, Gadget
    • None
    • R2.1.0 S3
    • OK

    Description

      There is an exception:

      Log throws (which shows that there could be a query issue):
      2017-01-30 11:37:27,013 ajp-nio-8009-exec-3 ERROR aleh 696x3167084x10 1o51hcy 192.168.221.111,195.13.40.243 /rest/raven/1.0/chart/requirement/historic [c.x.r.service.impl.DefaultRequirementChartDataProvider] Error occurred when generating data bean for the historic requirements chart.
      com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
      name:Oracle
      version:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
      Advanced Analytics and Real Application Testing options
      minor version:1
      major version:12
      Driver:
      name:Oracle JDBC driver
      version:12.1.0.2.0
      java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

      Attachments

        Activity

          People

            bmpc Bruno Conde
            dpca Diamantino Campos
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 4 hours
                4h
                Remaining:
                Remaining Estimate - 4 hours
                4h
                Logged:
                Time Spent - Not Specified
                Not Specified