My Oracle Support Banner

Getting SQL Execution Error (ORA-01449) During Argus DLP Database Upgrade From 5.0.1 To 5.0.2 (Doc ID 1098676.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 5.0.1 to 5.0.1 [Release 5.0.0]
Information in this document applies to any platform.

Symptoms

Get the following error when upgrading Argus Safety DLP Database from 5.0.1 to 5.0.2 :

ALTER TABLE DLP_OWNER.DLP_CASE_PREGNANCY ADD (CONSTRAINT PK_DLP_CASE_PREGNANCY PRIMARY KEY (CASE_ID,PARENT,DLP_REVISION_NUMBER));

SQL execution error, ORA-01449: column contains NULL values; cannot alter to NOT NULL

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
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.