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

Import execution results (Robot format) throws an SQL exception in Oracle databases

    XporterXMLWordPrintable

Details

    • Xray 2024 S4
    • OK

    Description

      Description
      When updating the execution results (Robot format) to an existing Test Execution, if the Test has more than 1000 robot "steps", when trying to update/remove the Test run results, an SQL error is thrown, due to an Oracle limitation (ORA-01795)

      Pre-conditions
      Jira uses an Oracle database

      How to reproduce

      1. Use a Robot report that contains more than 1000 steps for one Test
      2. Import the Robot report with the execution results. A new Test and Test Execution should be created
      3. Do a new call to the Rest API Robot endpoint, to update the Test Execution created in the previous step
      4. Xray will try to remove the Test Run Results with more than 1000 values in the clause, which causes the error

      Actual result/Attachments

      Expected result
      Execution results get updated

      Attachments

        1. image-2021-11-10-10-30-08-574.png
          158 kB
          Miguel Fernandes
        2. image-2021-11-10-10-34-02-083.png
          75 kB
          Miguel Fernandes

        Activity

          People

            patricia.mateo Patricia Mateo
            maaf Miguel Fernandes
            António Rodrigues, Patricia Mateo
            Votes:
            5 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: