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 laterInformation 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:
- Install P6 PPM
- Launch migrate.bat to perform a PPM to EPPM schema migration
- Select Schema Migration
- Select Oracle database
- Selected target and entered in connection details
- Choose existing or new tablespaces
- Create new users
- 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 |