DPS Table Upgrades Executed On Catalog Switch A/B Schemas Incorrectly During Migration Resulting in Error: ORA-00942: table or view does not exist (Doc ID 2146654.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Commerce Platform - Version 10.0 and later
Information in this document applies to any platform.

Symptoms

When upgrading Oracle Commerce to version 10.2, the ATG Upgrade and Migration Guide [10.1.2 to 10.2] instructs you to execute the run_dcs_switching_all.{bat|sh} script to migrate the switching schemas. This script executes the following sub-scripts:

The script fails when executing the run_dps_core.{bat|sh} script because it references DPS related tables that don't exist in the switching schemas. These may fail with the following error: ORA-00942: table or view does not exist 

Changes

The database schemas being upgraded were created manually and without the use of CIM. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms