My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle WebCenter Content - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

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

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
References


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