"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:

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

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