Jasper Reporting - Port Report Export Output incorrect

book

Article ID: 131731

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

The Issue is, that the Excel Output of a Port Detail Report pushing the "Is Port Available" covers duplicate line-entry when Value is "Yes" into a new Line. 
This is problematic when export data/report is used for input to the subsequent process. 
In case the Value is "No" a single line record is exported - in case the Value is "Yes" then 2 lines are exported. 

 

Cause

CA Spectrum Release R10.2.3 and higher will cover "format" error which is not visible when Report is displayed - but becomes visible at native data when exporting them.

Sample export data showing this issue - here i.e. when report is saved as native CSV/data: 
(find "Yes" results as duplicates / "No" results as single line entry) 

LIEJO02.cai.com_38,,,,,tunnel,,,,Disabled,,5,,Yes,, 
,,,,,,,,,,,,,,Yes
LIEJO02.cai.com_Dual Band Wireless-AC 7260,,Dual Band Wireless-AC 7260,,,ieee80211,,,300.0Mbps,Not In Use,,6,,Yes,, 
,,,,,,,,,,,,,,Yes

LIEJO02.cai.com_Ethernet Connection I217-LM,,Ethernet Connection I217-LM,,,ethernet,,,1.0Gbps,In Use,,0,,No,, 
LIEJO02.cai.com_Microsoft WiFi Miniport Adapter,,Microsoft WiFi Miniport Adapter,,,ieee80211,,,300.0Mbps,Not In Use,,6,,Yes,, 
,,,,,,,,,,,,,,Yes
LIEJO02.cai.com_VirtualBox Ethernet Adapter,,VirtualBox Ethernet Adapter,,,ethernet,,,100.0Mbps,In Use,,5,,Yes,, 
,,,,,,,,,,,,,,Yes


So - you directly see the line-duplicates (here the ,,,,,,,,,,,,,,Yes, ). 
 

Environment

This applies to all supported CA Spectrum platforms for CA Spectrum R10.2.3 and higher when using CABI 6.3.*/++
 

Resolution

PTF_10.2.386 or BMP_303 for CA Spectrum R10.2.3