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

[lelmarir]

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 31183425
        at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyById(AbstractPropertyValueDAOImpl.java:841)
        at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.getPropertyUniqueContext(AbstractPropertyValueDAOImpl.java:1293)
        at org.alfresco.repo.attributes.AttributeServiceImpl.setAttribute(AttributeServiceImpl.java:175)
        at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:2080)
        at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:2076)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:454)
…
‍‍‍‍‍‍‍‍‍‍‍

(see attachment for complete stack)

 2015-07-28 09:55:41,160  ERROR [solr.tracker.AbstractTracker] [SolrTrackerScheduler_Worker-1] Tracking failed
 org.alfresco.service.cmr.dictionary.DictionaryException: 06280000 d_dictionary.model.err.no_model
        at org.alfresco.repo.dictionary.AbstractDictionaryRegistry.getModel(AbstractDictionaryRegistry.java:97)
        at org.alfresco.repo.dictionary.DictionaryDAOImpl.getCompiledModel(DictionaryDAOImpl.java:308)
        at org.alfresco.solr.AlfrescoSolrDataModel.getM2Model(AlfrescoSolrDataModel.java:1220)
…
‍‍‍‍‍‍‍‍

and

2015-07-28 11:18:40,686  ERROR [quartz.core.JobRunShell] [SolrTrackerScheduler_Worker-1] Job Solr.CoreWatcher threw an unhandled Exception:
 org.alfresco.service.cmr.dictionary.DictionaryException: 06280000 Failed to compile model sys:systemmodel
        at org.alfresco.repo.dictionary.CompiledModel.<init>(CompiledModel.java:108)
        at org.alfresco.repo.dictionary.M2Model.compile(M2Model.java:163)
        at org.alfresco.repo.dictionary.DictionaryDAOImpl.putModelImpl(DictionaryDAOImpl.java:266)
…
Caused by: org.alfresco.service.namespace.NamespaceException: URI http://www.alfresco.org/model/dictionary/1.0 cannot be imported as it is not defined (with prefix d
…
‍‍‍‍‍‍‍‍‍‍

i also get a lot of other errors and i don't know what is going on:

java.lang.ArrayIndexOutOfBoundsException
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Invalid byte 1 of 1-byte UTF-8 sequence.
java.net.SocketTimeoutException: Read timed out
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.read(SocketInputStream.java:152)
…

‍‍‍‍‍‍‍‍‍‍

Can anyone help?

[darkstar1]

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

[darkstar1]

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

[mrahmoun]

hey, did you solved this bug? thanks.

[darkstar1]

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

[darkstar1]

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.