Error: "Failed Saving Users' Data." And Cannot Create Or Modify Users In P6 When Connecting To A SQL Server Database

(Doc ID 1487210.1)

Last updated on MAY 02, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.0 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Jul-2014***


The following error occurs when attempting to add or edit a user in P6 under Administer, User Access, Users:

The P6 Web Access logs contain the following error:

ERROR ?:? Failed updating data for web pm Failed saving users' data.
    at Source)
    at Source)
   Caused by: com.primavera.PhoenixException: DBEngine.executeSelect: {SELECT users.user_id UserId FROM users WHERE ((users.user_id IN (25, 1204)))}


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