FNR Model not populating dvid table when based on single table view

Products

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

Issue/Introduction

Created a view in the database in a database called ETO. Set up the Environment, ran the scan, and set it up as an On-Demand and nothing shows up and the DVID table is empty.

alter view dbo.newerCars as 
SELECT  top(10000)
  
      [make]
      ,[model]
      ,[ModelYear]
      
      ,[Vehicle_type]
      ,[Destination Market]
      ,[Plant Country]
      ,[Manufacturer Name]
   , [VIN]
      
  FROM [dbo].[CAN<Company>Resultsets]
where Vehicle_type ='Passenger Car' and ModelYear >=2017 and [Plant Country] in ( 'Canada','MEXICO','UNITED STATES (USA)') 

Environment

TDM Web Portal Build 4.9.437 repository is SQL Server 2012.

Component : Web Portal - Find & Reserve

Cause

Needed to add a primary key.

Resolution

Add a primary key to the underlying table and make it the model key.