Source Extractor - SQL PLSQL - Non Fatal Error - Extraction error - ORA-01427 single-row subquery returns more than one row

This page will help you to solve issues related to the below Extraction error message that occurs during PL/SQL extraction :

2017-12-11 07:50:40.036 - Extraction error: ORA-01427: single-row subquery returns more than one row

2017-12-11 07:50:50.411 - Extraction error: ORA-01427: single-row subquery returns more than one row

2017-12-11 07:51:00.785 - Extraction error: ORA-01427: single-row subquery returns more than one row

2017-12-11 07:51:11.190 - Extraction error: ORA-01427: single-row subquery returns more than one row

1. Configure the PL/SQL source Extractor
2. Run the extraction

1. In the extraction log file, on the top of the file, check if schema have been selected.
   Figure 2
2. If there are no schema indication , it means that all schema will be extracted.
3. In the extraction log file, check for the query for which the Extraction error has been raised:
   1. Search for the error message ORA-01427: single-row subquery returns more than one row:
   2. Just above this message, the extraction log file show the objects it is going to extract as the next screenshot.
   3. Just below this message, the log displays the query that is failing as shown in the below screenshot.
      
   4. In the above example, the type of object being extracted is Oracle table.
   5. In the query, check for which schema it is failing :
      1. In the query, search for the keyword : owner = '
         
         
      2. If the schema name is SYS you must list all the schema one by one without selecting the SYS schema
      3. If the schema is not SYS then this is a bug in the query.
4. If the above points do not help you, contact CAST Technical Support with the following Relevant Input.