Publish job fails when countlist is empty

Products

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

Issue/Introduction

Trying to publish a table with 2 columns below values

Column1:    @lov(@sqllist(S,select distinct Columnname from TT_AFLDWHorder by 1)@,~ROWNUM~)@

 

Column2:    @hashlov(0,@sqllist(S,select distinct Columnname from TT_AFLDWHorder by 1)@,Columnname ,@seedlist(FirstName)@,1,Y)@

 

On Publish screen, Table count is given as:

@countlist(@sqllist(S,select distinct Columnname from TT_AFLDWH)@)@

 

When there are no entries in table "TT_AFLDWH" publish job is failing with below error:

 

2021-11-09 07:51:44.174 UTC [ERROR] [taskExecutor-1           ] --- [U:][M:][P:]                           c.c.t.p.l.TDMPublishLog:  java.lang.NullPointerException
 at com.ca.tdm.publ.output.TDMPublishTGTOutput.outputBatchRows(TDMPublishTGTOutput.java:318)
 at com.ca.tdm.publ.model.TDMPublishJobStart.publishTableBatchedRows(TDMPublishJobStart.java:1537)
 at com.ca.tdm.publ.model.TDMPublishJobStart.publishBatchedRows(TDMPublishJobStart.java:1518)
 at com.ca.tdm.publ.model.TDMPublishJobStart.doPublishTables(TDMPublishJobStart.java:1174)
 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)

 

Publish job is working fine when there are entries in table TT_AFLDWH.

Environment

Release : 4.9.1

Component : Web Portal - Generator

Cause

Product defect.

Resolution

This issues has been fixed and released as patched build for 4.9.1. Please download and install latest patch build for 4.9.1 to resolve this issue from below link:

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