Error Tying to Register Advanced File Layout from G-T Text File in DataMaker: String or binary data would be truncated.

Products

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

Issue/Introduction

Rebuilding projects for extracting mainframe data in a GTREP database.

After using File Definition Manager to create an output file, attempting to register that file in Data Maker returns the following error.

insert into gtrep_layout_def

Title: Test Data Repository

Database Error Message: SQLSTATE = 22001
Microsoft OLE DB Driver for SQL Server
String or binary data would be truncated.

Transaction Error Code: -1
Database Error Code: 8152

CA Test Data Manager - Datamaker Details

GUI Version: 4.10.1001.0(Runtime: 22.0.0.1900) (7/2/2023 13:48:30)
REP Version: 4.10.0.16

Transaction Details:

PB DBMS driver: MSOLEDBQL SQL Server
Server DBMS: SQL Server (sql server)
Server Version: 12.00.6449
Current System: <servername>\<instance name>
Current Database: GTREP
Database: 
Login ID: gtrep
DBParm: Database='GTREP',DelimitIdentifier=0,DisableBind=0,AppName='CA Test Data Manager - Datamaker'
ServerName: <servername>\<instance name>
AutoCommit: false

ii_identifier_case = 3
ib_current_schema_only = false
ib_db2 = false
ib_db2_400 = false
ib_extra_fkeys = false
ib_fkey_capable = true
ib_new_fkeys = false
ib_pkey_capable = true
ib_single_schema = false
ib_unicode = true
ib_user_views = false

Environment

CA File Definition Manager (6.0.1-SNAPSHOT, 2020-09-10 07:40) or later

The DataMaker version is: GUI Version: 4.10.1001.0 or later

GTREP is SQL Server

Cause

The lod_name column in gtrep_layout_def table is only 30 characters wide so either need to increase its size (which involves changing table schema in the repository) or need to make LOGICALFILE shorter in the file - so for example LOGICALFILE=TDMDDA_X71088C_May24_changes (instead of LOGICALFILE=TDMDDA_X71088C_May24_changes(INTG)).

Resolution

Setting the length of the lod_name column in gtrep_layout_def to 254 fixed the problem.