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.
Last updated on DECEMBER 12, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
When performing a PPM to EPPM schema migration, using the migrate.bat utility, the following error is observed:
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 tablespaces.
- Create new users.
- Run the Migrate.baT utility and observe error.
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