My Oracle Support Banner

ProfileAdapter Crashes When Hours are 1 to 24 Instead of 0 to 23 (Doc ID 2772824.1)

Last updated on APRIL 29, 2021

Applies to:

Oracle Network Management for Utilities - DMS - Version to [Release 2.4 to 2.5]
Oracle Utilities Network Management System - Version to [Release 2.4 to 2.5]
Information in this document applies to any platform.


On : version, Web Workspace

ProfileAdapter core dumped with hour and header present


If the data sent to the ProfileAdapter has the hours in the range of 1 to 24, the adapter crashes.

0:54:22 LP-005: Row number 13176 for transformer 4303451 in CSV file '$OPERATIONS_MODELS/load_profiles/LVBen01_trans.csv' has an invalid interval value (24).

ProfileAdapter itself generated this error:

ERROR: UPDATE pf_load_interval_data SET kw_int_0 = :kw_0, kvar_int_0 =
:kvar_0 WHERE profile_id = :profile_id AND daytype = :daytype AND temp_index
IN (SELECT temp_index FROM pf_loads_profile_samples WHERE profile_id =
:profile_id AND daytype = :daytype AND samples_0 = 0)
Size = 0

Memory fault(coredump)

The issue can be reproduced at will with the following steps:
1) Modify a load profile CSV so one of the profiles doesn't have a full range of hourly data (e.g. remove hours 4-6)
2) Run the load profile adapter using "ProfileAdapter -v -clean -adjDefaults"
3) The adapter will crash




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
 Fix Description

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