Upgrading MWM Producing Error: ERROR: ORA-02296: cannot enable (MWMDEV1ADM.) - null values found (Doc ID 1555916.1)

Last updated on JUNE 01, 2017

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.1.0.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade to MWM Version 2.1.0.4.0 with the following script:


__IF_EXISTS__
SELECT 1 FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'M1_TO_DEV_STATUS' AND COLUMN_NAME = 'MDT_ID'
/
__ELSE__

ALTER TABLE M1_TO_DEV_STATUS ADD MDT_ID CHAR(14) / UPDATE M1_TO_DEV_STATUS SET MDT_ID=(SELECT MDT_ID FROM M1_MDT WHERE ROWNUM
/
ALTER TABLE M1_TO_DEV_STATUS MODIFY MDT_ID CHAR(14) NOT NULL / ALTER TABLE M1_TO_DEV_STATUS ADD CONSTRAINT MT134R0 FOREIGN KEY (MDT_ID) REFERENCES M1_MDT(MDT_ID) / __ENDIF__


...the ORS upgrade process produces the following error:


Processing file 210_M1_BP_BPDATA.sql ...

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