TDM-Checksum fail with Oracle connection profile

Products

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

Issue/Introduction

I just created a new connection profile for an Oracle database but I cannot connect from the portal. The database is accessible from Datamaker and SQL Developer without this issue.

Testing the connection in the portal connection profile screen gives a "Failed to connect. See server logs for more details

TDMConnectionProfileManager.log - 

2020-02-10 12:18:22.072 PST [DEBUG] [https-jsse-nio-8443-exec-32] --- [U:CA_TDM_ADMIN][M:PUT][P:/api/ca/v1/connectionProfiles/TDMHUB_SHARED]                    c.c.t.c.c.ConProfileController:  RequestID: https-jsse-nio-8443-exec-32, Module: CONNECTION_PROFILE_MANAGER,POST /ca/v1/connectionProfiles/TDMHUB_SHARED

2020-02-10 12:18:22.074 PST [DEBUG] [https-jsse-nio-8443-exec-32] --- [U:CA_TDM_ADMIN][M:PUT][P:/api/ca/v1/connectionProfiles/TDMHUB_SHARED]                       c.c.t.c.s.ConProfileService:  RequestID: 2547, Module: CONNECTION_PROFILE_MANAGER,updateProfile

2020-02-10 12:18:22.087 PST [DEBUG] [https-jsse-nio-8443-exec-41] --- [U:CA_TDM_ADMIN][M:POST][P:/api/ca/v1/connectionProfiles/TDMHUB_SHARED/actions/validate]                    c.c.t.c.c.ConProfileController:  RequestID: 2859, Module: CONNECTION_PROFILE_MANAGER, POST /ca/v1/connectionProfiles/TDMHUB_SHARED/actions/validate

2020-02-10 12:18:22.087 PST [DEBUG] [https-jsse-nio-8443-exec-41] --- [U:CA_TDM_ADMIN][M:POST][P:/api/ca/v1/connectionProfiles/TDMHUB_SHARED/actions/validate]                       c.c.t.c.s.ConProfileService:  RequestID: 2859, Module: CONNECTION_PROFILE_MANAGER, validateConnection for user 1115 and profile TDMHUB_SHARED

2020-02-10 12:18:22.090 PST [DEBUG] [https-jsse-nio-8443-exec-41] --- [U:CA_TDM_ADMIN][M:POST][P:/api/ca/v1/connectionProfiles/TDMHUB_SHARED/actions/validate]                              o.s.j.c.JdbcTemplate:  Executing SQL query [SELECT count(*) FROM convalidatedummyrec]

2020-02-10 12:18:23.381 PST [ERROR] [https-jsse-nio-8443-exec-41] --- [U:CA_TDM_ADMIN][M:POST][P:/api/ca/v1/connectionProfiles/TDMHUB_SHARED/actions/validate]              c.c.t.c.e.h.GlobalExceptionConvertor:  HTTP Error - SERVICE UNAVAILABLE: StatementCallback; SQL [SELECT count(*) FROM convalidatedummyrec]; IO Error: Checksum fail; nested exception is java.sql.SQLRecoverableException: IO Error: Checksum fail

2020-02-10 12:18:23.389 PST [DEBUG] [https-jsse-nio-8443-exec-41] --- [U:CA_TDM_ADMIN][M:POST][P:/api/ca/v1/connectionProfiles/TDMHUB_SHARED/actions/validate]                     c.c.t.s.s.SecurityUserService:  Fetching repository clob to get the license info

A publish gives this - 

getDBConnection: Unable to connect to database jdbc:oracle:thin:@//qdfbp1.unix.gsm1900.org:1678/qdfbp1;user=SYNTHETIC_DATA : 

StatementCallback; SQL [SELECT count(*) FROM convalidatedummyrec]; IO Error: Checksum fail; nested exception is java.sql.SQLRecoverableException: IO Error: Checksum fail

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

We have a fix for this issue in TDM version 4.9.  Please make sure  the version of TDM you are using is 4.9 before applying the patch. 

TDMWeb-4.9.9.0.zip