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

Database exceptions while calculating Requirement Statuses - getting Test Plan of Tests

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Done
    • None
    • R3.3.4
    • None
    • None
    • OK

    Description

      How to reproduce

      1. Setup your Jira project with very large issuenums. Big enough to overpass the Integer range
      2. Create a Test Plan
      3. Create a Test issue and associate it with the previous Test Plan
      4. Associate the Test issue to a Requirement issue. Now the Requirement issue is being covered by the Test issue
      5. In the Test Plan, Create a Test Execution for the Test issue

      If you check the logs you will see the below errors:

      Error parsing SQL query
      org.postgresql.util.PSQLException: Bad value for type int : 99900007527
      	at org.postgresql.jdbc.PgResultSet.toInt(PgResultSet.java:2826)
      	at org.postgresql.jdbc.PgResultSet.getInt(PgResultSet.java:2047)
      	at org.postgresql.jdbc.PgResultSet.getInt(PgResultSet.java:2482)
      	at org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:283)
      	at org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:283)
      	at com.xpandit.raven.util.MutualTestPlansUtil.lambda$getKeys$9(MutualTestPlansUtil.java:1022)
      

      Attachments

        Activity

          People

            dpca Diamantino Campos
            dmdu David Duarte
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 35 minutes
                35m