nms-update-customers Incorrectly Applies Multiple X_ces_customers_updated_ivr.sql Files (Doc ID 2891645.1)

Last updated on AUGUST 23, 2022

Applies to:

Symptoms

On : 2.5.0.1.0 version,

nms-update-customers incorrectly applies multiple ces_customers_updated_ivr.sql files


nms-update-customers should only run the first available ivr script.


The issue can be reproduced at will, on a system with the OPAL demo model installed, with the following steps:

1. Run this command:
   touch ~/sql/OPAL_schema_ces_customers_updated_ivr.sql
2. Run "nms-ces-customers-updated -showme"
   It will list two files:
   nms_schema_ces_customers_updated_ivr.sql
   OPAL_schema_ces_customers_updated_ivr.sql
3. Run this command:
   rm ~/sql/OPAL_schema_ces_customers_updated_ivr.sql
   
   

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.