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 2.4.0.1.0 to 2.5.0.0.0 [Release 2.4 to 2.5]
Oracle Network Management for Utilities - DMS - Version 2.4.0.1.0 to 2.5.0.0.0 [Release 2.4 to 2.5]
Information in this document applies to any platform.

Symptoms

On : 2.5.0.0.0 version, Adapters

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

on NMS 2.5.0.0 and 2.5.0.0.1, the weather adapter script nms-weatherDataAdapter.py 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/2.5.0.0/bin/nms-weatherDataAdapter", line 1206, in <module>
   main()
 File "<NMS_HOME>/nms/product/2.5.0.0/bin/nms-weatherDataAdapter", line 1111, in main
   source = queryTableValue(conn, "pf_weather_data_config",
 File "<NMS_HOME>/nms/product/2.5.0.0/bin/nms-weatherDataAdapter", 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


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


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