TDM Portal fails to save Masking Configuration for DB2 scramble database

Products

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

Issue/Introduction

While trying to configure TDM Portal 4.10.256.0 Masking configuration to use Seedlists for DB2 scramble database, we are seeing the following error:

Failed to save DB Seedlist Configuration. 500: Server encountered an error processing the request.

We see this in the TDMWeb.log:

2024-04-19 15:55:14.184 GMT [ERROR] [https-openssl-nio-8443-exec-4] --- [U:Administrator][M:POST][P:/api/ca/v1/settings/dbseedlist]              c.c.t.c.e.h.GlobalExceptionConvertor:  HTTP Error - INTERNAL SERVER ERROR: Exception: Handler dispatch failed; nested exception is java.lang.AbstractMethodError: com.ibm.db2.jcc.t4.b.isValid(I)Z
java.lang.AbstractMethodError: com.ibm.db2.jcc.t4.b.isValid(I)Z
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:131)
    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
    at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:78)
    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:107)
    at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
    at com.sun.proxy.$Proxy3589.isValid(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.jdbc.core.JdbcTemplate$CloseSuppressingInvocationHandler.invoke(JdbcTemplate.java:1614)
    at com.sun.proxy.$Proxy3740.isValid(Unknown Source)

Environment

TDM Portal 4.10+

Cause

The error reported is a DB2 driver error. It seems you are using a DB2 JDBC3 driver, and we need to use the DB2 JDBC4 driver.

Resolution

 Please check with your DB2 DBA. They will need to provide you with a copy of the appropriate DB2 JDBCC4 driver.

Looking at the TDM 4.10 documentation, Notes on Implementation with specific data sources, we require:

• db2jcc4.jar
• db2jcc4_license_cu.jar
• db2jcc4_license_cisuz.jar

Where to place the DB2 dirvers:

• For masking and FDM - C:\Program Files\Grid-Tools\FastDataMasker\lib\
• For Subsetting - C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib\
• For TDM Portal - C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers

To apply the license, run the following command from a command prompt:
db2licm -a "C:\Users\Username\Desktop\10.5_DB2ConnectEE_License\db2consv_ee.lic"

Your DBA should be able to help with this if you have problems.