search cancel

Primary key not seen for find and reserve new model 4.9 release testing

book

Article ID: 187635

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

    I have a table called Customer in one of my database. This table was preexisting without a Primary key  defined. So I went ahead and created one on ID column. Then I first re-registered it and  F&R still doesn't see it. so I unregistered it and still it is having problem. I am going to test if I drop the environment and start fresh. Getting below error when I do find and reserve.

    Table Customer has no Primary Key. Root table must have a Primary Key when data prefetch is OFF.

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

After I ran the model scan it sees the Primary key. For new model removing the table (object) is not enough when adding a primary key. You have to rerun the data model scan.