How To Rebuild The OBSPROJ Table In P6?
(Doc ID 908570.1)
Last updated on FEBRUARY 07, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 6.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.104.22.168 to 22.214.171.124 [Release 16.1]
This document provides instruction for rebuilding the OBSPROJ table in Project Management.
- The OBSPROJ table is used to store security at the Project/EPS level and determines a users rights to access project data. This information is then used to populate the uaccess table. Invalid records in the OBSPROJ table can result in an attempt to add duplicate entries in the uaccess table resulting in login failure.
- The OBSPROJ table is a working table and does not store any P6 data. Therefore, it may be safely rebuilt without compromising P6 data.
- It is suggested to complete the OBSPROJ rebuild while users are logged out of P6 Professional and P6 Web, and ensure no users login while the rebuild is running.
- If P6 Professional Users are unable to see projects after making changes to OBS (Responsible Manager) assignments, please see the following: Document 907647.1 - "P6 Projects are missing, OBSPROJ table not being updated as expected".
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
|Rebuilding The OBSPROJ Table For SQL Server|
|Rebuilding The OBSPROJ Table For Oracle|