We are upgrading from 9.0 to 10.0. QC 9.0 attachments are in Oracle Database V 10.3.0.4. QC 9.0 is throwing error while separating attachment from the Database due to duplicate records.

Below is the error:

Writer error
java.sql.SQLException: Failed SQL: /~~QC/ SELECT RP_PARENT_PATH,RP_NAME,RP_PATH_ID,RP_MODIFIED_TIME,LENGTH(RP_DATA) AS DATA_LENGTH,RP_DATA FROM (SELECT * FROM active_projects_test_pmu_symp_.REPOSITORY WHERE (RP_PARENT_PATH LIKE (SELECT RP_PARENT_PATH||TO_CHAR(RP_PATH_ID)||’/’||’%’ FROM active_projects_test_pmu_symp_.REPOSITORY WHERE RP_PARENT_PATH= (SELECT RP_PARENT_PATH||TO_CHAR(RP_PATH_ID)||’/’ FROM active_projects_test_pmu_symp_.REPOSITORY WHERE RP_PARENT_PATH=’0/’) AND LOWER(RP_NAME)=’tests’))) D ORDER BY RP_PARENT_PATH, RP_PATH_ID, RP_NAME
[Mercury][Oracle JDBC Driver][Oracle]ORA-01427: single-row subquery returns more than one row

Does anyone know how to extract the records and get beyond the error?