search cancel

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

book

Article ID: 187505

calendar_today

Updated On:

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


);


 

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.

Environment

Release : 4.7

Component : CA Test Data Manager

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.