"ORA-02291: SW_STEP_PHASE_BITMAP_LOOKUP1 Violated - Parent Key Not Found" When Saving Switch Sheets
(Doc ID 2580824.1)
Last updated on AUGUST 23, 2019
Applies to:
Oracle Utilities Network Management System - Version 2.3.0.2.0 and laterOracle Network Management for Utilities - DMS - Version 2.3.0.2.0 and later
Information in this document applies to any platform.
Symptoms
On : 2.3.0.2.0 version, Web Switching
Occasionally, these errors appear in the weblogic log after using web switching:
Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (NMS_PROD.SW_STEP_PHASE_BITMAP_LOOKUP1) violated - parent key not found
Error Code: 2291
Call: INSERT INTO SWMAN_STEP (STEP_IDX, CONDITION_CONDITION_CLASS, CONDITION_CONDITION_TYPE, CONDITION_DATE, CONDITION_DETAILS, CONDITION_LOCATION, CONDITION_PHASE_ANNOTATION, CONDITION_STATUS, CONDITION_SWITCH_CLS, CONDITION_SWITCH_IDX, CONDITION_TEXT, CONDITION_USER, INSTRUCTED_TO_ENTRY, SET_VALUE, ACTIVE, AVAILABLE_PHASES, COMMENTS, COND_CLS, COND_IDX, CONTROL_TIME, DETAILS, DEV_CLS, DEV_IDX, DEV_X, DEV_Y, DEVICE_ALIAS, EDITED_OPERATION, EXECUTE_ORDER, EXECUTED_BY, EXECUTED_TIME, GND_NODE_CLS, GND_NODE_IDX, HIDE_STEP, INCIDENT_DATA, INSERTSTATUS, INSERT_TIME, INSERT_USER, INSTRUCT_CONDITION_IDX, INSTRUCTED_TIME, INSTRUCTED_USER, LAST_RESULT_OF_OPERATION, LOCATION, MB_EDIT, NCG, OPERATION_OUTCOME, PARENT_STEP_ID, PHASES, PLANNED_OFFSET, PREV_STEP_IDX, RESULT_FEEDERS, RESULT_OF_OPERATION, REVISION, REVISION_DELETED, SAFETY_COND_ADDED, SAFETY_COND_REMOVED, SAFETY_DEV_STATUS, SAFETY_DOC_ID, SAFETY_INFO_TEXT, SEC_DEV_CLS, SEC_DEV_IDX, SRS_BITMASK, STATE_KEY, STEP_CLS, STEP_DESCRIPTION, STEP_GROUP_NUMBER, STEP_ORDER, STUDY_SAFETY_DEV_STATUS, STUDY_STATE_KEY, SWITCHING_ALIAS, UNDO_OPERATION_OUTCOME, UPDATE_TIME, UPDATE_USER, VERSION, ACT_KEY, SEQ_SHEET_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [75 parameters bound]
Running this command (from the NMS managed server's log directory on the weblogic machine) got the list of invalid phase values:
grep -h 'getPhaseString - Exception getting phase for' *.out* | sed 's/^.*ERROR/ERROR/' | sort | uniq -c
59 ERROR SHEET: getPhaseString - Exception getting phase for 8193
77 ERROR SHEET: getPhaseString - Exception getting phase for 8194
6 ERROR SHEET: getPhaseString - Exception getting phase for 8195
Checking the $NMS_CONFIG/sql/<project>_schema_control.sql file confirms that there are no entries with those PHASE_BITS values.
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 |