06-28-2018 04:41 AM
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
09-10-2018 11:46 PM
Hi,
the issue still exists . can you please help me to sort this out?
09-12-2018 04:54 AM
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...)
Explore our Alfresco products with the links below. Use labels to filter content by product module.