Real Device Outage (RDO) with No Supply Nodes Impacted Causes ORA-00936 Error (Doc ID 2881686.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

On : 2.5.0.1.0 version, NMS Infrastructure

RDO with not supply nodes impacted causes ORA-00936 error

Getting an error in the TCDBService log when a outage does not have any affected customers.

Error Example:

05/25/22 08:09:18: dbrdwr:926354
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'select max(step.planned_offset) from
swman_impacted_supply_nodes snodes inner join swman_step step on
step.step_idx = snodes.end_step_idx where snodes.begin_step_idx = 12345
and snodes.supply_idx IN ()'
ORA-00936: missing expression
parse offset = 204[)]
05/25/22 08:09:18: dbrdwr:926354 *ERROR* - sql failed:
  result=-1 error='ORA-00936: missing expression
'
  sql=[select max(step.planned_offset) from swman_impacted_supply_nodes
snodes inner join swman_step step on step.step_idx = snodes.end_step_idx
where snodes.begin_step_idx = 12345 and snodes.supply_idx IN ()]
  host_vars=[{

The issue can be reproduced at will with the following steps:

1. Open a device to create RDO.
2. Open another device downstream from the RDO and create nested outage.
3. Close the nested outage device.   At this point the nested RDO will be restored and have no affected customers
   
   

Changes

Cause

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