TDM: F&R Not Null SQL Server columns and keys are causing can't reserve due to key

Products

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

Issue/Introduction

4.7.114 version.

The customer uses SQL Server as a data mart table. Only two columns are nullable and they aren't in the F&R Key. I think they use SQL Server bulk load libraries to populate it. If they don't update all these columns they get error due to key column being empty. I am wondering if MS puts in ascii 255 in the column?? 

update dbo.usdp_FINAL

set
CUST_NUM = ' '

where
CUST_NUM = ' ';

They load the table with this statement 

BULK INSERT
[dbo].[USDP_FINAL]

FROM '<<Drive Number>>:\<<DIR FOLDER>>\<<FILE_NAME>>.txt'

WITH

(

FIRSTROW = 1,

FIELDTERMINATOR = '|',

ROWTERMINATOR = '|\n',

ERRORFILE = '<<Drive Number>>:\<<DIR FOLDER>>\<<FILE_NAME>>_Error.csv',

TABLOCK

);

 

Environment

Release : 4.7

Component : CA Test Data Manager

Cause

We have identified that spaces are getting truncated while fetching data from source table and storing in the dvid tables created in gtrep, fixed the problem and created a build with the fix for 4.9.

Resolution

The Client was requested to upgrade to the 4.9 current release and apply the new patch TDMWeb-4.9.14.0.zip.  Please contact BC Support for the latest TDM Web Portal Patch for 4.9 GA.