topic Synchronization Aborted due to DataIntegrityViolationException in Alfresco Forum

Synchronization Aborted due to DataIntegrityViolationException

asharma — Tue, 16 Apr 2019 12:26:27 GMT

Good day All,I see one of the error in Catalina.out file which is related to missing one of the id value. Please see the below logs and Can you please suggest how to get rid of this. 2019-04-16 06:10:36,405 ERROR [security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-2] Synchroniz

Re: Synchronization Aborted due to DataIntegrityViolationException

angelborroy — Wed, 17 Apr 2019 14:20:11 GMT

This problem has been reported previously, it's due to a problem in the database.

This thread explains it clearly: (in French)

Re: Synchronization Aborted due to DataIntegrityViolationException

asharma — Thu, 18 Apr 2019 10:51:42 GMT

I've gone through it.

However, Is it okay to delete the entry from the respective tables alf_prop_unique_ctx and alf_prop_root?

Re: Synchronization Aborted due to DataIntegrityViolationException

ainsof — Mon, 06 Apr 2020 03:43:37 GMT

Im having the same issue. Can someone share the French link that @angelborroy mentioned? Also could you share your solution @asharma ? Thnx in advance

Updated: Nevermind I found a fix in another post - https://hub.alfresco.com/t5/alfresco-content-services-forum/ldap-sync-fails-after-cleanalfproptablespostexec-sql/m-p/40015/highlight/false#M2224

Re: Synchronization Aborted due to DataIntegrityViolationException

EddieMay — Mon, 06 Apr 2020 12:36:40 GMT

Hi @ainsof,

Thanks for updating and providing the link.

Re: Synchronization Aborted due to DataIntegrityViolationException

LeoMattioli — Fri, 03 Feb 2023 08:10:10 GMT

I have found the French blog post link, here it is for future references: https://hub.alfresco.com/t5/french-group/synchronisation-impossible-no-property-value-exists-for-id/m-p/187211