The synchronizeUserInformation Script Fails with: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint WC_UNQ_PPL_PROF_USR_ATTR violated (Doc ID 3007528.1)

Last updated on MAY 16, 2024

Applies to:

Symptoms

Running the synchronizeUserInformation script fails with the following error:

ERROR 

The script will fail with ORA-00001 when there are more that one row for the same user in WC_AS_ACTOR_DETAIL.

STEPS

1. Run the following command to create a mapping file of users whose GUID has changed, that is, the GUID currently stored for a user in WebCenter Portal, does not match the GUID that is stored for the same user in the identity store.
   
   
   synchronizeUserInformation(appName='webcenter', operationType='RENAME_GUID_CREATE_MAPPING_FILE', fileName='GUIDMappingFile.properties', component='ALL', dbVendor='Oracle', dbHostNPort='<HOST:PORT>', dbName='<DATABASE_NAME>', dbSchemaName='<WEBCENTER_SCHEMA>',verbose='true')
    
   
   
2. When running the script returns this error:
    
   
   Exception occurred while updating user userid[<USER_GUID>].

   java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>_WEBCENTER.WC_UNQ_PPL_PROF_USR_ATTR) violated 

Cause

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