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%'