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
TDM Portal 4.11.x
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'
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