EPPM Configuration Fails When Upgrading Oracle DB and Creating a Read Only Database User (Doc ID 2283995.1)

Last updated on JULY 10, 2017

Applies to:

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

Symptoms

When attempting to upgrade a database using the EPPM Configuration utility, the following error occurs:

ERROR

OUTPUT>[ERROR] [2017-05-08 10:45:14] Database Error: error number=922
OUTPUT>[ERROR] [2017-05-08 10:45:14] Error Message: ORA-00922: missing or invalid option
OUTPUT>ORA-06512: at line 6
OUTPUT>
OUTPUT>USER [WARN] : Could not complete because the job "Run SQL Script orpm_create_ro_users.sql" failed.
OUTPUT>com.primavera.database.tools.DatabaseToolException: ORA-00922: missing or invalid option
OUTPUT>ORA-06512: at line 6

STEPS

The issue can be reproduced at will with the following steps:
1.  Launch the EPPM Configuration utility.
2.  Select upgrade an existing database.
3.  Check the option box to create a read only user.
4.  Enter password that begins with a numeric character or contains special characters.
5.  Observe the reported error.

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