Attempts to Save the Current Set of Impacted Customers in a Switch Plan Intermittently Fails
(Doc ID 2279006.1)
Last updated on MARCH 19, 2019
Applies to:Oracle Utilities Network Management System - Version 126.96.36.199 to 188.8.131.52.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 184.108.40.206 to 220.127.116.11.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.
When attempting to save the current set of Impacted Customers in a switch plan, there were intermittent failures.
These were in the NMS managed server log --
2017-05-09 15:01:29,607 ERROR swman.SwmanServiceImpl:171 - createImpactedCustomers failed
2017-05-09 15:43:50,178 ERROR swman.SwmanServiceImpl:171 - createImpactedCustomers failed
2017-05-10 09:11:13,467 ERROR swman.SwmanServiceImpl:171 - createImpactedCustomers failed
The error in each case pertains to a database ‘unique constraint’ error:
Internal Exception: java.sql.BatchUpdateException: ORA-00001: unique constraint (NMS.SWMAN_ISN_U01)
That constraint at was
CONSTRAINT SWMAN_ISN_U01 UNIQUE (SEQ_SHEET_ID, SUPPLY_IDX, BEGIN_STEP_IDX)
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