ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

TDM: Data Model Issue, scanning more tables than needed

book

Article ID: 237272

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I have specified an inclusion list of 23 tables in the data model to scan and identify relationships while the schema contains over 47K tables. I would expect TDM Portal to scan only those 23 tables but instead it scanning the entire database which has already returned more than 76K tables and still continuing. I believe it is scanning the entire database.

The database is Oracle 19c and TDM Portal is 4.9.416.0

 

Cause

N/A

Environment

Release : 4.9.1

Component : Web Portal - Data Modeling

Resolution

There are two stages during Model scan:

Stage 1: to discover all tables and views present in the specific schema
stage 2: using the filter that only includes 23 tables  perform column, index, primary, physical relationship and logical discovery  

Stage 1 does NOT take long ... okish with 76K
stage 2 on the other hand will take time if the list is long. In this, there are 23 tables 

This particular schema has a lot of views, hence the high discovered objects.