TDM - DB2 Generator failed 'DB2 SQL Error: SQLCODE=-443, SQLSTATE=38112'

Products

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

Issue/Introduction

While trying to generate synthetic data for a DB2 database, we see the following error in TDM Portal:

ERROR: Publish failed for job <job id>, Failed to get columns

Environment

TDM Portal 4.11.x

Cause

In the TDMPublish.log we find more information for the failed publishing job:

[ERROR] [taskExecutor-73          ] --- [U:][M:][P:]           c.c.t.c.d.i.JDBCDbInformationGetterImpl:  Failed to get columns due to 'DB2 SQL Error: SQLCODE=-443, SQLSTATE=38112, SQLERRMC=SQLCOLUMNS;SQLCOLUMNS;-805, DRIVER=4.25.1301'

Resolution

TDM Engineering reviewed the log and stated this is a DB2 database issue. The DB2 DBA needs to investigate the error in the database, and address the issue. It appears that the DB2 database is not in the correct state.

For more information, see https://www.ibm.com/docs/en/db2/11.1?topic=install-creating-configuring-metadata-database