My Oracle Support Banner

Errors Running The Upgrade Assistant (ua) For Upgrading from 11g To 12c : MDS-92001: The upgrade is not supported from Oracle Metadata Services schema version / UPGCMP-05418: Oracle WebCenter Portal schema WEBCENTER does not contain the required indexes (Doc ID 2697546.1)

Last updated on AUGUST 10, 2020

Applies to:

Oracle WebCenter Portal - Version 11.1.1.8.8 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR

Running the upgrade assistant in readiness check mode for upgrading from 11.1.1.8 to 12.2.1.3 fails with the following errors:

 

ERROR

 

Oracle Metadata Services[<SCHEMA_PREFIX>_MDS] - failed
Oracel WebCenter Portal: Spaces and Services [<SCHEMA_PREFIX>_WEBCENTER] - failed

Oracle Metadata Services
MDS-92001: The upgrade is not supported from Oracle Metadata Services schema version of 11.1.1.6.0
Cause: An unsupported base schema version has being upgraded.
Action: Refer to the Oracle Metadata Services Upgrade Guide for supported versions to upgrade.

Oracle WebCenter Portal: Spaces and Services
UPGCMP-05418: Oracle WebCenter Portal schema WEBCENTER does not contain the required indexes.
Cause: The schema does not contain the indexes which are required to be present before upgrade.
Action: Ensure all required indexes are present before upgrade.

 

The upgrade assistant log shows the following errors:

[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Starting readiness check of Oracle Metadata Services.
[<DATE_TIME>] [MDS] [ERROR] [MDS-92001] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 83] [ecid: <ECID>,0] The upgrade is not supported from Oracle Metadata Services schema version of 11.1.1.6.0.
[<DATE_TIME>] [MDS] [ERROR] [] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 83] [ecid: <ECID>,0] Cause: An unsupported base schema version was being upgraded.
[<DATE_TIME>] [MDS] [ERROR] [] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 83] [ecid: <ECID>,0] Action: Refer to the Oracle Metadata Services Upgrade Guide for supported versions to upgrade.
[<DATE_TIME>] [MDS] [NOTIFICATION] [] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 83] [ecid: <ECID>,0] VERSION Schema <SCHEMA_PREFIX>_MDS is currently at unsupported version 11.1.1.6.0. No readiness checks will be performed.
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Finished readiness check of Oracle Metadata Services with status: FAILURE.
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Component ID=MDS, Schema=<SCHEMA_PREFIX>_MDS, Schema version=11.1.1.6.0, Status=VALID, Upgraded=false
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Finished readiness check of MDS.SCHEMA_UPGRADE with status: FAILURE.
...

[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Starting schema test: TEST_REQUIRED_TABLES Test that the schema contains all the required tables
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Run standard query: queryTableNames, Schema tag: WEBCENTER, Schema name: <SCHEMA_PREFIX>_WEBCENTER, Object: null
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] List of database TABLE objects for user: <SCHEMA_PREFIX>_WEBCENTER
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Completed schema test: TEST_REQUIRED_TABLES --> Test that the schema contains all the required tables +++ PASS
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Starting index test for table WC_AS_CUSTATTR: TEST_REQUIRED_INDEXES --> Test that the table contains all the required indexes
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Run standard query: queryIndexNames, Schema tag: WEBCENTER, Schema name: <SCHEMA_PREFIX>_WEBCENTER, Object: WC_AS_CUSTATTR
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] List of database INDEX objects for user: <SCHEMA_PREFIX>_WEBCENTER
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] EXCEPTION Table is missing a required index: WC_AS_CUSTATTR_FK
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] EXCEPTION Table is missing a required index: WC_AS_CUSTATTR_NI
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Completed index test for table WC_AS_CUSTATTR: TEST_REQUIRED_INDEXES --> Test that the table contains all the required indexes +++ FAIL
[<DATE_TIME>] [WEBCENTER] [NOTIFICATION] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] INFO Required indexes are not present, schema: WEBCENTER table: WC_AS_CUSTATTR
[<DATE_TIME>] [WEBCENTER] [ERROR] [UPGCMP-05418] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Oracle WebCenter Portal schema WEBCENTER does not contain the required indexes.
[<DATE_TIME>] [WEBCENTER] [ERROR] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Cause: The schema does not contain the indexes which are required to be present before upgrade.
[<DATE_TIME>] [WEBCENTER] [ERROR] [] [upgrade.WEBCENTER.WC1] [tid: 83] [ecid: <ECID>,0] Action: Ensure all required indexes are present before upgrade.
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Finished readiness check of Oracle WebCenter Portal: Spaces and Services with status: FAILURE.
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Component ID=WEBCENTER, Schema=<SCHEMA_PREFIX>_WEBCENTER, Schema version=11.1.1.4.0, Status=VALID, Upgraded=false
[<DATE_TIME>] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 83] [ecid: <ECID>,0] Finished readiness check of WEBCENTER.WC1 with status: FAILURE.

 

 

EXPECTED BEHAVIOR

Expected the upgrade assistant t o run without issues.




STEPS

The issue can be reproduced at will with the following steps:

  1. Run the upgrade assistant in readiness mode as follows:

    ./ua –readiness check


  2. The above will fail with the above errors.

 

 

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.