Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

lelmarir — Tue, 28 Jul 2015 13:46:52 GMT

Hi all,i'm in some real trouble, today the server give me this error:2015-07-28 09:54:50,919 ERROR [security.sync.ChainingUserRegistrySynchronizer] [localhost-startStop-1] Synchronization aborted due to error org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 3

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

darkstar1 — Tue, 11 Jul 2017 18:14:59 GMT

I'm getting this error also. Did you ever solve it? I could use a clue in how to debug this issue.

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

mrahmoun — Wed, 19 Jul 2017 15:52:40 GMT

hey, did you solved this bug? thanks.

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

darkstar1 — Mon, 24 Jul 2017 08:00:39 GMT

I finally got access to the error logs and located the first instance of the error:

2017-06-10 03:02:24,312 INFO [schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-10] Processing from 610000 to 620000 rows of 616093 rows from table temp_prop_val_obs. 2017-06-10 03:02:24,313 INFO [schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-10] Processing from 0 to 1 rows of 0 rows from table temp_del_double1. 2017-06-10 03:02:24,314 INFO [schema.script.ScriptExecutorImpl] [DefaultScheduler_Worker-10] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-PostgreSQLDialect-Update-3448339377307879251.sql (Copied from alfresco/dbscripts/utility/org.hibernate.dialect.PostgreSQLDialect/CleanAlfPropTablesPostExec.sql). 2017-06-10 03:06:16,734 ERROR [quartz.core.JobRunShell] [DefaultScheduler_Worker-5] Job DEFAULT.ldapPeopleJobDetail threw an unhandled Exception: org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 3384016 at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyById(AbstractPropertyValueDAOImpl.java:848) at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyUniqueContext(AbstractPropertyValueDAOImpl.java:1300) at org.alfresco.repo.attributes.AttributeServiceImpl.setAttribute(AttributeServiceImpl.java:182) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$10.execute(ChainingUserRegistrySynchronizer.java:2262) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$10.execute(ChainingUserRegistrySynchronizer.java:1) at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:464) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncEnd(ChainingUserRegistrySynchronizer.java:2252) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:759) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:471) at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:53) at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:555) at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:49) at org.quartz.core.JobRunShell.run(JobRunShell.java:216) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563) 2017-06-10 03:06:16,737 ERROR [quartz.core.ErrorLogger] [DefaultScheduler_Worker-5] Job (DEFAULT.ldapPeopleJobDetail threw an exception. org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 3384016] at org.quartz.core.JobRunShell.run(JobRunShell.java:227) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563) Caused by: org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 3384016 at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyById(AbstractPropertyValueDAOImpl.java:848) at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyUniqueContext(AbstractPropertyValueDAOImpl.java:1300) at org.alfresco.repo.attributes.AttributeServiceImpl.setAttribute(AttributeServiceImpl.java:182) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$10.execute(ChainingUserRegistrySynchronizer.java:2262) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$10.execute(ChainingUserRegistrySynchronizer.java:1) at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:464) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncEnd(ChainingUserRegistrySynchronizer.java:2252) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:759) at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:471) at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:53) at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:555) at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:49) at org.quartz.core.JobRunShell.run(JobRunShell.java:216) ... 1 more

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

darkstar1 — Mon, 31 Jul 2017 10:33:04 GMT

Not yet as it was a test server. I will however look at it again today.

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

darkstar1 — Tue, 19 Sep 2017 09:37:03 GMT

Apologies for the late reply. I didn't find out "the why" of the bug but I did solve it. I had to remove some values from some db tables and the bug went away. I did it about month ago now so I'll have to look into what I did exactly but I dug into it and it seems the issue arises from some update scripts that ran and didn't clean up. Can't remember exactly how I found out but I'll look into it again once I have to upgrade production.

Again really sorry I didn't document what I was doing, but I really didn't think that what I was doing would solve it until it was solved and I was really busy at the time so replying just kind of escaped my mind. Not to mention that manually tampering with the db, is something I'd recommend.

topic Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425 in Alfresco Archive

Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425

Re: Synchronization aborted due to error DataIntegrityViolationException: No property value exists for ID 31183425