My Oracle Support Banner

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 MARCH 22, 2022

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 or new tablespaces
  7. Create new users
  8. Run the Migrate.bat utility and observe error

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
References


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