My Oracle Support Banner

"UpdateDDS -recacheMeasures" Removed Almost All Entries From DIGITAL_MEASUREMENTS Table (Doc ID 2476992.1)

Last updated on FEBRUARY 23, 2022

Applies to:

Oracle Utilities Network Management System - Version and later
Oracle Network Management for Utilities - DMS - Version and later
Information in this document applies to any platform.


An errant update to the SCADA_MEASUREMENTS_ST table resulted in nearly all rows being removed. The SCADA_MEASUREMENTS_ST table was reduced from thousands to 2 rows by mistake and
the "UpdateDDS -recacheMeasures" was issued.

Result of this was that almost all of the entries in the DIGITAL_MEASUREMENTS table were removed.
This meant that even if a new updated set of data was passed into SCADA_MEASUREMENTS_ST, the QUALITY values would not necessarily be accurate, as those values are maintained in the table.

Due to this issue, the process has been to manually reintroduce the inhibit based on a backup of the DIGITAL_MEASUREMENTS table, but it is not clear what else should be checked.

Is there an alternative process that would be recommended?




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

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