CSV reporting has multiple same records

Document ID : KB000126351
Last Modified Date : 08/02/2019
Show Technical Document Details
Introduction:
You can generate reports from Credential Manager data. Credential Manager stores audit, metric, and event data in the database.
The problem faced is when the number of Target Accounts are large the repport generated in CSV format generates the same entries two times in the CSV report.
The same report when generated in HTML or PDF format is correct, no information is repeated.
Question:
How can this problem be fixed?
Environment:
CA PAM version: 3.x release
This problem is common across stand alone CA PAM appliances as well as in cluster environment.
The problem limited to the generation of CSV reports only.
Answer:
Add the following lines in the report.jrxml file in the location "/opt/cloakware/cspmserver_modules/reports/*"

The lines to that need to be added as under without the comments tag.

<!--
<property name="ignoreGraphics" value="false"/>
<property name="collapseRowSpan" value="false"/>
<property name="ignoreCellBorder" value="false"/>
-->

The first few lines from report.jrxml after adding the above lilnes is documented below.

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 5.6.1.final using JasperReports Library version 5.6.1  -->
<!-- 2014-10-16T21:02:27 -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="57bb2356-95cf-4a2e-8877-1bad51b02afc">
    <property name="ireport.scriptlethandling" value="0"/>
    <property name="ireport.encoding" value="UTF-8"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.1" value="columnHeader"/>
    <property name="net.sf.jasperreports.export.html.exclude.origin.keep.first.band.1" value="columnHeader"/>
    <property name="net.sf.jasperreports.export.csv.exclude.origin.band.1" value="pageFooter"/>
    <property name="net.sf.jasperreports.export.html.exclude.origin.band.1" value="pageFooter"/>
     <property name="ignoreGraphics" value="false"/>
     <property name="collapseRowSpan" value="false"/>
     <property name="ignoreCellBorder" value="false"/>
    
<property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false" />    
    <property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"/>    
    <property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="false" />   

Save the file after the lines are added, this does not require restart of any of the serivce of CA PAM.
Additional Information:
For modification of the reports.jrxml file, please contact CA Support so that the file can be modified after enabing connection to the CA PAM appliance backend using either Putty or WinScp.