My Oracle Support Banner

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 AUGUST 11, 2023

Applies to:

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


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)))}


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.