topic Schema auto-update failed in Alfresco Forum

Schema auto-update failed

psrun — Fri, 21 Jul 2017 15:59:23 GMT

HelloI recently installed alfresco Community Edition 5.1.g with the installer and the moved files and configured everything to another preinstalled Tomcat instance (instead of the one embedded in the installer). I also replaced the alfresco.war and share.war by customized ones and the started Tomcat

Re: Schema auto-update failed

psrun — Fri, 21 Jul 2017 17:22:10 GMT

I just solved the problem : I had to definine public as the default schema for the database user used by alfresco to connect to the database :

ALTER USER @@LOGIN_BDD@@ SET search_path=public;

Sorry. I looked for the solution all the day before creating the thread but found it 1 hour after the creation.

Hope that can help other people.

Putchhat SRUN

Re: Schema auto-update failed

sfuca — Fri, 06 Oct 2017 14:39:12 GMT

Hi,

I also had the same problem with a MySQL DB. I've solved it by defining the alfresco schema/database as the default one.

Silvio