topic Re: Issue with LDAP binding . how to solve this error? in Alfresco Forum

Issue with LDAP binding . how to solve this error?

prasobhraj — Thu, 28 Jun 2018 08:41:02 GMT

Hi,I am getting below error . because of this users properties are not properly getting in alfresco. for eg first name, last name , email etc.ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-10] Job (DEFAULT.ldapPeopleJobDetail threw an exception.org.quartz.SchedulerException: Job threw

Re: Issue with LDAP binding . how to solve this error?

cesarista — Thu, 28 Jun 2018 09:03:55 GMT

Hi:

You should increase your logs to DEBUG, and force an ldap sync, for getting more details.

log4j.logger.org.alfresco.repo.security.sync=debug

Regards.

--C.

Re: Issue with LDAP binding . how to solve this error?

afaust — Thu, 28 Jun 2018 09:57:39 GMT

That sounds like a data inconsistency between your database and your Alfresco cache state. When the LDAP job is run it will store some data via the AttributeService in the alf_prop_xx tables. Some reusable data entries are cached in-memory and when those cached entries no longer exist in the database but Alfresco tries to do an insert referencing their ID, then this kind of error occurs. Typically this is a result of manually messing with the database (which should never be done) or an improperly setup cluster.

You also likely excluded a lot of information by only posting the first few lines of the error. Please always attach the full log so that people in this community that know more about Alfresco can also check into the details based on that information.

Re: Issue with LDAP binding . how to solve this error?

prasobhraj — Thu, 28 Jun 2018 10:08:40 GMT

Hi,

please see the logs in details below. Advice me how to get this solved

2018-06-28 01:00:35,334 ERROR [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-2] Synchronization aborted due to error
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 01:00:35,342 ERROR [org.quartz.core.JobRunShell] [DefaultScheduler_Worker-2] Job DEFAULT.ldapPeopleJobDetail threw an unhandled Exception:
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 01:00:35,342 ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-2] 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 366887]
   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 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   ... 1 more
2018-06-28 02:00:34,467 ERROR [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-1] Synchronization aborted due to error
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 02:00:34,477 ERROR [org.quartz.core.JobRunShell] [DefaultScheduler_Worker-1] Job DEFAULT.ldapPeopleJobDetail threw an unhandled Exception:
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 02:00:34,478 ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-1] 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 366887]
   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 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   ... 1 more
2018-06-28 03:00:38,849 ERROR [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-10] Synchronization aborted due to error
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 03:00:38,861 ERROR [org.quartz.core.JobRunShell] [DefaultScheduler_Worker-10] Job DEFAULT.ldapPeopleJobDetail threw an unhandled Exception:
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 03:00:38,862 ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-10] 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 366887]
   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 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   ... 1 more
2018-06-28 04:00:33,908 ERROR [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-1] Synchronization aborted due to error
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 04:00:33,915 ERROR [org.quartz.core.JobRunShell] [DefaultScheduler_Worker-1] Job DEFAULT.ldapPeopleJobDetail threw an unhandled Exception:
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 04:00:33,915 ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-1] 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 366887]
   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 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   ... 1 more
2018-06-28 05:00:36,743 ERROR [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-8] Synchronization aborted due to error
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 05:00:36,749 ERROR [org.quartz.core.JobRunShell] [DefaultScheduler_Worker-8] Job DEFAULT.ldapPeopleJobDetail threw an unhandled Exception:
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 05:00:36,749 ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-8] 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 366887]
   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 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   ... 1 more
2018-06-28 06:00:37,625 ERROR [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-4] Synchronization aborted due to error
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 06:00:37,632 ERROR [org.quartz.core.JobRunShell] [DefaultScheduler_Worker-4] Job DEFAULT.ldapPeopleJobDetail threw an unhandled Exception:
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 06:00:37,632 ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-4] 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 366887]
   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 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   ... 1 more
2018-06-28 07:00:36,913 ERROR [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-7] Synchronization aborted due to error
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 07:00:36,920 ERROR [org.quartz.core.JobRunShell] [DefaultScheduler_Worker-7] Job DEFAULT.ldapPeopleJobDetail threw an unhandled Exception:
org.springframework.dao.DataIntegrityViolationException: No property value exists for ID 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
2018-06-28 07:00:36,921 ERROR [org.quartz.core.ErrorLogger] [DefaultScheduler_Worker-7] 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 366887]
   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 366887
   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:2159)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer$8.execute(ChainingUserRegistrySynchronizer.java:1)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.notifySyncStart(ChainingUserRegistrySynchronizer.java:2127)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronizeInternal(ChainingUserRegistrySynchronizer.java:593)
   at org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer.synchronize(ChainingUserRegistrySynchronizer.java:448)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob$1.doWork(UserRegistrySynchronizerJob.java:46)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)
   at org.alfresco.repo.security.sync.UserRegistrySynchronizerJob.execute(UserRegistrySynchronizerJob.java:42)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)

Re: Issue with LDAP binding . how to solve this error?

afaust — Thu, 28 Jun 2018 13:32:34 GMT

Just as I thought - some entry in the DB table alf_prop_value has been deleted that is either being referenced from somewhere (unlikely, since there are constraints on DB columns) or still used in some cached data.

Does the problem still persist after a restart of the Alfresco server?

Re: Issue with LDAP binding . how to solve this error?

prasobhraj — Sun, 01 Jul 2018 10:01:43 GMT

Hi,

Yes the problem still there.

Re: Issue with LDAP binding . how to solve this error?

afaust — Sun, 01 Jul 2018 13:02:46 GMT

What type of database are you using? Are referential integrity checks enabled? Has the Alfresco schema been altered in some fassion (manually)?

Re: Issue with LDAP binding . how to solve this error?

prasobhraj — Sun, 01 Jul 2018 13:16:27 GMT

Hi,

I am using mysql. I don't think schema is altered manually. Is there any way to check it?

Re: Issue with LDAP binding . how to solve this error?

afaust — Mon, 02 Jul 2018 20:20:43 GMT

If you didn't do it, the it hasn't been. Did you set up MySQL to use InnoDB database engine or MyISAM?

Re: Issue with LDAP binding . how to solve this error?

prasobhraj — Wed, 04 Jul 2018 12:54:32 GMT

Hi,

Its using InnoDB.

Re: Issue with LDAP binding . how to solve this error?

prasobhraj — Tue, 11 Sep 2018 03:46:16 GMT

Hi,

the issue still exists . can you please help me to sort this out?

Re: Issue with LDAP binding . how to solve this error?

afaust — Wed, 12 Sep 2018 08:54:33 GMT

Recently had a customer with a similar error and a restart fixed it (since as I mentioned earlier the DB state is typically kept consistent). In your case I can't explain / don't have any idea what may have caused your current state. It can theoretically be fixed manually via SQL, but the data structures are generally quite complex to understand, so I am quite hesitant to suggest / provide any SQL for this as it is very likely it will be used incorrectly and end up breaking your system even more...

Essentially, you will need to remove the alf_prop_* entries referencing that non-existing property value, and cascade that cleanup to all entries referencing those removed alf_prop_* entries (and so on, and so on...)