My Oracle Support Banner

nms-weatherDataAdapter Script Generates Errors When Attempting to Read Customer Forecast Data From the Database (Doc ID 2721319.1)

Last updated on OCTOBER 19, 2020

Applies to:

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


On : version, Adapters

nms-weatherDataAdapter script fails to run when loading weather data from the database

on NMS and, the weather adapter script fails to run with multiple errors.

nms-weatherDataAdapter -v -debug

Connection established with host database - /@<DATABASE HOST>
Traceback (most recent call last):
 File "<NMS_HOME>/nms/product/", line 1206, in <module>
 File "<NMS_HOME>/nms/product/", line 1111, in main
   source = queryTableValue(conn, "pf_weather_data_config",
 File "<NMS_HOME>/nms/product/", line 183, in queryTableValue
   cursor.execute("SELECT {retCol} FROM {table} WHERE {searchCol1} = :1 and {searchCol2} = :2",
cx_Oracle.DatabaseError: ORA-00936: missing expression


The issue can be reproduced at will with the following steps:
1. nms-weatherDataAdapter -v -debug
2. check the errors




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.