TDM: ERROR String or binary data would be truncated trying to save MongoDB connection "

Products

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

Issue/Introduction

When we try to save a MongoDB connection, the error shown in the image below occurs:

[ERROR] [https-jsse-nio-8443-exec-883] --- [U:Administrator][M:POST][P:/api/ca/v1/connectionProfiles]                      o.h.e.j.s.SqlExceptionHelper:  String or binary data would be truncated.
2025-06-05 18:08:38.965 UTC [DEBUG] [https-jsse-nio-8443-exec-849] --- [U:Administrator][M:POST]

errorMsg: "could not execute statement [String or binary data would be truncated.] [insert into gtrep_profile  (authentication_document,authentication_type,client_email,client_id,date_created,date_updated,max_number_of_masking_tasks,private_key_id,prof_connectiontype,prof_database,prof_db_dbms,prof_dbms,prof_dbparm,prof_desc,prof_last_used_date,prof_password,prof_schema,prof_servername,prof_sg_id,prof_store_password,prof_userid,program_created,program_updated,project_id,who_created,who_updated,prof_name,prof_su_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; SQL [insert into gtrep_profile (authentication_document,authentication_type,client_email,client_id,date_created,date_updated,max_number_of_masking_tasks,private_key_id,prof_connectiontype,prof_database,prof_db_dbms,prof_dbms,prof_dbparm,prof_desc,prof_last_used_date,prof_password,prof_schema,prof_servername,prof_sg_id,prof_store_password,prof_userid,program_created,program_updated,project_id,who_created,who_updated,prof_name,prof_su_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]"

Environment

All Supported versions of TDM

Cause

The issue is the password column limit. it means password in clear text should not be larger than 80 characters
when encrypted and encoded it goes to 236 characters

When using  using block encryption, increasing password length by one character could cause much bigger increase in length of the stored value (around 10-11 characters).

!!!!!!!!VerySecret123456789!!!!!!!!!!!!!!!!VerySecret123456789!!!!!!!!0123456789

Resolution

Please use password length much less than 80 characters.