TDM 4.9 DB2 : JAVA error with CHAR column supplied with blanks and using parameter 'LARGETABLESPLITENABLED=Y'

Products

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

Issue/Introduction

2020-11-01 16:50:16.015 Thread:2 - Error executing select statement for update
2020-11-01 16:50:16.015 Error Executing Batch
com.ibm.db2.jcc.am.SqlException: [jcc][10271][10295][4.24.92] Unrecognized JDBC type: 0. ERRORCODE=-4228, SQLSTATE=null

The commonality between these 5 tables is a CHAR column that must be masked but that the data contains empty values (SPACE).

TCAEF - NUM_CESS_CREA CHARACTER(6) NOT NULL,
TFIDTEI - NUM_INTV_TRSF CHARACTER(8) NOT NULL,
TCET - NUM_CERT_EPAT CHARACTER(9) NOT NULL,
TPOPL - COD_DIVI_SDIV_RECE CHARACTER(5) NOT NULL
TPORP - COD_USAG_WEB_CNSE CHARACTER(12)
        - COD_USAG_WEB_GEST CHARACTER(12)

 The error only occurs when FDM splits the table by thread.

So as a workaround we must change the parameter LARGETABLESPLITENABLED to N.

LARGETABLESPLITENABLED=N

The flip side of the coin is that the tables will mask in single thread only. The masking will be longer.

TCAEF - 1 959 025
TFIDTEI - 34 095 109
TCET - 101 911 333
TPOPL - 584 442
TPORP - 1 753

Environment

This has been addressed in later versions of 4.9 releases.

Download and install the latest patch from TDM patches link given below to fix this issue.

https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649

Resolution

 FastDataMasker 4.9.52 or higher should have the fix.