search cancel

Oracle Database: Collect engines slow to process inventory files.

book

Article ID: 112226

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager

Issue/Introduction

When ITCM is installed to an Oracle database, it is observed that Engines running the collect task are taking considerable amounts of time to process individual inventory files.  Some files may take 20 minutes or more for the engine to process:
 
240718-11:28:31.4906681L|004820|000012d8|Engine_Col|cmEngine |cCollectJob::DoColle|000000|INFO | Processing of File:E:\CA\DSM\SERVERDB\SECTOR\COLLECT\00000001\1A1B3FF0-81F6-4F30-B146-FC337A8DDD79.I00 Begin 
240718-11:28:31.4907379L|004820|000012d8|Engine_Col|cmEngine |cCollectJob::DoColle|000000|INFO | Processing FT_INVENTORY File (New Model) 
240718-11:44:30.8287312L|004820|000012d8|Engine_Col|cmEngine |cCollectJob::DoColle|000000|INFO | Processing of File:E:\CA\DSM\SERVERDB\SECTOR\COLLECT\00000001\1A1B3FF0-81F6-4F30-B146-FC337A8DDD79.I00 done

In further inspection of the log file, SQL transactions associated with processing the inventory file have a noticeable delay.

Environment

Client Automation (ITCM) -- 12.9 FP2

Resolution

Please open a support case to request patch T5IZ397 (Collect task hung).