SearchObject API class returns incomplete list of objects

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

It can happen that the SearchObject API returns an incomplete list of objects when these objects were just loaded into the DB.

It can take up to 15 seconds before the complete list is returned.

As far as we know this only happens just after using the DB Load Utility to load objects into the database.

Cause

Cause type:
By design
Root Cause: ITL objects are not processed yet

Environment

OS: All

Resolution

Check after the load for ITL's and should only proceed if there are no more records to process.
 

select * from itl;
 

There should be no records returned and then it is okay to proceed.

Fix Status: No Fix

Additional Information

Workaround :
N/A