View Submitted Tasks returns different results after database changes

Products

• CA Identity Manager

Issue/Introduction

"View Submitted Tasks" page returns different results after database changes such as re-indexing, changes in the table location, database upgrade, etc.

Environment

vApp 14.4, but probably other versions are affected

Cause

"View Submitted Tasks" page returns different results because there is no "ORDER BY" clause in the SQL statement sent to the database. Therefore, when certain number of first rows is asked to be returned (default 1000), the result can be different depending on order the database returns the records (and this order is not defined in the SQL statement).

Resolution

Reduce number of records to be returned by setting tighter time constraints or increase the allowed number of returned records.