[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 24, 2014

Applies to:

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

Symptoms

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: xxxx] [ecid: 0000JmedlL14Yr55zRWByW1H4Fhk0000Gm,0] [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: xxxx] [ecid: 0000JmedlL14Yr55zRWByW1H4Fhk0000Gm,0] [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.

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