My Oracle Support Banner

NMS Locks Up after Calling "UpdateDDS -recacheMeasures" (Doc ID 2477006.1)

Last updated on AUGUST 03, 2022

Applies to:

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

Symptoms


As part of the post-build process, a custom script updates the SCADA_MEASUREMENTS_ST table and then makes a call to "UpdateDDS -recacheMeasures".

This process results in JMService spending 20 minutes updating the DIGITAL_MEASUREMENTS table.

(It is worth mentioning that JMService does this same process at each startup, and the log shows that it successfully completed the reload of the DIGITAL_MEASUREMENTS table in less than 2 minutes.)


A 'cmd snapshot' confirmed that JMService was waiting for its query that joins the DIGITAL_MEASUREMENTS, NETWORK_COMPONENTS and NETWORK_NODES tables to return.

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.