My Oracle Support Banner

"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 later
Oracle 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


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