Device export failing

Products

• CA Privileged Access Manager - Cloakware Password Authority (PA)
• CA Privileged Access Manager (PAM)

Issue/Introduction

While trying to export devices in CSV, the export is failing with different behaviors - some times the process freezes, some times it generates a 0-lenght file.

Environment

CA PAM 2.8.2

Cause

This happens when there are inconsistencies in the database.

Resolution

Customers should open a ticket in CA Support in case they find this issue. To fix it CA Support needs to access the CA PAM appliance via SSH and run the following procedure:

 

1. Turn off the cluster;

2. Access CA PAM appliance via SSH;

3. Access MySQL and run the following queries: 

 

use uag; 

 

select h_id,hostID from host left join cspm.targetserver on (h_id = devicename_ci) where typePassword = 1 and targetserverid IS NULL and type = 1; 

 

update host set typePassword=0 where hostID=<result from the select>; 

 

Once the device is updated, turn the cluster on again and the export will work without issues.