Hi,
the issue still exists . can you please help me to sort this out?
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...)
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.