ACV table entries created by IG_FTP job execution

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When executing an IG_FTP Job Object in the Automic Automation Engine, the ACV table is populated with multiple entries (e.g., 1,000 entries) corresponding to defined arrays. This behavior may cause concern regarding database growth, particularly when arrays are not explicitly used in the script.

Environment

• Product: CA Automic Workload Automation - Automation Engine
• Component: Integration FTP Agent (IG_FTP)

Cause

The Automation Engine performs a pre-compile phase for all scripts. During this phase, :DEFINE statements (which initialize arrays or variables) are processed to ensure that all necessary resources are available before the actual script execution begins. This process inevitably populates internal tables, such as the ACV table, as part of the engine's core design. This happens even if the array definitions appear to be skipped or bypassed in the script logic.

Resolution

The creation of these ACV table entries is expected engine behavior and does not indicate a software defect.

If the ACV table growth is impacting performance or storage, review the script and any included objects for redundant :DEFINE statements. Minimizing the number of array or variable declarations can effectively reduce the volume of entries populated in the ACV table.

Additional Information

 If you require further assistance or wish to discuss optimizing your implementation, please contact support. To speak with a customer representative or a Support Engineer see Contact Support.