Release Notes › Known Issues › Reporting

Reporting

The following issues are related to reporting in CA Identity Manager r12.5 SP1.

User Account Report Generation Fails

If the number of records is more than 20,000, the User Accounts report can fail.

Workaround

1. Open the Business Objects Central Management Console.
2. Click "Servers" and select servername.pageserver.
3. Select "Unlimited records" for the entry "Database Records To Read When Previewing Or Refreshing a Report".
4. Using Crystal Reports Designer, open the User Accounts report.
5. Under Database, Set Datasource Location, set the database location to the CA Identity Manager Snapshot database.
6. Click Save.
7. Under Database, Datasource Expert, right-click Command in the right side window.
8. Enter the parameter name as it appears in the "Parameters Fields" of the report template.
9. Change the query on the left side and add that parameter to the query, for example, if you have the 'reportid' parameter, the query appears as follows:

   Select * from endPointAttributes, endpointview, imreport6
   where endPointAttributes.imr_endpointid = endpointview.imr_endpointid and 
   endPointAttributes.imr_reportid = endpointview.imr_reportid 
   and endpointview.imr_reportid = imreport6.imr_reportid and imreport6.imr_reportid = {?reportid}
   

10. Save the report.