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


Article ID: 237272


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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





Release : 4.9.1

Component : Web Portal - Data Modeling


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.