TDM: Model Scan Error - Data discovery scan failed for Environment

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Doing a model scan and getting this error:

Environment

All supported TDM releases

Cause

Resolution

Issue resolved by increasing the size of the tablespace.

Additional Information

For the system requirements for how large to make the Repository, Refer to section "Database Requirements" in the version of TDM you are running.

The repository database and server also requires the following: 

Allow 5 GB of disk space for the repository database installation. Growth depends on the volume of test data that you store in the repository. Assume 5 GB to 20 GB in the first year.

For database access from a remote system, Oracle databases require an Oracle client with the TNSNAMES.ora file. All other database platforms require an ODBC driver software and system DSN entries.

This should be done on a regular basis:

1. Performance Optimization:

• Updating Statistics:

  .Opens in new tab

  Oracle relies on statistics to optimize query execution plans. Regularly updating statistics (using the DBMS_STATS package) is crucial, especially after significant data changes or updates.   

   
• Rebuilding Indexes:

  .Opens in new tab

  Indexes can become fragmented or inefficient over time. Rebuilding them can improve query performance.   

   
• Monitoring Resources:

  .Opens in new tab

  Regularly monitor CPU usage, memory consumption, and disk I/O to identify potential bottlenecks and ensure sufficient resources for the database.   

   
• Table Space Management:

  .Opens in new tab

  Monitor table space usage and fragmentation. Reorganizing tablespaces can help address fragmentation.