Portal publish throwing nullpointer error

Products

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

Issue/Introduction

When running a publish job, it ran for some time and got an error at the end the publishing reports an “Unknown error. Consult TDM Publish log.”

Noticed below error:

2022-01-20 15:45:59.810 UTC [ERROR] [taskExecutor-55          ] --- [U:][M:][P:]                      c.c.t.p.m.TDMPublishJobStart:  doPublish error, jobId=136944, Exception: Unknown error.  Consult TDM Publish log.
2022-01-20 15:45:59.811 UTC [ERROR] [taskExecutor-55          ] --- [U:][M:][P:]                           c.c.t.p.l.TDMPublishLog:  java.lang.NullPointerException
 at com.ca.tdm.publ.utils.TDMPublishInsertSQL.createInsertSQL(TDMPublishInsertSQL.java:102)
 at com.ca.tdm.publ.output.TDMPublishSQLOutput.outputRow(TDMPublishSQLOutput.java:62)
 at com.ca.tdm.publ.model.TDMPublishJobStart.publishFromRow(TDMPublishJobStart.java:1466)
 at com.ca.tdm.publ.model.TDMPublishJobStart.processDeferredPublishTable(TDMPublishJobStart.java:1304)
 at com.ca.tdm.publ.model.TDMPublishJobStart.processDeferredPublish(TDMPublishJobStart.java:1234)
 at com.ca.tdm.publ.model.TDMPublishJobStart.doDeferredPublish(TDMPublishJobStart.java:1188)
 at com.ca.tdm.publ.model.TDMPublishJobStart.doPublishTables(TDMPublishJobStart.java:1135)
 at com.ca.tdm.publ.model.TDMPublishJobStart.doPublish(TDMPublishJobStart.java:583)
 at com.ca.tdm.publ.publthread.TDMPublishThread.run(TDMPublishThread.java:46)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)

Environment

Release : 4.9

Component : Web Portal - Publishing

Resolution

We fixed this issue in portal version 4.9.408. Please download and install latest portal version to resolve this issue