Event Code: PPUSP-4085-8, Message: "ORA-01950: No Privileges On Tablespace 'PMDB_XXX1'" (Doc ID 2052730.1)

Last updated on MAY 08, 2017

Applies to:

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

Symptoms

When performing various actions within P6, the following error occurs:

ERROR
-----------------------
Event Code: PPUSP-4085-8
Message:
  PasteProjectUsingSP returned error -1
  General error in ACTIVITY_COPY
  ORA-01950: no privileges on tablespace 'PMDB_DAT1'
  Unable to copy tasks in NEW_WBS
  Error creating new wbs

The ORA-01950: No privileges on Tablespace 'pmdb_xxxx1' can occur during any action in P6. It is not necessarily tied to a particular P6 function, but instead, can occur whenever a tablespace needs to extend and the db owner does not have the proper privileges.


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

  1. Log in to P6
  2. Browse To Project, Maintain Baseline
  3. Select Add, and choose to add a copy of existing project as a baseline
  4. Note the error which occurs


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create a baseline project.

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