Error when deploying a new bdm.zip on Server installed with PostgreSQL 9.6 and higher

marielle.spiteri
Blog Categories: 

Component: Engine | Version: N/A

I cannot deploy the bdm.zip in my portal and see this error in the bonita logs:

13-Feb-2018 00:19:22.751 WARNING [http-nio-8080-exec-6] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 0, SQLState: 42703
13-Feb-2018 00:19:22.751 SEVERE [http-nio-8080-exec-6] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions ERROR: column am.amcanorder does not exist
Position: 407
13-Feb-2018 00:19:22.751 SEVERE [http-nio-8080-exec-6] org.hibernate.tool.hbm2ddl.SchemaUpdate.execute HHH000299: Could not complete schema update
java.lang.NullPointerException 

Answer

As per Bonita supported Hardware and software requirements matrix (https://documentation.bonitasoft.com/bonita/7.8/hardware-and-software-re...) , PostgreSQL supported version are 9.3 and higher in the 9.3.x line.
So the jdb driver postgresql-9.3-1102-jdbc41.jar that is provided in the product out of the box (in the bundles and in the migration tool), is only compatible for these versions.

Resolution

When you use PostgreSQL 9.6 or higher, you need to use the relevant jdbc driver for your version.

1.Go to PostgreSQL JDBC driver download page: https://jdbc.postgresql.org/download.html
Download the driver that supports your PostgreSQL version (version 42.2.x when your java version is 1.8)
2. Replace it the default driver by the one you just downloaded in your install:
SETUP_TOOL/lib/ (for Bonita version 7.3+)
Or
TOMCAT_HOME/lib/bonita/ (for Bonita version < 7.3 or for Deploy bundle)
3. Re-start the server.

Notifications