Orpm_reset_priv.sql Script Is Not Executing in the Last Steps of migrate.bat When Migrating One Oracle Instance to Another in P6 EPPM 16.2.4.0
(Doc ID 2445925.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.4.0 and laterInformation in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

When migrating from one oracle instance to another in P6 EPPM 16.2.4.0 using migrate.bat, orpm_reset_priv.sql script is not executing in the last steps of migrate.bat on a target oracle instance. The migrate runs successfully, but none of the roles are created except the PM_BG_JOB_ROLE. The migration is NOT running the orpm_reset_priv script that creates these new roles.

EXPECTED BEHAVIOR

Migration from one oracle instance to another in P6 EPPM 16.2.4.0 should be done successfully.

Steps to Reproduce:

1. Create an Oracle instance with schema users 2. Create another Oracle instance without the schema users for migration 3. Run Migrate.bat from the 16.2.4.0 media 4. Notice in step creating Reporting Views, orpm_reset_priv.sql is not executing at end of migration on a target oracle instance.