Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
5.1.4, Xray DC V7.5.1
-
It happens in Oracle databases
-
Xray 2024 S4
-
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
- Use a Robot report that contains more than 1000 steps for one Test
- Import the Robot report with the execution results. A new Test and Test Execution should be created
- Do a new call to the Rest API Robot endpoint, to update the Test Execution created in the previous step
- Xray will try to remove the Test Run Results with more than 1000 values in the clause, which causes the error
Expected result
Execution results get updated