My Oracle Support Banner

D1-AMCS Does Not Perform Satisfactorily (Doc ID 2805822.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Utilities Meter Data Management - Version 2.3.0.2.0 to 2.3.0.2.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

On : 2.3.0.0.0 version, Function processing

D1-AMCS does not perform satisfactorily

At EQ we are running D1-AMCS for 11 Measuring component sets in an aggregation group. 4 of these measuring component sets are foundation aggregators aggregating from measuring component (channel) to NMI (service point level identifier). I.e. we create a number of aggregator MCs almost equal to the number of SPs. We then aggregate up to the Transmission Node (TNI) (about 150 of these in total).
Running the D1-AMCS job yields a throughput for these 11 runs varying from 7 RPS at max to about 0.002 RPS (for one of the composite aggregators). And the overall completion time for all eleven MC sets is 74 minutes - when reducing the records to 1 TNI. The total number of NMIs aggregated is about 1/150th - 1/100th of the production volume, so a generous extrapolation would make us need 7400 minutes or roughly 5 days to aggregate the production volumes.
Given we have to perform this aggregation 4 times per week there simply isn't enough time to do this. Would expect an aggregation time of a few hours per each of the 4 runs. (Preliminary, Final, Revision 1 and Revision 2), preferably running all 4 on the weekend.



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!


In this Document
Symptoms
Changes
Cause
Solution
References


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