Problems with BBDD Bonita

1
0
-1

We have problems when synchronizing Bonitasoft with SQL Server, many problems, some tables are created if others do not, they give us errors when creating the business objects in Bonitasoft, is there any version of Bonitasoft that comes already installed by default with SQL Server or MySql?

Is there any expert person who can solve the problem by remote desktop or some Bonitasoft service?

Nor does it allow us to access the H2 database, it gives us many errors, for example:

Broken connection: "java.net.ConnectException: Connection refused: connect: localhost: 9091"
Connection is broken: "java.net.ConnectException: Connection refused: connect: localhost: 9091" [90067-175] 90067/90067 (Help)

Thank you very much.

Comments

Submitted by Sean McP on Tue, 05/09/2017 - 21:32

what version are you using? also community or subscription?

Submitted by josejaviercasquero on Wed, 05/10/2017 - 08:17

My company uses the community version

Submitted by Sean McP on Wed, 05/10/2017 - 08:35

what version 6 or 7 7.1 7.2.1 etc...

Submitted by josejaviercasquero on Wed, 05/10/2017 - 08:41

I am sorry.
We have 7.4.3

Submitted by Sean McP on Wed, 05/10/2017 - 23:04

I'm Confused...

but the easy question first... is there any version of Bonitasoft that comes already installed by default with SQL Server or MySql? No

What do you mean by this...

We have problems when synchronizing Bonitasoft with SQL Server, many problems, some tables are created if others do not, they give us errors when creating the business objects in Bonitasoft

When you say ...they give us errors... why didn't you include the errors? We're not mind readers...please give us the information we need to help you.

Then you say:

Nor does it allow us to access the H2 database, it gives us many errors

If you are using SQL Server (assumed from the first question) then of course you will not be able to use the h2 database...you're not using it!

When asking questions please try to be clear, and give as much information about the error as possible.

1) What are you trying to do
2) What you did/tried to do
3) What the error was

regards

Submitted by josejaviercasquero on Thu, 05/11/2017 - 13:21

Hello,

Sorry for the confusion.

The only thing we need is to see the Bonita tables that come by default, we want to see the tables where Bonita saves the users of the login, we want to see the tables where it saves the names of the tasks, the names of the processes, etc etc, for Get information and KPIs.

We have seen some online manual on how to do this, but the manuals are not very specific.

My version installed in the company is 7.4.3.

Also my company wants to know how much the payment version is worth, and know what advantages it has.

Thank you very much
Best regards

1 answer

1
0
-1
This one is the BEST answer!

OK...now I kow what you want to do:

The only thing we need is to see the Bonita tables that come by default, we want to see the tables where Bonita saves the users of the login, we want to see the tables where it saves the names of the tasks, the names of the processes, etc etc, for Get information and KPIs.

I'm assuming Windows - If Linux - you have to modify this for your self...

  1. Download and Install Bonitasoft Studio
  2. Open Studio,wait until its finished setting up and then exit
  3. Goto the directory {{BonitaInstallDirectory}}\workspace\tomcat\server\lib\bonita
  4. Open h2-1.3.175.jar (double click)
  1. Saved Settings = Generic H2 (Server)
  2. Driver Class = org.h2.Driver
  3. jdbc:h2:file: {{BonitaInstallDirectory}}\workspace\default\h2_database\bonita_journal.db
  4. user name = sa
  5. password = (leave blank)
  1. Click Connect

and there you have it all the Bonitasoft tables as already described...

Regarding the paid for version you can only talk to Bonitasoft - use their official form here

regards
Seán

PS: As this reply answers your question, please mark as resolved.

Comments

Submitted by josejaviercasquero on Fri, 05/12/2017 - 09:09

Hello,

Thank you very much for the information, I can already see the tables of Bonita,

One last question, what are the tables where you see the tasks and processes of Bonita?

Thank you very much

Submitted by Sean McP on Fri, 05/12/2017 - 12:11

yep - sorry but they are there, I don't have time, this is on you I'm afraid...

regards

Submitted by josejaviercasquero on Fri, 05/12/2017 - 12:13

No problem,

Thank you

Submitted by Sean McP on Fri, 05/12/2017 - 21:28

But you could mark it as resolved to show others that it has been sorted out,

regards :)

Submitted by josejaviercasquero on Tue, 05/16/2017 - 10:30

Where is it marked as resolved?

Testing
Notifications