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 APRIL 05, 2018

Applies to:

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

Symptoms

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

Changes

 

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