[XRAY-4772] Test Repository with more than one thousand of folders is not showing correctly the number of Tests of each folder - Xblend Issue Tracker

Xporter

XML

Word

Printable

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Duplicate
Affects Version/s: R3.5.3
Fix Version/s: 3.6.3
Component/s: Database, Hierarchical
Labels:
None

Requirement Status:

UNCOVERED

Description

If a Test Repository has a folder structure with more than 1000 folders, an SQL Exception is thrown due to Oracle database limit. Due that, the folders are showing 0(0) tests associated, even if they have Tests on the current folder or child folder.
This behaviour is only verified on Oracle databases.

Pre-Condition

Jira using an Oracle database

Steps to reproduce

Step	Result
Create a folder structure with more than 1000 folders and move one Test to one folder

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

image-2019-12-04-15-21-52-291.png
78 kB
04/Dec/19 3:21 PM
SUPPORT-18164.gif
2.46 MB
04/Dec/19 3:36 PM

Issue Links

is duplicated by

XRAY-5102 SQL error in oracle databases due to 1000 element limit on "IN" clauses

Resolved

relates to

XRAY-5102 SQL error in oracle databases due to 1000 element limit on "IN" clauses

Resolved

Activity

People

Assignee:: Hugo Braz [X] (Inactive)

Reporter:: Miguel Fernandes

Votes:: 2 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 04/Dec/19 3:23 PM

Updated:: 15/Jun/21 12:04 PM

Resolved:: 27/Feb/20 12:53 PM

Time Tracking

Estimated:

Not Specified

Remaining:

Logged: