Source Extractor - SQL PLSQL - Extraction step

This page provides the approach to troubleshoot the extraction issues you can experience while running the SQL PLSQL extractors.Source Extractors

1. In the extraction log file, if there are messages prefixed by Extraction error like below screenshot, this is a Fatal error message:
   
2. If there is messages prefixed by Resolution error type, this is a non fatal error message:
   
3. If you get an ORA-31603 during an extraction, this generally means that you don't not have proper permissions.  Use the User who has created the schema or the SYSTEM user with full privileges for the extraction
4. Navigate to the below pages :
   
   • Source Extractor - SQL PLSQL - Error - IO exception Socket read timed out
   • Source Extractor - SQL PLSQL - Error - No more data to read from socket
   • Source Extractor - SQL PLSQL - Error - Resolution error type in CAST_AST_XXX for identification group
   • Source Extractor - SQL PLSQL - Extraction step - Performance issue
   • Source Extractor - SQL PLSQL - Fatal Error - Error in options Extraction - driver oracle jdbc OracleDriver - url
   • Source Extractor - SQL PLSQL - Fatal Error - java.lang.ArrayIndexOutOfBoundsException
   • Source Extractor - SQL PLSQL - Fatal Error - java.lang.NegativeArraySizeException
   • Source Extractor - SQL PLSQL - Fatal Error - Validation error -1 Schema your database to extract is missing
   • Source Extractor - SQL PLSQL - Non Fatal Error - Extraction terminated with x errors, including 0 fatal errors
5. If you do not find the information you are looking for or solution for your problem, contact CAST Technical Support and provide the relevant input to help CAST Support team investigate your problem or procure the required information.