Find and Reserve Model is not returning the expected results in TDM Portal 4.9.1
search cancel

Find and Reserve Model is not returning the expected results in TDM Portal 4.9.1

book

Article ID: 219961

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I have 2 tables that I want to join using a common column and create a find and reserve tile from those 2 tables (a View and Table in a DB2 schema). I created a relationship between the 2 tables in the Data Model section. Then created a Find and Reserve model by selecting required columns from these 2 tables. I am unable to get the matching records from both these tables when I execute the tile. However, when I run the SQL query I am getting the expected results.

 

Environment

Release : 4.9 and above

Component : CA Test Data Manager - TDM Web Portal

Cause

The behavior for the Find & Reserve tile is dependent on how the Data Model is configured. In TDM Portal 4.9.1 there are three options for configuring the Data Prefetch.

  • Periodic, where you schedule the frequency that the Find & Reserve Data Model queries the tables to update the Find & Reserve Data Reservation Tables that are cached in the gtrep repository database.
  • On Demand, where the Reservation tables are not scheduled and must be synchronized with the source tables manually.
  • OFF, where the Find & Reserve Data Model only queries the source tables, and we do not cache the  Reservation tables in gtrep.

Resolution

To troubleshoot the behavior, we should check the gtrep repository to see what is seen in the tables.

The Tables we check are:

  • dbo.data_view – when we query this table we verified that the source table and source view are located in this table. Once the Source objects are found, we need to get the IDs.
    • For example: there are two tables associated with the two IDs of interest:
      • dvid_fb0526ca49f04371ab20e8507
      • dvid_3c265e07a74a4e638a860d409
    • We queried these two tables to see if they contain values. As a test, we replaced the "View" name and "Table" name, we used the dvid tables, and the results are empty.

Further investigation of the gtrep revealed that the cached tables, inside the gtrep, are not been synchronized with the source "View" and source "Table". This is why the Find & Reserve is not returning the expected results. By default, Find & Reserve does not use Inner Join; we use Outer Join. The cache tables, in gtrep, are used to track the data reservations.

To correct this, we need to go to TDM Portal -> Data Model in F&R, and click on Actions – Fetch data. This will query the source tables (Table & View) and update the cached tables in gtrep. Another option is to change the F&R Data Model’s configuration to use a periodic update, say once a day, or once a week. The frequency depends on the customer’s need.

Another option is to turn off the caching, which will cause F&R to always query the Source tables each time the job is run. If using the source table, we will create a table in the schema of your choice to store the reservation IDs. The account used by F&R will need the privileges to create a table in the schema selected. This is done in the F&R model by setting the Data Prefetch to OFF.

The Data Prefetch actions are logged in the C:\ProgramData\CA\CA Test Data Manager Portal\logs\TDMFindReserve.log

Additional Information

Powered by Wolken Software