#database

Upload excel file format to database

Hello everyone, how to upload excel file format (xls or csv) to database in bonita?

Table filled with null each row

Hello Everyone,

Currently im having an issue with my table row. almost all of my table row filled with null. Does anybody here ever experienced this problem? what are the solution to overcome this? and what makes the row filled with null by itself? Here I give you screenshot of my table.
https://www.dropbox.com/s/27cvjfaiky1667i/row%20terisi%20null.PNG?dl=0

Has anyone faced the ORA-01691 unable to extend lob segment problem?

Hi,

we are using bonita bpm community edition 7.7.4 with an oracle 12c enterprise database.
We started with a fresh user schema, but after a few weeks of usage the error occured the first time.

Right now bonita tries to extend the lobsegment area by ~ 5GB of data... which is (even with the autoextend options) not possible...

We have removed all active process instances, but the problem still comes up...

Anyone has or had the same problem or can anyone tell me where to find the data, which our bonita node tries to write into the database?

Can the application be deployed locally?

My customer security requirements wont allow their data to be hosted off site.
Can the application and data be deployed/hoted locally?

How to use DB in-connector?

I want to get data from the database and display it on the WEB screen table.

However, although it seems to use DB connector for the entrance connector, I do not know what to do in "definition of output operation".

Can you tell me what to do?

How to avoid using XA data source, when both the business-db and bonita-db in same host?

I'm using Bonita 7.6.1 with Mysql 5.7.

How to avoid usage of XA data source/connector when both Bonita and business databases in the same host. I've seen the non-XA datasources defined somewhere in the configuration, but I couldn't find where to specify it, so that Bonita will use the non-XA data sources.

Way to connect to my simple form application with postgres database, as by default we are on H2 db?

In the documentation you have given quite difficult approach to connect to any database. Please provide some easy way to do the same thing.

How to write dynamic query in bonita studio bdm?

I have five filter fields in my application home page (dashboard -> where I am showing all the records from h2 DB) now I want to filter the records on these fields basis.
It may require 31 (2^5 -1) queries, some are already provided as default queries.

Isn't there a way to write a dynamic query in "custom queries" or somewhere to get the desired result at UI?

Hash Algorithm for saved password in bonita database

Dear All
Hi
I want to retrieve the passwords that saved in "user" table in Bonita database. By the way, i think it has saved by hash algorithm. for example for default password (bpm) the "LcTkpvvquKf4KO+prsfXrQ==" value saved in database. My question is how can i retrieve the passwords?

Thanks in advance
REZA

Error Encountered When Running Processes in Bonita after Setting up a Database Connector

Hi Guys,

I have a database connector that executes an insert statement. I created a variable that will be used in insert statement and then I run the process. I also try insert statement with values without using the variable to see if it really inserts data but encountered the error below.

Notifications