OC466 Upgrade From OC451: One Or More Studies Have Not Been Migrated To The New Approval/Verification Data Model (Doc ID 1538583.1)

Last updated on DECEMBER 04, 2019

Applies to:

Goal

The customer is upgrading from 4.5.1 -> 4.6.2 -> 4.6.6, with database exp/imp.
When they ran the steps in section 7.2 in the 4.6.6 Release Notes, "Upgrading Oracle Clinical Databases to Patch Set 4.6.6" (Note: 1459178.1) the database upgrade process terminated with errors.

1. The query_to_detect_if_migration_is_run_for_study.log contains the following information:

64 studies report : MIGRATE SCRIPT NOT EXECUTED FOR STUDY AND NO NEW CRFS HAVE BEEN CREATED SINCE
75 studies report : STUDY HAS NO CRFS OR CRFS WERE SOFT DELETED

2. The upgrade_ocprod_3_5_2013_5_59_57PM.log contains the following:

64 studies reported as not migrated (so tallies with the above).

3. However, the upgrade log reports the following errors:

MIGERROR: One or more studies have not been migrated to the new approval/verification data model.
Also, your installation is now or at one time was a replicated environment which requires special handling.
Please contact Oracle Support for assistance in migrating these studies and for guidance with your upgrade.

One or more studies have not been migrated to the new approval/verification data model.
Please contact Oracle Support for assistance in migrating these studies.

4. Above seems to be a 'red herring' error and is incorrectly flagging the environment as Replicated as confirmed by the output of the following:

SQL> select ocl_appver_val_migrate.isThisRepldEnv from dual;
N

From the above scenario, what should be the next course of action?

Solution

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