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.
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:
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.