Error: "Error in Run SQL Script orppm_pm_migrate.sql: DatabaseToolException (ORA-01917: user or role 'PXRPTUSER' does not exist)" When Attempting to Perform a Schema Migration Using the Migrate.bat/sh Utility.

(Doc ID 2329602.1)

Last updated on DECEMBER 12, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When performing a PPM to EPPM schema migration, using the migrate.bat utility, the following error is observed:

ERROR

Error in Run SQL Script orppm_pm_migrate.sql: DatabaseToolException (ORA-01917: user or role 'PXRPTUSER' does not exist) for query::GRANT EXECUTE ON SECPAC TO pxrtpuser

STEPS TO DUPLICATE

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

  1. Install P6 PPM
  2. Launch migrate.bat to perform a PPM to EPPM schema migration.
  3. Select Schema Migration.
  4. Select Oracle database.
  5. Selected target and entered in connection details.
  6. Choose existing tablespaces.
  7. Create new users.
  8. Run the Migrate.baT utility and observe error.

Changes

 

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