Device export failing

Document ID : KB000008619
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.