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.

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

book

Article ID: 239165

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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.

Cause

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.

Environment

Release : 4.9

Component :

Source database:  DB2 iSeries

Resolution

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

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