This page provides the approach to troubleshoot the issues encountered while running SQL PLSQL extractors:

Source Extractor is a Component of CAST AIP that will help you Extract your Source code and help you analyze them using CAST.

Database Source extractors are meant for the version which they have been delivered. For example, if you are using CAST 8.3.5, then you should use the extractor that comes with 8.3.5. If you are using CAST 8.3.47, then you should use the extractor that comes with 8.3.47. If there is some extraordinary reason you are mixing versions of extractors and CAST versions and having problems, then please contact support with the reason for this and the error: CAST Technical Support.

For more information, refer to:

*Observed in CAST AIP
*Observed on RDBMS
Oracle Server(tick)
Action Plan

The Oracle SQL Extractor uses JDBC Driver with Oracle Thin driver.

It requires no software other than JAVA and the driver jar file (it is embedded in the Extractor). This driver connects to Oracle databases via TCP/IP. 

During the PL/SQL extraction, the source code extractor will run a set of queries that will export all the SQL objects requested for the PL/SQL analyzer. 

  1. Open the Source extractor log file:
    1. If the Source extractor is a standalone extractor, it is generating its own log file. Open this log file using NotePad++
    2. If the Source extractor is in DMT, open the extraction.CastLog2 using the CastLog2Viewer.exe that is in <CAST INSTALLATION FOLDER>/DeliveryManagerTool Folder
  2. Identify in the source code extractor log file what is the step of the extraction :
    The 2 first lines are the connection step.
    From the third line, the one starting with Vendor: Oracle, it is the extraction step.

  3. Navigate to the step where the issue occured
  4. 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.

Related Pages