8.0.4 FTP Process Completes But Does Not Calulate Transfer Rates in AIX Environment (Doc ID 2810563.1)

Last updated on MAY 08, 2023

Applies to:

Symptoms

In an 8.0.4 AIX environment with both FTP and ALM, a Batch containing FTP Processes completes but does not calculate any Transfer Rates.

Checking the ofstp logs in $FIC_DB_HOME/log/FusionApps, all logs end before processing data.  The following is at the end of each log:

Module Logging OFS Access module data: /* 121: *io_cid::GetCatalogIDs*/

Module Logging OFS Access module data: select
select OFSA_CATALOG_OF_IDS.sys_id_num,
      OFSA_CATALOG_OF_IDS.id_type, OFSA_CATALOG_OF_IDS.id_desc_short,
      OFSA_CATALOG_OF_IDS.id_desc_long,
      OFSA_CATALOG_OF_IDS.leaf_num_id, OFSA_CATALOG_OF_IDS.table_name,
      OFSA_CATALOG_OF_IDS.access_code, OFSA_CATALOG_OF_IDS.access_name,
      OFSA_CATALOG_OF_IDS.folder_name, OFSA_CATALOG_OF_IDS.chg_app,
      OFSA_CATALOG_OF_IDS.chg_login, OFSA_CATALOG_OF_IDS.chg_date,
      OFSA_CATALOG_OF_IDS.chg_time
from OFSA_CATALOG_OF_IDS
where OFSA_CATALOG_OF_IDS.sys_id_num = 200302.00000
order by OFSA_CATALOG_OF_IDS.sys_id_num 

Module Logging OFS Access module data: /*inside TP_Context class isContinue=1 */

Module Logging OFS Access module data: insert
insert into FSI_PROCESS_ERRORS(process_sys_id, id_number,
    sequences, field_name, field_value, corrected_value,
    default_value, severity, error_date, error_time, table_name,
    error_description, error_code, num, leaf_num_id, leaf_node, sim,
    batch_run_id)
values (:process_sys_id, :id_number, :sequences, :field_name,
   :field_value, :corrected_value, :default_value, :severity,
    :error_date, :error_time, :table_name, :error_description,
    :error_code, :num, :leaf_num_id, :leaf_node, :sim, :batch_run_id
) 

There is no data output to FSI_PROCESS_ERRORS.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.