Errors while loading BPM.zip to a Postgres Bonita server

Q&A
1

The attached .zip is an extract from my 6.3.7. studio and can be loaded to the local portal which is of course based on H2.
When loaded to our Bonita server with Postgres database it reports errors as also visible in attached log file.

Can somebody please help me in solving this issue?

The .zip & Log-file can be found on https://www.dropbox.com/sh/qqzsztuvzoqjtix/AADX0NILbRlvzXLoW96xlR0Xa?dl=0#sthash.cQJ7HmaB.dpuf

2

Hi Haris, not sure if you have seen my comment on your remark.

that was indeed a wrong hyperlink, it should be this one
https://www.dropbox.com/sh/qqzsztuvzoqjtix/AADX0NILbRlvzXLoW96xlR0Xa?dl=0

Can you please give me an update on the status?

3

Hi RVermeulen,

Did you configured the file: <bonita.home>\server\platform\tenant-template\conf\bonita-server.properties

For Business data data source (default name DS2 specific to business data), change the DS2 to DBMS value.

To do this:

Open <TOMCAT_HOME>/conf/bitronix-resources.properties file.
Update the value for the following settings:
    resource.ds2.driverProperties.user put your DBMS user name.
    resource.ds2.driverProperties.password put your DBMS password.
    resource.ds2.driverProperties.serverName put the address (IP or hostname) of your DBMS server.
    resource.ds2.driverProperties.portNumber put the port of your DBMS server.
    resource.ds2.driverProperties.databaseName put the database name.
Save and close the file.

In addition, change the dialect in the following file:
** <bonita.home>\server\platform\tenant-template\conf\bonita-server.properties**

before changes (MySQL example):
businessdata.hibernate.dialect=org.hibernate.dialect.H2Dialect

after changes (MySQL example):
businessdata.hibernate.dialect=org.hibernate.dialect.MySQLDialect

Best,
Florian

4

I think you didn’t put a correct dropbox link, it shows a .pptx file…

5

that was indeed a wrong one, it should be this one
https://www.dropbox.com/sh/qqzsztuvzoqjtix/AADX0NILbRlvzXLoW96xlR0Xa?dl=0

6

Thanks Florian, IT-staff here tells me indeed that they see differences between current set-up and what you have underlined in your answer.

7

Sorry but I have no tips for your problem, I just wanted to warn you that your attachment was wrong, so that someone could try to help you.

8

Florian,

We did but we still have some issues with uploading the bdm.zip
Portal note is:
USERNAME=install | org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.PostgreSQLDialect

So there is something wrong with org.hibernate.dialect.PostgreSQLDialect config
in my bonita-server.properties file

i already tried org.hibernate.dialect.PostgressDialect

( I change this in template and tenants)

Whe are using postgress 9.3 and the tomacat bundel

regards,
Mark