[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 02, 2022

Applies to:

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

Cause

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