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. Except for FI-SP, generation works for all folders. When generating the report in FI-SP, the application hangs. There are fewer test cases in the folder itself than in the BSK folder, which can be generated without errors in a few seconds. The query still works perfectly in the SQL editor, but I can't copy anything there. I also attached the Excel log, but I can't find any errors there. The data center said that the DB connection was always error-free 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 roundabout 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%'