My Oracle Support Banner

Error: "This user is already logged in. Please use another login name" When Logging into P6 Professional (Doc ID 891328.1)

Last updated on JUNE 21, 2022

Applies to:

Primavera P6 Professional Project Management - Version 5.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 5.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.2.1.1 and later
All Platforms

Symptoms

When logging into P6 Project Management or Methodology Management the user receives one of the following error message:

This user is already logged in.  Please use another login name.

A problem has occurred with your application license: Cannot log on new user, maximum number of concurrent user(s) allowed is <#>. Click OK if you would like to see a license summary.

License not available for the Integration API

User still showing in USESSION, PROJSHAR, and UPKLIST tables, although they are not logged in.

An Admin Superuser is in the application to correct licensing related issue. Please login after the problem is corrected

Exception EprmDBSQLExecutionFailure in module Pm.exe - Violation of PRIMARY KEY contstraint 'pk_usession'. Cannot insert duplicate key in object 'dbo.USESSION'.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 If the user session was terminated abnormally resulting in orphaned database records,  OR  closing Web Access abnormally is keeping a Project Management session locked:
 Instruction For On-Premise Customers
 Instruction For Cloud Customers
 
 If the database has not been configured to run background jobs:
 
 If the client application was not configured to use the public or private user account for connection to the database:
 
 If the the Private Database Login stored in the PUBUSER schema table is configured with the schema owner instead of the privileged user account:
 
 If the application is being run through a Citrix MetaFrame Server Farm or a Cluster of Windows Terminal Servers and the session is not being terminated on the database engine:
 If Citrix Anonymous User Accounts are used at login of Citrix to launch the published application:
 
 If launching Time Approval is using a Project Management license and is causing conflict with Project Management client login:
 
 If the Privuser schema user is assigned to the dbo role on a Microsoft SQL Server database:
 
 If the user record already exists in USESSION after a database migration:
 
 Solution for "An incorrect Default Schema is set":
 
 If views are missing for the private database user:
References

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