cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with LDAP binding . how to solve this error?

prasobhraj
Star Contributor
Star Contributor

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 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)

Please help me to resolve this issue.

Thanks,

Prasobhraj

11 REPLIES 11

Hi,

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

afaust
Legendary Innovator
Legendary Innovator

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...)