Troubleshooting report problems - Cognos

The following section describes solutions for ISIM Cognos report problems.


Problems and their solutions

View a report in Turkish locale shows characters that are not translated as '#'.
The PDF report by default is unable to render some Turkish characters. This issue is a known limitation.

IBM Cognos audit history report does not show the audit of an account that is provisioned on the managed resource
IBM Cognos audit history for an account does not show the audit of the account that is provisioned on the managed resource when "Default Account Request Workflow" is configured with the entitlements that are associated with the provisioning policy.

Solution
To generate the audit history reports for the accounts with the default workflow, clear the Approval Start Date and Approval End Date check boxes, and then run the report.

IBM Security Identity Manager Cognos report execution fails on Oracle data source
During the report generation on Oracle data source, if we select more than 1000 filter values on the prompt page, the report execution fails.

Solution

  1. Open the report in IBM Cognos Report Studio.

  2. Open the prompt page and edit the property Rows Per Page for all input widgets.
  3. Set the value to less than or equal to 1000.

The scope for the default provisioning policy is shown as blank on Oracle database.
When you generate the customized IBM Cognos report that includes provisioning policy scope in it, the scope for the default provisioning policy is shown as blank. This issue is specific to Oracle database.

Solution
If the scope for the default provisioning policy is shown as blank on Oracle database, then, interpret the scope of a provisioning policy as Subtree.

No data is displayed in ISIM Cognos audit history report
Account audit is not supported for an account added and does not have a defined workflow. To audit the accounts for an audit history report, the default workflow or custom workflow must be attached to the provisioning policy that is created.

Long filter values are not shown completely on the prompt pages
Follow the technote link http://www.ibm.com/support/docview.wss?uid=swg21341018 to resolve this issue. The information in the technote also applies to IBM Cognos Analytics version.


Known limitations

ISIM administrative console reports do not display information about accounts that are requested through the Identity Service Center

Solution
Operations that are performed in the Identity Service Center do not generate audit records. They generate access records in IBM Cognos. Use IBM Cognos audit history report to view them.

User entitlements are not displayed in Legacy Administrator console reports and in BIRT reports
Both the Legacy Administrator console reports and BIRT reports do not show the entitlements granted to an individual when the provisioning policy membership is set to "All Other Users". To resolve the problem, use Cognos-based entitlements granted to an individual report to get the entitlement details.

IBM Cognos entitlements report shows the provisioning policy data that is in the draft state
The IBM Cognos entitlements report shows the entitlements granted to an individual. It lists all the users and the items for which they are entitled. The report also shows the provisioning policy information that includes the policies that are saved in the draft state.

Cannot truncate the length of the text in the pie charts
An option or a property that can be set to truncate the length of the text is not available for the pie charts. We cannot truncate the length of the text in the pie charts.

Unable to interpret the date in the separation of duty policy violation report
The date value in the Separation of duty policy violation report shows the numbers only. This value is the time in the seconds since the Epoch date.

Languages that are not supported by the IBM Cognos Analytics Server
IBM Cognos Analytics Server does not support the following languages:
  • ar=Arabic
  • iw=Hebrew
It provides partial support for the following language:
  • el=Greek

The IBM Cognos Analytics Server is not fully translated into the Greek language. Only components like Cognos Viewer, Cognos Connection, Cognos Administration, and Cognos Workspace support translation in the Greek language. The unsupported languages are not in the Product Language list, although they are displayed in the Content Language list in the Cognos configuration of IBM Cognos Analytics Server.

Duplicate entries of the account add operation are observed when you run the account audit report
Duplicate entries of the account add operation are observed if the provisioning policy is configured with the default workflow and an extra custom workflow is created in ISIM Console under Configure System > Manage Operations.

Solution
Remove the default workflow defined in the provisioning policy. Therefore, only the custom workflow defined would be effective, which would be captured in the account audit report.

Custom workflows defined in ISIM are not supported for the following type of actions on an account
Only the default workflows are supported for the following actions on an account.
  • Restore
  • Suspend

Audit of the custom access type is not supported in the access audit history report
Any custom access type defined as access for a role, service, or group cannot be audited in the access audit history report.

See:

  1. Out of memory during data sync with many administrators
  2. Configurable column sizes for report data sync tables
  3. Data validity attributes are not synchronized
  4. Data synchronization mismatch in the ercustomdisplay attribute mapping
  5. Orphan accounts are not displayed on the dashboard report
  6. Filters on each individual chart do not refresh in the dashboard report
  7. Dashboard report fails to show the aggregate values or measures on the chart
  8. Provisioning policy membership chart takes a long time to load in the dashboard report
  9. Best practices to run the Cognos reports in a large data deployment scenario
  10. Web session does not time out when the provisioning policy change preview is in progress
  11. Report data synchronization fails intermittently

Parent topic: Troubleshooting and support