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 126.96.36.199 and later
Information in this document applies to any platform.
On : LSH 188.8.131.52,
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.
The LSH table column is changed from NUMBER to VARCHAR2.
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