My Oracle Support Banner

AIF Apps: Batch AGG Slow Performance; Batch Log Shows Error "Error while translating '<XX>_batch_<XX>' group: Meas 'XX' is not found" (Doc ID 3046540.1)

Last updated on SEPTEMBER 10, 2024

Applies to:

Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service Plus - Version 23.2 and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 24.0 and later
Oracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 24.1 and later
Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service Plus - Version 24.1 and later
Oracle Retail Demand Forecasting Cloud Service - Version 23.2 and later
Information in this document applies to any platform.

Symptoms

For this scenario, the AP_BATCH_AGG_D job was performing poorly. It had been running for 16+ hours when it typically takes under 3 hours to complete.

The batch log showed the following:
<E 2024-09-09T10:15:15.672Z r:D op:Batch> Following groups has error during translation:
<E 2024-09-09T10:15:15,672Z r:D op:Batch>    Error while translating 'ad_batch_agg1' group: Meas 'XXXX' is not found
<E 2024-09-09T10:15:15.672Z r:D op:Batch>    Error while translating 'ad_batch_agg2' group: Meas 'XXXX' is not found
<E 2024-09-09T10:15:15.672Z r:D op:Batch>    Error while translating 'ad_batch_agg3' group: Meas 'XXXX' is not found
<E 2024-09-09T10:15:15.672Z r:D op:Batch>    Error while translating 'ad_batch_dbcalc' group: Meas 'XXXX' is not found
<E 2024-09-09T10:15:15.672Z r:D op:Batch>    Error while translating 'ad_batch_rms_exp' group: Meas 'XXXX' is not found

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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