Errors while loading BPM.zip to a Postgres Bonita server
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=...
I think you didn't put a correct dropbox link, it shows a .pptx file...
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...
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
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?
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.