My Oracle Support Banner

Work Area Upgrade Installation Fails With ORA-20003: "The object is not in a valid state" After Table Column Attribute Changes From NUMBER To VARCHAR2 (Doc ID 2665918.1)

Last updated on MAY 05, 2020

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.9.1 and later
Information in this document applies to any platform.

Symptoms

On : LSH 2.4.9.1,

the Work Area upgrade installation is failing with ORA-20003: "The object is not in a valid state" after the table column attribute is changed from NUMBER to VARCHAR2.

This change is constructive and allowed in LSH. The table with the changed column has no data.

Changes

The LSH table column is changed from NUMBER to VARCHAR2.

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
References


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