Table GTREP_PROJECT fields updated as NULL

Products

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

Issue/Introduction

Table GTREP_PROJECT which holds the information of the project created from TDM portal and it's details like who created the project, when it was created, etc. are getting update as null values.

Environment

All Supported releases of TDM

Component : Repository (GTREP)

Cause

The information stored as NULL in the GTREP_PROJECT table is working by design because that information is categorized as Audit data and is disabled by default. 

Resolution

There is an option to enable auditing from Datamaker, but it is NOT recommended as it will impact the performance of the product overall, specifically TDM Portal.

To enable auditing:

1. Launch GT Datamaker, and connect to the gtrep repository database
2. Connect to any Data Source, and ant Data Target
3. In the Datamaker UI. expand the Settings menu
4. Select the "Maintain Schemas" option
   
5. You will be required to reauthenticate to GT Datamaker
   
6. In the Maintain Connections dialog window, expand the CA Test Data Manager - Datamaker Test Data Repository connection
7. Select Create Audit Triggers
8. Press the Process button to generate the script for creating the audit triggers for the repository database.
   
9. Select either the option to execute the script from DM or copy it to execute directly on the GTREP DB server.

 

Note: Select "Drop Audit Triggers" option and executing the generated script to disable auditing.