Readiness Check fails During The WebCenter Content(WCC) Upgrade Due To Invalid Data Type for Column(s) (Doc ID 2693937.1)

Last updated on AUGUST 01, 2024

Applies to:

Symptoms

ISSUE
-----------------------
While upgrading WebCenter Content, the readiness checks fails due to invalid data types.


ERROR
-----------------------
Starting datatype test for table <TABLE_NAME>: TEST_COLUMN_DATATYPES_V2 --> Test that all table columns have the proper data types
  EXCEPTION
 Please check the Data Type of columns. The type - DATE is different for column - <COLUMN_NAME> of the table - <TABLE_NAME>
 The type of column should be :
DATE
 But actually it is :
TIMESTAMP


STEPS TO REPLICATE
-----------------------
1. Initiate the Content Server upgrade.
2. Run the readiness check.
3. It fails the readiness check with above mentioned errors.


BUSINESS IMPACT
-----------------------
Admin(s) are not able to complete the Content Server upgrade.

Excerpt from the Upgrade Assistant log:

Cause

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