ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Getting Error while masking Teradata tables through FDM

book

Article ID: 186505

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to mask few Teradata Tables using FastDataMasker but its throwing error:
([Teradata Database] [TeraJDBC xx.xx.xx.xx] [Error 3510] [SQLState 25000] Too many END TRANSACTION statements. ) .

Can you please look at the issue ?

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

According to the TDM Documentation, under the Installation - Supported Data Sources, there is a matrix showing what functionality is and isn't supported for the supported data sources. Looking at the Teradata matrix we see Data Masking through FDM is not supported for Teradata databases.

Databases Dynamic Test Data Reservation Data Generation Data Masking Data Subsettig Test Match Virtual Test Data Management Data Modeling and PII Audit  Distributed with Driver Notes
TDM Portal TDM Portal Datamaker TDM Portal Fast Data Masker Datamaker GT SubSet
Teradata 15.10 Not Supported Certified Certified Not Supported Not Supported Certified
See Notes
Certified Not Supported Not Supported Not Supported No If you create a Teradata connection profile in CA TDM Portal, and you publish from Datamaker using this connection profile (the Enterprise or Remote Enterprise publish option), then only the Teradata ODBC driver is supported.
Download the files terajdbc4.jar and tdgssconfig.jar from the vendor and place it in the following folder:
 C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\
When using the JDBC driver to create a connection profile in the CA TDM Portal, grant the Teradata user the following additional permissions:
 GRANT Select ON "UDTInfo" TO "<username>";
Teradata 16.10 Not Supported Supported Certified Not Supported Not Supported Certified
See Notes
Certified Not Supported Not Supported Not Supported No
Teradata 16.20 Not Supported Supported Supported Not Supported Not Supported Certified
See Notes
Supported Not Supported Not Supported Not Supported No

Additional Information

Supported Data Sources - https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/continuous-testing/test-data-management/4-8-1/installing/supported-data-sources/notes-on-implementation-with-specific-data-sources.html#concept.dita_1dcf72d4deca5c21cf3a2704f77ddf29624ee21f_teradatateradata1510teradata1610teradata1620