search cancel

CA TDM PORTAL ISSUE : 400: Could not get samples for DB2 Table


Article ID: 239165


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


We created a DB2 connection in TDM portal. When we run PII scan on the database, getting an error as below:

Exception: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL []; SQL state [43617]; error code [-99999]; A string parameter value with zero length was detected.; nested exception is java.sql.SQLException: A string parameter value with zero length was detected.


This issue is due to connection failures in TDM Model logs. Even though the required jars are inplace, connection details are not established from TDM portal to DB2 Database.


Release : 4.9

Component :

Source database:  DB2 iSeries


This issue is resolved in latest patch. Please download and install latest TDM patch from below link and verify the PII scan.