search cancel

Publish job fails when countlist is empty

book

Article ID: 229469

calendar_today

Updated On:

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.

Cause

Product defect.

Environment

Release : 4.9.1

Component : Web Portal - Generator

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