TD: After 4.9 upgrade TDOD doesn't start

Products

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

Issue/Introduction

I verified the user and even tried my own in the config editor and the database connection isn't working. I am attaching Procmon log from last night.

 

2020-03-31 09:59:51,677 [4] INFO  GTWCFHost.GTWCFHost - Connection Details

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - Data Source=<<DataSource>>.com,<<PORT>>

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - User ID=<<USER_ID>>.com\<<TEST_DB>>

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - Initial Catalog=gtrep

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - Connection Lifetime=60

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - Min Pool Size=1

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - Network Library=<<NETWORK_LIB>>

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - Application Name=GT TDoD Service

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - Connection Provider: System.Data.SqlClient

2020-03-31 09:59:51,724 [4] INFO  GTWCFHost.GTWCFHost - Validating database connection

2020-03-31 09:59:51,724 [4] FATAL GTWCFHost.GTWCFHost - Exception occurred while validating database connection

2020-03-31 09:59:51,724 [4] FATAL GTWCFHost.GTWCFHost - Exception: Login failed for user '<<USER_ID>>.com\<<TEST_DB>>'.

2020-03-31 09:59:51,724 [4] FATAL GTWCFHost.GTWCFHost - Exception occurred while opening service host connection

2020-03-31 09:59:51,724 [4] FATAL GTWCFHost.GTWCFHost - Exception: Login failed for user '<<USER_ID>>.com\<<TEST_DB>>'.

Cause

Spaces in Column values from the source table are trimmed while saving in dvid table in gtrep

Environment

Release : 4.9 and 4.7

Component : CA Test Data Manager Web Portal

Resolution

This has been resolved for both 4.9 - TDMWeb-4.9.14.0.zip and 4.7 - TDMWeb-4.7.128.0.zip.  Please contact BC Support for the fix to this issue.