PostgreSQL - ERROR o.h.tool.hbm2ddl.SchemaUpdate - could not complete schema update
Symptoms
When upgrading the application, the following error is shown in the terminal:
2019-09-20 17:45:58,806 [RMI TCP Connection(4)-127.0.0.1] ERROR o.h.tool.hbm2ddl.SchemaUpdate - could not complete schema updateCause
In PostgreSQL version 9.6, some table and column information about the schema changed.
More information at https://github.com/rundeck/rundeck/issues/2354
Resolution
- Stop OpenKM
- Replace the driver in $TOMCAT_HOME/libs with a newer version
- Edit OpenKM.cfg and set the hbm2ddl parameter to update.
- Start OpenKM
More information about PostgreSQL JDBC drivers at https://jdbc.postgresql.org/download.html
Choose the right driver version. For example, for PostgreSQL 10.10 with Java JDK version 1.8, you can use PostgreSQL JDBC 4.2 Driver, 42.2.8.
Properties
| Properties | |
|---|---|
|
Date |
2019-09-20 |
|
Applies to |
|
Keywords
- AllVersions