Unable to Publish using SEQLOV from DB2 source on TDM Portal


Article ID: 141158


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


We are trying to publish data from DB2 source to SQL Server target. We use SEQLOV to pick a specific rows from source based on a criteria. The query works fine from the Datamaker SQL window & from Oracle SQL Developer but it goes to hung state when we try to validate in the data painter/publish. 

Below are the Generator service logs from portal:

2019-11-19 20:14:04.017 UTC [ERROR] [https-jsse-nio-8443-exec-2] --- [U:Administrator][M:POST][P:/api/ca/v1/generators/validateExpression]                      c.c.t.g.s.DataPainterService:  Expression validation failed, org.springframework.web.client.HttpServerErrorException: 500 null

2019-11-19 20:14:04.017 UTC [ERROR] [https-jsse-nio-8443-exec-2] --- [U:Administrator][M:POST][P:/api/ca/v1/generators/validateExpression]                   c.c.t.g.c.DataPainterController:  Expression validation failedjava.lang.Exception: (500)500 

2019-11-19 20:14:04.017 UTC [ERROR] [https-jsse-nio-8443-exec-2] --- [U:Administrator][M:POST][P:/api/ca/v1/generators/validateExpression]              c.c.t.c.e.h.GlobalExceptionConvertor:  HTTP Error - INTERNAL SERVER ERROR: Exception: (500)500 

java.lang.Exception: (500)500 

at com.ca.tdm.generators.service.DataPainterService.validateExpression(DataPainterService.java:258)

at com.ca.tdm.generators.controller.DataPainterController.validateExpression(DataPainterController.java:266)

at sun.reflect.GeneratedMethodAccessor2997.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)


There is an incompatibility between DB2 JDBC driver and Java framework which is used by Portal (and that's why it works outside Portal because JDBC is not used this time).


Release : 4.7

Component : CA Test Data Manager - TDM Web Portal


Removed file db2jcc.jar from the "C:\Program Files\CA\CA Test Data Manager Portal\tomcat\lib" folder and restarted the TDM Portal service.

This resolved the issue.