Description
 This page will help you troubleshoot the following problem for Oracle DB extraction, while extracting database DMT is running from long time and the extraction not getting completed.
Observed in CAST AIP
Release
Yes/No
8.0.x(tick) 
7.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
Step by Step Scenario
  1. Open DMT.
  2. Do the extraction of Oracle DB.
Action Plan

This is a known issue, the Oracle extraction is so huge, that it will never finish. To unblock the situation

  1. Use the offline database extractor GUI/CLI (basically using the CAST-DatabaseExtractor.jar) to extract the oracle data. Please refer the documentation link to download the offline extractor and to gain information about how to use it: CAST Database Extractor
  2. Once the files are extracted, then you can deliver them directly through DMT (Reuse existing CAST extractor output in DMT).

Figure 1

Impact on Analysis Results and Dashboard

Impact of issue: Oracle DB source code not extracted.

Impact after applying solution: Oracle DB source code is extracted.

Notes/comments

 Ticket # 6049

Related Pages