My Oracle Support Banner

[SQLServer JDBC Driver][SQLServer] Violation of UNIQUE KEY Constraint 'WC_UNQ_PPL_PROF_USR_ATTR' Message when Webcenter is installed against MS SQLServer (Doc ID 1626778.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle WebCenter Portal - Version and later
Information in this document applies to any platform.


Webcenter is installed against MS SQLServer and configured with MS-AD for authentication. The following warnings are displayed when the user logs in to the application:

[2013-02-05T13:59:02.459+00:00] [WC_CustomPortal] [NOTIFICATION] [] [oracle.webcenter.peopleconnections.profile.internal.model.ProfileSyncManagerImpl] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [APP: LACSP_Appl#V2.0] Time taken to sync one batch (of 1) profiles :31
[2013-02-05T13:59:02.474+00:00] [WC_CustomPortal] [WARNING] [] [oracle.webcenter.framework.service] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>] [APP: LACSP_Appl#V2.0] 2013-02-05 13:59:02.474--UnitOfWork(172122555)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException[[
Internal Exception: weblogic.jdbc.sqlserverbase.ddc: [FMWGEN][SQLServer JDBC Driver][SQLServer]Violation of UNIQUE KEY constraint 'WC_UNQ_PPL_PROF_USR_ATTR'. Cannot insert duplicate key in object 'CUSTWCT1_WEBCENTER.WC_PPL_CONN_PROFILE_CUST_ATTRS'.
Error Code: 2627

Steps to reproduce:

  1. Install MS SQL Server.
  2. Install MS AD server.
  3. Install Webcenter against SQLServer.
  4. Configure AD for authentication.
  5. Login to webcenter spaces as AD users.
  6. Review the logs to see the warning messages.


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.