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:

Symptoms

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

• Failed saving users' data.
  
  

The P6 Web Access logs contain the following error:

ERROR com.primavera.bo.remotable.RemoteRequest ?:? Failed updating data for web pm com.primavera.guisupport.users.data.UsersDataSaver
com.primavera.bo.remoting.RemoteDataException: Failed saving users' data.
    at com.primavera.guisupport.users.data.UsersDataSaver.a(Unknown Source)
    at com.primavera.guisupport.users.data.UsersDataSaver.a(Unknown Source)
...
   Caused by: com.primavera.PhoenixException: DBEngine.executeSelect: {SELECT users.user_id UserId FROM users WHERE ((users.user_id IN (25, 1204)))}
   null

Cause

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