Inconsistent Results in View Submitted Tasks After Database Changes - Identity Manager

Products

• CA Identity Manager

Issue/Introduction

Inconsistent results may appear on the "View Submitted Tasks" page following database maintenance, such as re-indexing, migrations, or database upgrades. This document explains the cause of this non-deterministic behavior and provides methods to stabilize the result sets.

Environment

Virtual Appliance 14.5

Cause

The SQL query generated for the "View Submitted Tasks" page lacks an explicit ORDER BY clause. When the database is queried with a result limit (the default is 1000), the records returned are non-deterministic. Maintenance operations often change the physical storage order of the records; therefore, the arbitrary "first 1000" records returned by the database may differ before and after such changes.

Resolution

To ensure consistent results, use one of the following methods to manage the result set size:

1. Apply Tighter Filters: Use specific time constraints or search criteria to reduce the total number of records retrieved so that the result set is consistently below the default limit of 1000.
2. Increase the Return Limit:
   1. Navigate to the Identity Manager configuration directory.
   2. Locate the relevant properties or configuration file controlling the task view limit.
   3. Update the setting to a value sufficient to capture all required records.
   4. Restart the service to apply the new configuration.

Additional Information

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.