Device export failing
search cancel

Device export failing


Article ID: 8619


Updated On:


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


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.


CA PAM 2.8.2


This happens when there are inconsistencies in the database.


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.