search cancel

TDM Portal: Which gtrep database tables are used for recording a reservation

book

Article ID: 223913

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Which gtrep database tables are used for recording a reservation. 

Environment

Release : 4.9

Component : Web Portal - Find & Reserve

Resolution

The main table in the gtrep database that has the userid, start date, end date, project and version is test_data_reservation.
The objects that are reserved are stored in the gtrep table test_data_reservation_lob
In test_data_reservation_lob there is one record for all objects reserved in the reservation.
If Data Prefetch is set to off, there is also a table <column>_reservations in the same database that has the data.
For example dept_reservation if the main column for the reservation is dept.
It has one record for each dept key that has a reservation.

Additional Information

In Find & Reserve confirm that there is a model available in the project being used.
The 'version' of the model should be 'new' and not 'legacy' for the reservation tables in gtrep to be used. 
The tables defined in the model content should have a primary key for good performance when making a reservation.