Unable to run content classifiers in TDM Portal

Products

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

Issue/Introduction

While performing the PII Auditing, we are unable to use the content type classifiers as the jobs are getting failed with the following error :

failed: PooledConnection has already been closed.

whereas, when we are using column type classifiers for PII Auditing on the same DBs we are successfully able to generate a heat map and a PII report.

Can see below error in TDMModelService.log:

2023-05-08 11:18:23.146 GMT [ERROR] [pool-34-thread-1         ] --- [U:][M:][P:]                         c.c.t.p.s.ProfilingEngine:  scanColumn: job: 926:threw exception:
java.sql.SQLException: PooledConnection has already been closed.
    at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:87)
    at com.sun.proxy.$Proxy2225.createStatement(Unknown Source)
    at com.ca.tdm.datamodel.engine.JdbcDataSamplerConnection.initResultSet(JdbcDataSamplerConnection.java:146)
    at com.ca.tdm.datamodel.engine.DataSampler.initResultSet(DataSampler.java:384)
    at com.ca.tdm.profiler.service.DataCollectionService.setColumnForSampling(DataCollectionService.java:714)
    at com.ca.tdm.profiler.service.ProfilingEngine.scanColumn(ProfilingEngine.java:937)
    at com.ca.tdm.profiler.service.ProfilingEngine.scanConprof(ProfilingEngine.java:1192)
    at com.ca.tdm.profiler.service.ProfilingEngine$ConprofScanner.call(ProfilingEngine.java:354)
    at com.ca.tdm.profiler.service.ProfilingEngine$ConprofScanner.call(ProfilingEngine.java:301)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:750)

Environment

Release : 4.10

Resolution

Download the patch build from below link:

 https://ftp.broadcom.com/user/downloads/pub/TDM/TDMWeb/TDMWeb-4.10.187.0.zip

Or

later version can be found at below link:

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

Use below TDM Portal section from below KB article to apply the patch build:

https://knowledge.broadcom.com/external/article?articleId=10931