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>>'.

Environment

Release : 4.9 and 4.7

Component : CA Test Data Manager Web Portal

Cause

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

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.