AnsweredAssumed Answered

Schema auto-update failed

Question asked by psrun on Jul 21, 2017
Latest reply on Oct 6, 2017 by sfuca

Hello

I 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 for the first time.

The error appears. I also tried to drop and create the database again, clear alf_data, indexes, temp, work directories and restarted the preinstalled Tomcat instance. The same error always appears.

- The DBMS is PostgreSQL 9.4.6

- There is no table in the database. So the table alf_bootstrap_lock does not exist.

- The database user has all privileges

- In alfresco-global.properties, the following properties are set as :

db.schema.update=true
db.schema.update.lockRetryCount=24
db.schema.update.lockRetryWaitSeconds=5

I don't understand since everything seems to be OK (no table in the database !) to force the schema update.

Do you know what I missed ?

 

Thank you in advance for your help

Putchhat SRUN

 

 

---

.app.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: 06210001 Schema auto-update failed

...

Caused by: org.alfresco.error.AlfrescoRuntimeException: 06210000 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.
        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1716)
        ... 23 more

Outcomes