Errors while loading BPM.zip to a Postgres Bonita server

1
0
-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=...

Comments

Submitted by haris.subasic on Wed, 11/12/2014 - 09:51

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

Submitted by RVermeulen on Wed, 11/12/2014 - 10:40
Submitted by RVermeulen on Thu, 11/13/2014 - 14:35

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

2 answers

1
+1
-1
This one is the BEST answer!

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 - See more at: http://documentation.bonitasoft.com/database-configuration-0#configdatas...

Best, Florian

Comments

Submitted by mmeijer on Fri, 11/14/2014 - 10:20

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

1
0
-1

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?

Comments

Submitted by haris.subasic on Thu, 11/13/2014 - 09:21

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.

Notifications