Unable to register PostgreSQL tables in TDM Portal

Products

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

Issue/Introduction

While attempting to register PostgreSQL tables in TDM Portal, for a Data Model, that was created, we are seeing the following error in the TDMModelService.log:

[WARN ] [https-openssl-nio-8443-exec-11] --- [U:Administrator][M:POST][P:/api/ca/v1/datamodel/tables]                      o.h.e.j.s.SqlExceptionHelper:  SQL Error: 8152, SQLState: 22001

[ERROR] [https-openssl-nio-8443-exec-11] --- [U:Administrator][M:POST][P:/api/ca/v1/datamodel/tables]                      o.h.e.j.s.SqlExceptionHelper:  String or binary data would be truncated.

[ERROR] [https-openssl-nio-8443-exec-11] --- [U:Administrator][M:POST][P:/api/ca/v1/datamodel/tables]              c.c.t.c.e.h.GlobalExceptionConvertor:  HTTP Error - INTERNAL SERVER ERROR: Exception: could not execute statement [String or binary data would be truncated.] [insert into gtrep_table_ind_def]

Environment

TDM Portal 4.11

Cause

The problem is that PostgreSQL can use expressions as column names, and these can get much longer than the defined 254 characters available for the column in the gtrep_table_ind_def table.

Resolution

The fix has been provided in TDMWeb-4.11.4013.0, which is available for downloaded from the Test Data Manager (TDM) Support Patches page.

Additional Information

 How to apply TDM Patches