SaveStepsCommand Causes Errors When Used With Instructed Steps (Doc ID 2232657.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 to 1.12.0.3 [Release 1.12]
Oracle Utilities Network Management System - Version 2.3.0.0.0 to 2.3.0.0.0 [Release 2.3]
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 to 1.12.0.3 [Release 1.12]
Oracle Network Management for Utilities - DMS - Version 2.3.0.0.0 to 2.3.0.0.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

On : 1.12.0.3 version, Web Switching

When using the SaveStepsCommand on an Instructed step, this error appears in the log:

2016-07-27 06:17:38,413 [pool-2-thread-1] ERROR STEPS:
com.splwg.oms.fcp.switching.SwmanSheetHelper.saveSteps(SwmanSheetHelper.java:2194) : WSW-5013 - Save of step view data failed for switch sheet with handle
3109.1013. An attempt to save the entire sheet will now be made.
com.splwg.oms.framework.exception.OmsServiceException:
com.splwg.oms.framework.exception.OmsDaoException:
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse
Persistence Services - 2.3.1.v20111018-r10243):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException:
ORA-01400: cannot insert NULL into ("NMSDB"."SWMAN_STEP"."SEQ_SHEET_ID")




The issue can be reproduced at will with the following steps:
1. Create a switch plan.
2. Record a Control tool action with "Instruct" in its name.
3. Attempt to save the sheet.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms