Good morning,

my QC domain has 5 directories under “Subject” in the test plan. Archive, BSK, FI, FI-SP, SPK. For each of these folders I use the same SQL query to generate an Excel report. The SQL code is attached.

Generation works for all folders except FI-SP. When generating reports in FI-SP, the application hangs. There are fewer test cases in the folder itself than in the BSK folder, which can be generated error-free in just a few seconds. The query still works perfectly in the SQL editor, but I can't copy anything there.

I also look into the Excel log, but I can't find any errors there. The data center informed me that the DB connection always worked without errors during my attempts.

In addition, I tested some subfolders under FI-SP and was able to generate an Excel report, but only for a maximum of around 100 test cases. There are over 6000 in the BSK folder and that's it.

SELECT TEST.TS_TEST_ID AS "Test ID", TEST.TS_NAME AS "Testfall Name", TEST.TS_DESCRIPTION AS "Testfall Beschreibung", TEST.TS_RESPONSIBLE AS "Verantwortlicher", DESSTEPS.DS_STEP_NAME AS "Testschritt",  DESSTEPS.DS_DESCRIPTION AS "Testschritt Beschreibung", DESSTEPS.DS_EXPECTED AS "Erwartetes Ergebnis Testschritt", TEST.TS_STATUS AS "Status", TEST.TS_DEV_COMMENTS, TEST.TS_USER_03 AS "Testobjekt", TEST.TS_USER_02 AS "Kategorie", TEST.TS_TYPE, TEST.TS_CREATION_DATE AS Datum, TEST.TS_EXEC_STATUS, ALL_LISTS.AL_DESCRIPTION as "Name",

PTH as "Path"

FROM ALL_LISTS

INNER JOIN Test ON TEST.TS_SUBJECT = ALL_LISTS.AL_ITEM_ID

FULL OUTER JOIN DESSTEPS On DESSTEPS.DS_TEST_ID = TEST.TS_TEST_ID,

(SELECT sys_connect_by_path ( AL_DESCRIPTION, '\\') PTH, AL_ITEM_ID TID

FROM ALL_LISTS CONNECT BY prior AL_ITEM_ID = AL_FATHER_ID

start WITH AL_ITEM_ID = 2) /*2 is Subject folder*/

WHERE TID = AL_ITEM_ID AND PTH LIKE '%Subject\\FI-SP\\AT%'