nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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?

catalina.out__1.log.zip

Find more posts tagged with

Comments

darkstar1

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

mrahmoun

hey, did you solved this bug? thanks.

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

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.