QC 9.0 is throwing error while separating attachment from the Database when upgrading from 9.0 to 10.0.

  • Questions
  • QC 9.0 is throwing error while separating attachment from the Database when upgrading from 9.0 to 10.0.
Question ID: 104308
0
0

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?

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on January 8, 2011 7:26 pm
6 views