No property value exists for ID 777860

  • A+
所属分类:使用集成

今天突然发现之前配置的AD域账号同步出错,导致无法成功同步,报错信息如下:

2019-09-05 10:11:11,615 ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-9] 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 777860]
        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 777860
        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

具体原因不明,但还是在网上找到了解决办法,当是临时对策吧

1、从alf_prop_unique_ctx删除其中prop1_id = 777860

2、从alf_prop_root删除,其中id = 777860

重启Alfresco,问题解决。

相关参考链接:

https://community.alfresco.com/thread/233887-synchronisation-impossible-no-property-value-exists-for-id

https://community.alfresco.com/thread/242886-ldap-sync-fails-after-cleanalfproptablespostexecsqlcleanalfproptablessql

发表评论

您必须才能发表评论!