TDM Find and Reserve : DB2 are not compatible with the SQL server database like Timestamp columns

book

Article ID: 197835

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Seeing Data compatibility issues in Find and Reserve.
Some of the datatypes  in DB2 are not compatible with the SQL server database . Hence, the find forms do not replicate the data as it is in the DB2 Z tables .

Example – Timestamp columns 

The data is not copied as expected into the SQL server DB2 database . The nano seconds at the end are not being populated , It gives incorrect data copied to SQL server GTREP. There is no manual intervention what so ever in this process and we did drop the model couple of times and rebuilt the prefect table in SQL server .

Here are the sample records :

 

2019-12-10-00.04.39.188118

2019-11-21-23.50.14.894647

2019-12-10-23.47.40.316428

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

 

File Name: TDMWeb-4.9.88.0.zip  has the fix.